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 |
|---|---|---|---|---|---|---|---|
| 234 | 119 | 174 | 26.633 | 31.198 | 9.868 | 31.65 | 21.48 |
| 263 | 14 | 174 | 35.717 | 37.008 | 15.518 | 44.87 | 26.39 |
| 80 | 33 | 173 | 13.65 | 16.27 | 4.399 | 16.4 | 19.1 |
| 152 | 262 | 173 | 22.7 | 23.08 | 4.247 | 18.05 | 11.73 |
| 215 | 141 | 173 | 34.083 | 36.613 | 14.426 | 52.1 | 26.16 |
| 107 | 67 | 173 | 32.133 | 34.424 | 11.85 | 36.86 | 21.82 |
| 79 | 197 | 173 | 37.983 | 44.037 | 12.782 | 41.8 | 19.48 |
| 249 | 26 | 173 | 27.75 | 29.221 | 9.385 | 30.03 | 20.25 |
| 68 | 173 | 173 | 37.533 | 41.072 | 10.302 | 35.84 | 16.29 |
| 255 | 228 | 173 | 19.617 | 22.202 | 8.182 | 25.58 | 24.78 |
| 236 | 185 | 173 | 28.683 | 30.907 | 9.971 | 31.8 | 20.97 |
| 236 | 3 | 173 | 31.117 | 32.73 | 11.297 | 35.01 | 21.77 |
| 70 | 173 | 172 | 7.325 | 8.165 | 1.25 | 7.71 | 11.15 |
| 234 | 85 | 172 | 39.692 | 39.893 | 9.215 | 33.1 | 14.66 |
| 75 | 255 | 172 | 31.083 | 32.713 | 8.792 | 30.12 | 17.05 |
| 100 | 210 | 172 | 45.125 | 47.119 | 19.286 | 56.26 | 25.55 |
| 41 | 45 | 172 | 30.383 | 31.945 | 9.251 | 30.93 | 18.93 |
| 138 | 12 | 172 | 40.292 | 42.535 | 14.266 | 43.72 | 21.95 |
| 231 | 178 | 172 | 31.575 | 33.025 | 8.501 | 28.79 | 16.48 |
| 166 | 241 | 172 | 22.258 | 23.102 | 7.684 | 24.89 | 21.12 |
| 250 | 213 | 172 | 7.383 | 9.355 | 1.669 | 8.56 | 12.52 |
| 194 | 237 | 172 | 23.1 | 25.231 | 5.372 | 33.87 | 14.65 |
| 257 | 89 | 172 | 8.758 | 9.497 | 1.817 | 8.93 | 13.2 |
| 40 | 17 | 172 | 16.2 | 17.844 | 3.556 | 14.86 | 12.66 |
| 223 | 83 | 172 | 10.067 | 11.893 | 3.021 | 12.42 | 16.79 |