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 |
|---|---|---|---|---|---|---|---|
| 161 | 38 | 43 | 48.383 | 52.515 | 20.311 | 59.85 | 25.24 |
| 95 | 234 | 43 | 31.583 | 32.393 | 9.315 | 33.12 | 18.18 |
| 231 | 194 | 43 | 37.45 | 37.554 | 11.797 | 36.81 | 21.06 |
| 233 | 124 | 43 | 39.967 | 44.295 | 12.974 | 42.32 | 18.97 |
| 246 | 47 | 43 | 27.95 | 29.733 | 11.02 | 33.94 | 23.97 |
| 145 | 243 | 43 | 28.5 | 26.993 | 10.26 | 31.54 | 23.93 |
| 45 | 21 | 43 | 30.05 | 31.664 | 11.329 | 34.88 | 22.72 |
| 209 | 220 | 43 | 36.833 | 45.606 | 15.018 | 47.01 | 23.31 |
| 56 | 246 | 43 | 32.083 | 31.726 | 9.159 | 49.93 | 18.39 |
| 75 | 258 | 42 | 48.45 | 48.392 | 15.269 | 46.91 | 20.56 |
| 135 | 92 | 42 | 16.75 | 17.887 | 4.034 | 16.31 | 15.08 |
| 37 | 234 | 42 | 30.025 | 33.496 | 5.618 | 24.38 | 11.14 |
| 113 | 20 | 42 | 45.642 | 45.608 | 14.406 | 45.44 | 20.57 |
| 50 | 126 | 42 | 28.142 | 32.269 | 11.885 | 35.55 | 24.61 |
| 100 | 8 | 42 | 23.35 | 27.154 | 6.185 | 23.56 | 14.26 |
| 223 | 114 | 42 | 30.4 | 32.219 | 9.853 | 33.37 | 19.8 |
| 106 | 256 | 42 | 19.217 | 21.352 | 5.073 | 19.26 | 15.69 |
| 95 | 237 | 42 | 33.633 | 36.867 | 9.513 | 33.9 | 16.6 |
| 50 | 71 | 42 | 46.6 | 50.604 | 12.338 | 42.92 | 15.73 |
| 65 | 134 | 42 | 29.717 | 33.852 | 12.684 | 38.07 | 25.37 |
| 211 | 134 | 42 | 38.342 | 44.572 | 14.274 | 45.54 | 21.57 |
| 186 | 240 | 42 | 36.592 | 39.456 | 14.777 | 45 | 24.54 |
| 131 | 95 | 42 | 19.967 | 20.614 | 4.77 | 18.62 | 15.07 |
| 82 | 135 | 42 | 12.792 | 13.48 | 4.598 | 15.73 | 23.94 |
| 171 | 162 | 42 | 88.725 | 82.402 | 15.725 | 62.62 | 13.33 |