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 |
|---|---|---|---|---|---|---|---|
| 72 | 48 | 24 | 59.292 | 59.151 | 12.185 | 42.97 | 13.29 |
| 89 | 114 | 24 | 42.717 | 41.535 | 9.28 | 34.48 | 13.96 |
| 164 | 84 | 24 | 52.367 | 56.394 | 28.24 | 79.23 | 31.2 |
| 112 | 244 | 24 | 34.025 | 35.966 | 12.62 | 39.29 | 22.63 |
| 226 | 98 | 24 | 22.283 | 25.332 | 9.374 | 28.99 | 25.25 |
| 24 | 149 | 24 | 80.675 | 80.438 | 18.252 | 60.1 | 13.84 |
| 134 | 43 | 24 | 26.392 | 28.183 | 11.238 | 41.52 | 24.35 |
| 93 | 173 | 24 | 8.317 | 11.763 | 2.907 | 10.19 | 12.62 |
| 91 | 65 | 24 | 40.792 | 40.623 | 7.694 | 29.26 | 11.75 |
| 239 | 98 | 24 | 47.617 | 47.873 | 15.415 | 48.25 | 20.06 |
| 61 | 161 | 24 | 44.717 | 46.198 | 9.558 | 35.26 | 13.07 |
| 189 | 34 | 24 | 12.317 | 12.627 | 1.873 | 10.12 | 9.25 |
| 185 | 174 | 24 | 16.117 | 17.481 | 3.606 | 15.02 | 12.6 |
| 61 | 133 | 24 | 21.633 | 24.533 | 4.6 | 19.31 | 12.06 |
| 88 | 108 | 24 | 33.217 | 33.624 | 13.158 | 38.98 | 25.15 |
| 17 | 129 | 24 | 24.033 | 25.069 | 7.394 | 24.94 | 18.89 |
| 198 | 140 | 24 | 35.183 | 35.786 | 7.458 | 27.97 | 13.73 |
| 51 | 247 | 24 | 26.283 | 29.233 | 9.123 | 29.23 | 20.88 |
| 166 | 195 | 24 | 42.483 | 44.007 | 12.432 | 41.02 | 18.1 |
| 83 | 231 | 24 | 28.3 | 28.715 | 9.685 | 31.77 | 21.65 |
| 212 | 142 | 24 | 23.85 | 26.118 | 10.888 | 33.03 | 26.9 |
| 89 | 79 | 24 | 32.867 | 34.011 | 9.14 | 30.61 | 16.88 |
| 82 | 41 | 24 | 29.45 | 30.719 | 8.801 | 29.6 | 18.35 |
| 100 | 118 | 24 | 45.967 | 48.347 | 20.217 | 59.25 | 25.42 |
| 218 | 35 | 24 | 33.4 | 34.89 | 8.804 | 30.44 | 15.65 |