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 |
|---|---|---|---|---|---|---|---|
| 129 | 50 | 53 | 35.667 | 38.297 | 8.422 | 31.36 | 14.03 |
| 236 | 218 | 53 | 55.75 | 56.291 | 18.108 | 54.75 | 20.41 |
| 50 | 194 | 53 | 26.8 | 28.469 | 8.07 | 28.23 | 17.61 |
| 10 | 202 | 53 | 40.033 | 38.188 | 13.708 | 49.87 | 23.27 |
| 66 | 227 | 53 | 18.317 | 20.677 | 6.009 | 21.16 | 19.69 |
| 247 | 20 | 53 | 19.433 | 20.754 | 3.928 | 16.51 | 11.86 |
| 140 | 98 | 53 | 40.5 | 41.208 | 14.432 | 43.65 | 22.3 |
| 49 | 246 | 53 | 30.933 | 31.105 | 6.507 | 25.37 | 13.17 |
| 158 | 160 | 53 | 35.083 | 37.541 | 10.432 | 34.84 | 17.4 |
| 65 | 116 | 53 | 41.95 | 43.478 | 12.63 | 41.38 | 19.82 |
| 159 | 137 | 53 | 25.65 | 28.667 | 7.876 | 26.84 | 19.06 |
| 49 | 233 | 53 | 29.533 | 28.94 | 7.649 | 26.41 | 17.13 |
| 131 | 161 | 53 | 51.933 | 50.481 | 14.687 | 45.2 | 18.78 |
| 226 | 35 | 53 | 37.933 | 42.814 | 12.015 | 39.38 | 19.05 |
| 72 | 33 | 53 | 39.6 | 39.653 | 5.725 | 26.39 | 9.02 |
| 79 | 131 | 53 | 30.767 | 33.546 | 14.582 | 42.14 | 27.47 |
| 40 | 163 | 53 | 36.55 | 36.586 | 8.663 | 31.13 | 15.44 |
| 56 | 211 | 53 | 30.067 | 30.689 | 9.755 | 49.91 | 21.53 |
| 260 | 181 | 53 | 21.467 | 27.172 | 8.522 | 27.82 | 20.97 |
| 166 | 182 | 53 | 26.467 | 29.87 | 8.673 | 28.85 | 19.04 |
| 151 | 93 | 53 | 34.417 | 39.248 | 13.656 | 41.84 | 22.88 |
| 49 | 232 | 53 | 18.983 | 18.602 | 4.166 | 16.46 | 13.93 |
| 48 | 203 | 52 | 70.45 | 73.936 | 21.475 | 68.53 | 19.63 |
| 62 | 91 | 52 | 22.217 | 22.063 | 4.019 | 16.98 | 11.3 |
| 193 | 196 | 52 | 25.35 | 28.695 | 7.042 | 25.43 | 15.85 |