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 |
|---|---|---|---|---|---|---|---|
| 119 | 89 | 7 | 57.717 | 64.7 | 23.099 | 70.14 | 23.28 |
| 159 | 21 | 7 | 54.083 | 52.238 | 23.971 | 66.74 | 27.63 |
| 165 | 209 | 7 | 34.2 | 34.405 | 9.196 | 30.33 | 16.51 |
| 56 | 215 | 7 | 21.283 | 19.952 | 6.02 | 20.64 | 19.49 |
| 55 | 249 | 7 | 31.25 | 37.102 | 15.529 | 45.69 | 27.05 |
| 61 | 131 | 7 | 40.817 | 37.902 | 11.034 | 35.76 | 17.66 |
| 89 | 179 | 7 | 57.533 | 59.574 | 17.196 | 53.41 | 17.78 |
| 217 | 218 | 7 | 58.2 | 52.314 | 14.534 | 47.63 | 19.74 |
| 60 | 166 | 7 | 31.667 | 31.586 | 5.944 | 24.29 | 12.17 |
| 252 | 107 | 7 | 49.217 | 47.843 | 13.744 | 42.02 | 17.77 |
| 181 | 180 | 7 | 38.467 | 36.667 | 9.367 | 32.21 | 15.26 |
| 86 | 10 | 7 | 28.267 | 31.019 | 7.431 | 27.45 | 15.7 |
| 225 | 213 | 7 | 40.8 | 40.226 | 16.011 | 47.43 | 24.83 |
| 42 | 257 | 7 | 42.833 | 41.588 | 16.956 | 48.64 | 25.77 |
| 39 | 22 | 7 | 19.85 | 22.057 | 9.25 | 27.57 | 27.4 |
| 70 | 62 | 7 | 34.583 | 33.831 | 13.603 | 40.29 | 25.02 |
| 152 | 130 | 7 | 52.683 | 55.233 | 17.157 | 55.5 | 18.98 |
| 217 | 196 | 7 | 21.383 | 20.579 | 7.237 | 23.86 | 22.54 |
| 106 | 223 | 7 | 25.733 | 28.605 | 11.399 | 34.71 | 25.33 |
| 227 | 163 | 7 | 54.4 | 53.912 | 12.767 | 44.93 | 14.41 |
| 255 | 9 | 7 | 27.3 | 29.19 | 11.367 | 34 | 25.87 |
| 155 | 11 | 7 | 19.533 | 27.781 | 10.399 | 31.9 | 25.05 |
| 238 | 73 | 7 | 31.917 | 38.395 | 13.52 | 42.14 | 23.7 |
| 121 | 113 | 7 | 37.467 | 38.364 | 12.173 | 39.07 | 19.59 |
| 194 | 211 | 7 | 28.967 | 30.36 | 9.03 | 29.07 | 18.88 |