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 |
|---|---|---|---|---|---|---|---|
| 234 | 82 | 655 | 28.55 | 30.542 | 7.886 | 27.55 | 16.68 |
| 163 | 52 | 655 | 33.317 | 34.343 | 8.278 | 29.29 | 15.78 |
| 255 | 232 | 654 | 12.108 | 13.603 | 2.632 | 11.96 | 13.18 |
| 226 | 100 | 653 | 22.367 | 24.901 | 4.355 | 32.22 | 12.14 |
| 255 | 144 | 652 | 16.383 | 17.493 | 3.105 | 14.23 | 11.75 |
| 87 | 106 | 652 | 18.833 | 19.535 | 4.3 | 16.62 | 13.85 |
| 146 | 263 | 652 | 11.35 | 12.835 | 3.041 | 12.22 | 15.89 |
| 164 | 188 | 651 | 34.1 | 36.665 | 9.015 | 31.57 | 15.54 |
| 230 | 198 | 651 | 30.85 | 32.615 | 8.09 | 28.45 | 15.53 |
| 237 | 69 | 651 | 23.917 | 26.158 | 6.158 | 22.42 | 15.41 |
| 138 | 122 | 650 | 25.217 | 28.446 | 10.364 | 31.87 | 24.17 |
| 152 | 68 | 650 | 19.85 | 21.5 | 6.193 | 21.87 | 18.49 |
| 209 | 49 | 650 | 17.9 | 18.896 | 3.638 | 15.16 | 12.13 |
| 215 | 230 | 649 | 45.483 | 46.866 | 14.011 | 52.2 | 19.7 |
| 238 | 69 | 649 | 23.367 | 25.456 | 5.711 | 21.42 | 14.69 |
| 52 | 138 | 649 | 24.167 | 26.893 | 11.74 | 34.32 | 28.71 |
| 246 | 146 | 648 | 21.383 | 23.466 | 5.188 | 19.76 | 14.31 |
| 129 | 56 | 647 | 12.217 | 13.013 | 2.598 | 11.49 | 12.39 |
| 238 | 159 | 646 | 21.333 | 22.528 | 4.985 | 19.26 | 14.22 |
| 88 | 89 | 646 | 22.233 | 24.299 | 7.144 | 24.07 | 19 |
| 97 | 37 | 645 | 17.7 | 18.692 | 3.561 | 15.17 | 11.98 |
| 100 | 193 | 645 | 22.283 | 24 | 4.459 | 18.89 | 12.07 |
| 247 | 168 | 645 | 7.717 | 8.672 | 1.479 | 8.07 | 11.03 |
| 170 | 36 | 645 | 29.65 | 31.079 | 7.483 | 26.83 | 15.44 |
| 80 | 198 | 645 | 11.8 | 12.261 | 2.646 | 11.03 | 13.69 |