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 |
|---|---|---|---|---|---|---|---|
| 138 | 190 | 588 | 38.642 | 41.242 | 12.145 | 39.27 | 19.46 |
| 161 | 193 | 588 | 16.833 | 18.732 | 3.62 | 15.51 | 12.49 |
| 143 | 232 | 588 | 28.283 | 29.52 | 6.324 | 24.47 | 13.71 |
| 237 | 37 | 588 | 31.917 | 33.133 | 7.566 | 27.81 | 14.3 |
| 144 | 116 | 587 | 30.217 | 32.174 | 9.851 | 32.39 | 19.25 |
| 114 | 260 | 587 | 23.383 | 25.615 | 7.601 | 25.9 | 19.33 |
| 181 | 14 | 587 | 17.217 | 18.35 | 5.493 | 19.17 | 19.07 |
| 262 | 194 | 587 | 11.617 | 13.351 | 4.025 | 15.93 | 19.95 |
| 79 | 54 | 587 | 20.7 | 21.661 | 5.251 | 19.25 | 15.42 |
| 107 | 152 | 587 | 28.117 | 29.828 | 7.637 | 26.66 | 16.47 |
| 209 | 238 | 586 | 27.083 | 28.659 | 7.968 | 27.29 | 17.83 |
| 138 | 22 | 586 | 44.867 | 49.342 | 19.063 | 55.38 | 26.25 |
| 75 | 119 | 585 | 14.033 | 16.223 | 4.337 | 15.75 | 18.41 |
| 4 | 239 | 585 | 24.133 | 25.954 | 5.774 | 21.7 | 14.15 |
| 249 | 260 | 585 | 27.417 | 28.857 | 7.854 | 26.98 | 17.44 |
| 138 | 248 | 585 | 21.683 | 24.183 | 9.272 | 28.59 | 25 |
| 114 | 12 | 584 | 13.15 | 13.75 | 2.495 | 11.59 | 11.65 |
| 79 | 202 | 584 | 22.383 | 23.351 | 6.01 | 20.77 | 16.4 |
| 90 | 228 | 584 | 27.517 | 29.587 | 8.589 | 28.53 | 18.58 |
| 125 | 12 | 584 | 11.217 | 11.935 | 2.153 | 10.43 | 11.73 |
| 100 | 220 | 583 | 25.983 | 29.06 | 11.345 | 34.61 | 25.37 |
| 162 | 36 | 583 | 29.967 | 31.746 | 7.724 | 27.46 | 15.48 |
| 232 | 262 | 583 | 16.883 | 18.171 | 5.552 | 18.96 | 19.8 |
| 209 | 61 | 582 | 23.517 | 25.752 | 5.229 | 20.49 | 13.07 |
| 129 | 146 | 582 | 11.567 | 12.008 | 2.671 | 11.2 | 14.9 |