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 |
|---|---|---|---|---|---|---|---|
| 230 | 228 | 974 | 32.1 | 34.132 | 10.509 | 33.89 | 19.6 |
| 4 | 75 | 973 | 17.7 | 19.21 | 5.645 | 19.49 | 19.33 |
| 188 | 188 | 973 | 5.467 | 7.082 | 1.205 | 7.05 | 50.33 |
| 75 | 232 | 973 | 19.317 | 20.629 | 6.686 | 21.78 | 21.6 |
| 125 | 25 | 972 | 17.933 | 18.861 | 3.722 | 15.41 | 12.53 |
| 88 | 256 | 972 | 19.558 | 20.534 | 4.531 | 17.97 | 13.89 |
| 33 | 144 | 969 | 13.8 | 14.929 | 2.827 | 12.87 | 12.29 |
| 148 | 106 | 968 | 18.942 | 19.685 | 4.711 | 17.95 | 14.85 |
| 233 | 24 | 967 | 22.583 | 23.7 | 4.758 | 18.97 | 12.92 |
| 75 | 7 | 967 | 20.8 | 22.744 | 5.599 | 20.53 | 16.45 |
| 244 | 236 | 967 | 24.667 | 25.33 | 5.864 | 22.17 | 14.74 |
| 114 | 179 | 966 | 26.083 | 27.353 | 7.38 | 25.3 | 17.18 |
| 143 | 261 | 966 | 26.967 | 27.834 | 5.658 | 22.49 | 12.91 |
| 239 | 129 | 965 | 31.383 | 32.666 | 7.682 | 28.06 | 14.78 |
| 230 | 69 | 964 | 24.975 | 27.278 | 8.086 | 26.8 | 18.99 |
| 13 | 52 | 964 | 14.95 | 15.968 | 4.015 | 14.89 | 16.46 |
| 232 | 80 | 964 | 11.183 | 12.246 | 3.122 | 12.56 | 17.31 |
| 41 | 100 | 964 | 24.033 | 25.05 | 4.771 | 19.75 | 12.56 |
| 26 | 26 | 964 | 7.842 | 9.234 | 1.078 | 7.9 | 17.65 |
| 158 | 40 | 963 | 21.5 | 22.607 | 5.42 | 19.73 | 15.21 |
| 12 | 162 | 961 | 20.4 | 22.296 | 5.93 | 21.25 | 17.35 |
| 142 | 66 | 961 | 34.017 | 35.534 | 8.318 | 30.06 | 14.87 |
| 142 | 25 | 961 | 34.55 | 35.816 | 8.796 | 30.91 | 15.46 |
| 236 | 69 | 960 | 20.008 | 21.708 | 4.809 | 18.39 | 14.62 |
| 144 | 166 | 960 | 29.042 | 30.953 | 7.897 | 28.03 | 16.17 |