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 |
|---|---|---|---|---|---|---|---|
| 232 | 35 | 78 | 40.083 | 40.847 | 7.793 | 30.07 | 12.19 |
| 196 | 100 | 78 | 24.033 | 25.461 | 8.157 | 46.57 | 21.01 |
| 263 | 133 | 78 | 32.7 | 33.075 | 13.626 | 39.89 | 25.88 |
| 112 | 66 | 78 | 15.083 | 16.383 | 4.664 | 16.29 | 19.29 |
| 262 | 257 | 78 | 28.55 | 30.449 | 12.405 | 36.55 | 26.49 |
| 25 | 129 | 78 | 21.842 | 23.343 | 9.064 | 28.03 | 25.16 |
| 164 | 124 | 78 | 40.033 | 43.394 | 14.658 | 45.65 | 21.86 |
| 74 | 216 | 78 | 35.283 | 36.304 | 14.771 | 48.36 | 28.29 |
| 218 | 216 | 78 | 12.358 | 13.42 | 3.537 | 13.52 | 15.61 |
| 189 | 36 | 78 | 22.375 | 23.622 | 4.867 | 19.18 | 12.86 |
| 43 | 160 | 78 | 32.767 | 34.716 | 8.722 | 30.68 | 15.66 |
| 81 | 242 | 78 | 14.267 | 15.75 | 3.767 | 14.96 | 15.12 |
| 67 | 22 | 78 | 8.142 | 9.588 | 1.642 | 8.56 | 10.57 |
| 74 | 112 | 78 | 23.567 | 25.958 | 7.927 | 26.22 | 19.5 |
| 37 | 77 | 78 | 16.383 | 18.316 | 3.082 | 14.05 | 10.89 |
| 61 | 222 | 78 | 19.875 | 21.248 | 4.133 | 17.23 | 12.1 |
| 166 | 120 | 78 | 14.392 | 14.819 | 3.273 | 13.4 | 13.8 |
| 136 | 241 | 78 | 6.483 | 7.296 | 1.009 | 6.66 | 10.66 |
| 263 | 94 | 78 | 24.342 | 27.261 | 7.612 | 25.89 | 18.82 |
| 236 | 28 | 78 | 34.275 | 37.747 | 13.861 | 42.1 | 23.8 |
| 138 | 111 | 78 | 37.692 | 42.327 | 13.964 | 42.64 | 22.81 |
| 226 | 121 | 78 | 25.025 | 26.357 | 8.672 | 27.62 | 22.52 |
| 224 | 24 | 78 | 24.208 | 25.953 | 6.424 | 23.14 | 15.78 |
| 87 | 121 | 78 | 38.717 | 42.64 | 15.302 | 45.43 | 24.11 |
| 262 | 147 | 78 | 14.217 | 16.045 | 4.389 | 15.9 | 17.96 |