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 |
|---|---|---|---|---|---|---|---|
| 190 | 257 | 72 | 7.258 | 8.881 | 1.707 | 8.53 | 12.97 |
| 107 | 117 | 72 | 78.933 | 79.019 | 26.486 | 75.81 | 20.96 |
| 42 | 20 | 72 | 20.117 | 23.293 | 5.728 | 21.02 | 16.27 |
| 151 | 254 | 72 | 30.6 | 33.283 | 12.18 | 37.12 | 23.44 |
| 230 | 218 | 72 | 47.658 | 53.104 | 17.742 | 54.39 | 21.87 |
| 143 | 195 | 71 | 33.2 | 35.006 | 9.32 | 31.54 | 16.5 |
| 244 | 87 | 71 | 35.75 | 37.199 | 11.891 | 37.29 | 20.71 |
| 76 | 197 | 71 | 21.283 | 22.765 | 4.992 | 19.57 | 13.73 |
| 160 | 95 | 71 | 12.35 | 13.88 | 2.71 | 12.2 | 12.93 |
| 205 | 216 | 71 | 17.783 | 19.204 | 4.055 | 16.48 | 13.24 |
| 170 | 118 | 71 | 44.533 | 44.846 | 20.876 | 58.8 | 28.63 |
| 129 | 73 | 71 | 21.233 | 21.68 | 5.569 | 20.37 | 16.14 |
| 134 | 121 | 71 | 7.85 | 8.912 | 2.092 | 9.19 | 15.71 |
| 247 | 238 | 71 | 23.167 | 23.442 | 4.817 | 20.07 | 12.89 |
| 133 | 227 | 71 | 9.8 | 11.732 | 2.079 | 10.12 | 11.54 |
| 100 | 9 | 71 | 35.967 | 37.333 | 13.452 | 41.11 | 23.63 |
| 236 | 78 | 71 | 27.833 | 29.385 | 7.994 | 27.48 | 18.27 |
| 238 | 225 | 71 | 44.5 | 46.146 | 12.325 | 41.6 | 16.71 |
| 152 | 128 | 71 | 14.133 | 14.714 | 5.198 | 17.34 | 22.11 |
| 130 | 13 | 71 | 40.217 | 43.583 | 17.396 | 52.38 | 25.99 |
| 144 | 71 | 71 | 29.183 | 32.044 | 7.813 | 27.75 | 15.79 |
| 89 | 17 | 71 | 23.667 | 24.145 | 4.358 | 18.33 | 11.43 |
| 228 | 90 | 71 | 41.217 | 40.294 | 8.715 | 32.35 | 14.68 |
| 143 | 216 | 71 | 55.9 | 63.475 | 17.643 | 53.81 | 18.63 |
| 237 | 215 | 71 | 58.25 | 57.472 | 15.576 | 50.59 | 18.16 |