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 |
|---|---|---|---|---|---|---|---|
| 60 | 243 | 5 | 17.533 | 17.12 | 4.24 | 23.9 | 15.92 |
| 181 | 126 | 5 | 35.7 | 39.64 | 15.988 | 47.7 | 25.68 |
| 220 | 114 | 5 | 42.3 | 46.333 | 13.39 | 42.62 | 17.82 |
| 222 | 7 | 5 | 49.783 | 47.853 | 16.13 | 46.98 | 20.48 |
| 197 | 222 | 5 | 20.067 | 22.13 | 7.502 | 24.5 | 20.95 |
| 188 | 67 | 5 | 27.3 | 30.24 | 6.39 | 22.84 | 12.69 |
| 220 | 162 | 5 | 40.5 | 40.493 | 11.574 | 37.22 | 17.96 |
| 175 | 43 | 5 | 51.317 | 55.393 | 17.372 | 52.29 | 19.09 |
| 226 | 200 | 5 | 35.167 | 34.56 | 13.884 | 41.7 | 25.19 |
| 139 | 231 | 5 | 68.033 | 67.257 | 24.308 | 71.3 | 22.07 |
| 38 | 98 | 5 | 20.7 | 20.3 | 6.034 | 21.74 | 18.2 |
| 17 | 247 | 5 | 33 | 33.68 | 14.05 | 40.9 | 25.3 |
| 260 | 51 | 5 | 28.133 | 29.717 | 15.486 | 43.9 | 32.37 |
| 56 | 117 | 5 | 46.083 | 49.82 | 14.34 | 47.3 | 17.73 |
| 82 | 177 | 5 | 29.933 | 29.643 | 10.596 | 34 | 23.01 |
| 259 | 126 | 5 | 24.15 | 23.953 | 7.568 | 24.77 | 23.41 |
| 222 | 112 | 5 | 43.167 | 42.8 | 15.242 | 51.25 | 23.26 |
| 135 | 127 | 5 | 33.633 | 33.053 | 15.564 | 45.5 | 28.47 |
| 21 | 234 | 5 | 42.167 | 40.753 | 12.734 | 37.69 | 17.96 |
| 219 | 179 | 5 | 41.55 | 38.847 | 13.988 | 41.3 | 22.05 |
| 122 | 72 | 5 | 41.067 | 40.097 | 13.97 | 43.1 | 21.21 |
| 131 | 93 | 5 | 17.183 | 14.353 | 4.64 | 16.2 | 20.82 |
| 147 | 228 | 5 | 40.517 | 42.07 | 18.516 | 52.85 | 27.78 |
| 139 | 196 | 5 | 36.017 | 40.713 | 9.428 | 33.8 | 14.71 |
| 197 | 9 | 5 | 27.7 | 25.397 | 7.854 | 22.69 | 18.89 |