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 |
|---|---|---|---|---|---|---|---|
| 39 | 232 | 14 | 53.25 | 53.779 | 14.342 | 46.8 | 16.69 |
| 4 | 51 | 14 | 44.308 | 58.102 | 17.504 | 55.5 | 22.63 |
| 203 | 93 | 14 | 35.35 | 36.323 | 11.486 | 33.15 | 19.75 |
| 235 | 246 | 14 | 21.325 | 24.164 | 9.538 | 28.82 | 26.44 |
| 215 | 35 | 14 | 34.75 | 35.552 | 9.811 | 32.33 | 16.91 |
| 24 | 20 | 14 | 30.275 | 30.882 | 8.751 | 29.46 | 17.98 |
| 97 | 111 | 14 | 20.975 | 20.85 | 3.549 | 15.18 | 11 |
| 257 | 91 | 14 | 20.867 | 23.019 | 4.054 | 17.68 | 10.92 |
| 228 | 170 | 14 | 37.567 | 37.988 | 9.503 | 32.21 | 16.14 |
| 32 | 145 | 14 | 47 | 46.38 | 12.646 | 39.4 | 16.78 |
| 61 | 51 | 14 | 46.558 | 47.608 | 21.058 | 59.97 | 27.28 |
| 202 | 260 | 14 | 18.717 | 19.432 | 3.471 | 15.18 | 11.16 |
| 93 | 53 | 14 | 12.625 | 11.9 | 3.753 | 13.46 | 20.52 |
| 129 | 126 | 14 | 21.908 | 22.165 | 8.411 | 26.25 | 23.67 |
| 194 | 7 | 14 | 15.283 | 16.47 | 4.411 | 15.79 | 16.61 |
| 15 | 170 | 14 | 38.775 | 38.471 | 14.635 | 44.01 | 24.18 |
| 29 | 133 | 14 | 23.8 | 23.315 | 4.452 | 18.2 | 12.42 |
| 88 | 180 | 14 | 44.042 | 43.37 | 15.743 | 48 | 22.92 |
| 158 | 192 | 14 | 35.767 | 36.035 | 12.866 | 39.82 | 22.46 |
| 32 | 223 | 14 | 31.242 | 31.877 | 10.443 | 33.29 | 20.09 |
| 158 | 130 | 14 | 38.383 | 37.32 | 15.317 | 44.96 | 25.52 |
| 247 | 120 | 14 | 12.067 | 12.239 | 2.079 | 10.43 | 11.49 |
| 233 | 122 | 14 | 36.058 | 39.957 | 14.135 | 41.52 | 22.84 |
| 223 | 102 | 14 | 23.525 | 26.613 | 8.564 | 27.93 | 22.36 |
| 9 | 98 | 14 | 8.617 | 9.956 | 1.389 | 8.68 | 9.45 |