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 |
|---|---|---|---|---|---|---|---|
| 233 | 193 | 306 | 15.35 | 16.284 | 3.339 | 13.9 | 13.13 |
| 65 | 263 | 306 | 23.317 | 25.837 | 8.493 | 26.92 | 21.72 |
| 97 | 114 | 306 | 14.95 | 16.158 | 3.352 | 14.32 | 13.25 |
| 141 | 62 | 306 | 40.6 | 42.92 | 11.001 | 37.19 | 16.27 |
| 186 | 39 | 306 | 57.675 | 60.797 | 17.735 | 57.8 | 18.56 |
| 21 | 21 | 306 | 0.95 | 3.33 | 0.736 | 4.82 | 34.7 |
| 43 | 95 | 306 | 34.658 | 37.346 | 10.17 | 34.82 | 18.52 |
| 145 | 50 | 306 | 23.258 | 24.108 | 4.129 | 36.36 | 11.31 |
| 141 | 119 | 305 | 19.083 | 21.993 | 6.465 | 21.8 | 19.72 |
| 179 | 163 | 305 | 18.067 | 20.131 | 4.026 | 17.41 | 13.23 |
| 45 | 89 | 305 | 23.417 | 25.258 | 7.023 | 24.2 | 18.03 |
| 158 | 179 | 305 | 31.617 | 32.955 | 8.111 | 28.51 | 15.38 |
| 74 | 45 | 305 | 22.433 | 25.446 | 8.626 | 27.38 | 23.15 |
| 45 | 41 | 305 | 31.483 | 34.156 | 9.055 | 31.15 | 17.5 |
| 186 | 165 | 305 | 44.1 | 45.891 | 12.256 | 41.09 | 16.97 |
| 95 | 28 | 305 | 9.417 | 10.432 | 2.363 | 10.2 | 14.33 |
| 74 | 231 | 305 | 29.067 | 29.937 | 9.443 | 30.47 | 20.92 |
| 97 | 158 | 304 | 19.275 | 20.022 | 4.292 | 17.29 | 13.48 |
| 143 | 66 | 304 | 32.908 | 33.097 | 7.987 | 28.59 | 15.22 |
| 181 | 186 | 304 | 28.483 | 30.341 | 6.583 | 25.05 | 13.96 |
| 186 | 56 | 304 | 33.283 | 35.275 | 9.338 | 32.47 | 17.5 |
| 41 | 148 | 304 | 28.433 | 30.328 | 8.582 | 28.72 | 18.24 |
| 237 | 119 | 304 | 20.767 | 23.342 | 6.504 | 22.31 | 18.8 |
| 238 | 179 | 304 | 24.983 | 26.498 | 6.605 | 23.92 | 15.99 |
| 236 | 126 | 304 | 22.225 | 23.097 | 5.842 | 20.8 | 16.2 |