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 |
|---|---|---|---|---|---|---|---|
| 18 | 136 | 64 | 7.1 | 8.07 | 1.058 | 7 | 8.62 |
| 189 | 233 | 64 | 28.517 | 28.836 | 7.494 | 26.35 | 16.67 |
| 19 | 191 | 64 | 7.625 | 8.715 | 1.846 | 9.91 | 14.44 |
| 18 | 174 | 64 | 7.492 | 8.791 | 1.371 | 8.12 | 9.78 |
| 237 | 128 | 64 | 28.525 | 30.442 | 9.429 | 31.01 | 19.97 |
| 260 | 125 | 64 | 27.483 | 29.662 | 7.387 | 35.96 | 16.4 |
| 146 | 8 | 64 | 9.517 | 10.553 | 2.122 | 9.82 | 13.15 |
| 234 | 51 | 64 | 37.067 | 40.336 | 16.378 | 48.14 | 26.42 |
| 223 | 65 | 64 | 36.058 | 36.877 | 9.448 | 32.01 | 17.67 |
| 114 | 216 | 64 | 46.042 | 47.979 | 16.406 | 49.7 | 22.85 |
| 129 | 68 | 64 | 30.95 | 34.37 | 8.368 | 29.9 | 15.8 |
| 113 | 169 | 64 | 31.208 | 33.723 | 11.653 | 36.11 | 22.5 |
| 90 | 39 | 64 | 51.425 | 55.464 | 15.304 | 50.56 | 17.18 |
| 224 | 225 | 64 | 29.308 | 29.962 | 6.158 | 23.97 | 12.93 |
| 210 | 29 | 64 | 9.425 | 9.552 | 1.814 | 9.02 | 11.53 |
| 49 | 91 | 64 | 28.608 | 30.904 | 5.75 | 23.39 | 11.89 |
| 113 | 55 | 64 | 39.975 | 41.689 | 16.095 | 47.81 | 24.19 |
| 249 | 182 | 63 | 32.917 | 36.387 | 14.383 | 42.95 | 24.81 |
| 211 | 22 | 63 | 29.5 | 32.657 | 11.117 | 34.48 | 21.93 |
| 211 | 26 | 63 | 30.5 | 32.779 | 8.782 | 29.95 | 17.46 |
| 189 | 76 | 63 | 27.117 | 28.512 | 5.676 | 22.11 | 12.32 |
| 12 | 112 | 63 | 25.967 | 26.477 | 6.616 | 23.65 | 15.62 |
| 133 | 257 | 63 | 5.917 | 8.506 | 1.674 | 8.21 | 12.27 |
| 244 | 248 | 63 | 18.55 | 19.072 | 5.138 | 18.15 | 17.49 |
| 112 | 161 | 63 | 23.633 | 25.566 | 5.375 | 21.15 | 13.6 |