Zone-to-zone routes
Every pickup zone to drop-off zone pair seen in 2019 with trips, median and mean minutes, distance, fare and speed.
45,836 rows · by trips ↓ Download CSV
| pu_idINTEGER | do_idINTEGER | tripsINTEGER | median_minREAL | mean_minREAL | mean_milesREAL | mean_fareREAL | mean_mphREAL |
|---|---|---|---|---|---|---|---|
| 170 | 91 | 209 | 47.6 | 48.814 | 14.86 | 46.82 | 18.99 |
| 7 | 238 | 209 | 23.883 | 26.041 | 6.044 | 22.33 | 14.76 |
| 52 | 148 | 209 | 13.833 | 15.068 | 3.403 | 13.93 | 14.63 |
| 162 | 190 | 209 | 35.233 | 37.151 | 9.414 | 32.82 | 16.26 |
| 144 | 127 | 209 | 31.133 | 33.402 | 12.881 | 39.32 | 24.71 |
| 80 | 249 | 209 | 20 | 21.012 | 4.808 | 22.02 | 14.46 |
| 17 | 25 | 209 | 16.317 | 17.168 | 2.616 | 13.08 | 9.94 |
| 148 | 85 | 209 | 25.733 | 28.131 | 7.435 | 25.96 | 16.57 |
| 211 | 198 | 209 | 26.967 | 29.232 | 6.76 | 25.08 | 14.75 |
| 74 | 174 | 209 | 22.917 | 25.31 | 9.005 | 28.52 | 23.58 |
| 151 | 119 | 209 | 20.95 | 22.553 | 5.542 | 20.28 | 16.2 |
| 244 | 229 | 209 | 28.783 | 30.573 | 8.069 | 28.19 | 17.82 |
| 170 | 213 | 208 | 28.558 | 32.542 | 10.304 | 32.61 | 21.36 |
| 223 | 70 | 208 | 8.742 | 9.778 | 2.763 | 11.81 | 20.04 |
| 223 | 143 | 208 | 26.808 | 29.632 | 8.059 | 39.69 | 17.81 |
| 68 | 83 | 208 | 29.008 | 31.251 | 7.622 | 27.58 | 15.76 |
| 79 | 70 | 208 | 26.983 | 29.041 | 10.319 | 32.41 | 23.69 |
| 167 | 167 | 208 | 3.917 | 6.377 | 1.085 | 7.06 | 12.3 |
| 24 | 125 | 208 | 28.067 | 29.19 | 6.92 | 25.36 | 15.03 |
| 208 | 208 | 208 | 5.333 | 8.73 | 1.834 | 10.43 | 33.15 |
| 260 | 238 | 208 | 32.4 | 32.858 | 6.851 | 26.71 | 13.1 |
| 224 | 97 | 208 | 20.608 | 22.104 | 5.647 | 20.5 | 16.39 |
| 24 | 144 | 207 | 31.417 | 33.043 | 7.732 | 28.43 | 14.66 |
| 7 | 255 | 207 | 20.1 | 20.866 | 4.947 | 18.54 | 15.14 |
| 193 | 129 | 207 | 17.95 | 19.243 | 3.938 | 16.44 | 12.85 |