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 |
|---|---|---|---|---|---|---|---|
| 130 | 32 | 7 | 38.6 | 40.548 | 18.057 | 51.93 | 27.56 |
| 43 | 77 | 7 | 44.283 | 46.367 | 17.524 | 50.58 | 23.29 |
| 234 | 84 | 7 | 58.65 | 59.214 | 26.103 | 73.86 | 27.73 |
| 126 | 152 | 7 | 23.033 | 23.533 | 4.531 | 19.14 | 13.19 |
| 36 | 166 | 7 | 33.933 | 32.45 | 11.17 | 34.43 | 19.62 |
| 247 | 145 | 7 | 27.7 | 30.098 | 7.777 | 26.93 | 17.28 |
| 93 | 17 | 7 | 29.667 | 31.819 | 12.209 | 36 | 23.26 |
| 78 | 166 | 7 | 30.55 | 29.5 | 6.657 | 24.1 | 14.08 |
| 9 | 260 | 7 | 24.7 | 23.883 | 8.716 | 27.08 | 23.06 |
| 195 | 236 | 7 | 35.933 | 39.086 | 11.539 | 36.93 | 19.15 |
| 54 | 37 | 7 | 24.567 | 24.879 | 4.99 | 20.21 | 12.44 |
| 181 | 135 | 7 | 32.2 | 32.962 | 12.637 | 37.43 | 24.18 |
| 86 | 169 | 7 | 69.1 | 72.838 | 26.744 | 80.07 | 22.93 |
| 130 | 167 | 7 | 51.333 | 50.345 | 16.329 | 51.03 | 20.41 |
| 71 | 50 | 7 | 52.45 | 53.988 | 11.727 | 42.03 | 13.17 |
| 159 | 148 | 7 | 36.35 | 39.088 | 9.727 | 34 | 17.33 |
| 113 | 86 | 7 | 58.533 | 60.002 | 23.401 | 68.8 | 25.84 |
| 133 | 135 | 7 | 55.283 | 53.579 | 17.65 | 54.02 | 20.94 |
| 167 | 208 | 7 | 16.033 | 16.071 | 5.787 | 18.79 | 21.76 |
| 259 | 237 | 7 | 44.417 | 52.286 | 13.936 | 45.6 | 18.39 |
| 222 | 215 | 7 | 19.583 | 18.924 | 8.329 | 24.35 | 26.98 |
| 244 | 258 | 7 | 37.533 | 48.574 | 18.587 | 55.29 | 25.56 |
| 205 | 157 | 7 | 41.033 | 45.188 | 10.531 | 35.66 | 14.91 |
| 49 | 155 | 6 | 31.325 | 33.342 | 9.413 | 30.4 | 18.58 |
| 238 | 19 | 6 | 42.667 | 42.556 | 20.238 | 57.33 | 29.08 |