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 |
|---|---|---|---|---|---|---|---|
| 68 | 70 | 343 | 35.017 | 37.198 | 10.273 | 34.88 | 17.84 |
| 113 | 54 | 343 | 23.117 | 23.821 | 4.904 | 19.1 | 13.01 |
| 113 | 168 | 343 | 24.7 | 27.001 | 8.269 | 27.25 | 20.14 |
| 226 | 50 | 343 | 22.567 | 25.2 | 4.854 | 30.19 | 12.42 |
| 4 | 97 | 343 | 19.067 | 19.989 | 4.614 | 17.75 | 14.49 |
| 189 | 188 | 343 | 9.783 | 10.776 | 2.084 | 9.79 | 12.57 |
| 165 | 165 | 342 | 6.175 | 7.989 | 1.405 | 7.82 | 22.06 |
| 256 | 68 | 342 | 23.183 | 24.772 | 4.898 | 20.22 | 12.89 |
| 211 | 106 | 342 | 22.667 | 23.327 | 4.624 | 18.83 | 12.4 |
| 116 | 141 | 342 | 26.592 | 27.23 | 5.674 | 22.17 | 13.34 |
| 158 | 257 | 342 | 21.642 | 23.789 | 7.638 | 24.92 | 20.47 |
| 236 | 17 | 342 | 39.192 | 40.501 | 9.653 | 34.7 | 15.04 |
| 226 | 246 | 342 | 23.692 | 26.741 | 5.223 | 30.95 | 12.98 |
| 158 | 106 | 342 | 22.833 | 24.315 | 5.95 | 21.56 | 15.37 |
| 211 | 243 | 342 | 31.6 | 34.077 | 11.346 | 36.11 | 21.23 |
| 132 | 214 | 342 | 45.85 | 48.532 | 24.837 | 67.42 | 32.6 |
| 100 | 119 | 342 | 28.058 | 30.971 | 9.265 | 30.56 | 19.95 |
| 68 | 159 | 342 | 28.325 | 30.439 | 8.995 | 29.74 | 18.66 |
| 66 | 186 | 342 | 24.408 | 25.451 | 5.175 | 20.79 | 12.96 |
| 179 | 137 | 342 | 18.108 | 20.88 | 4.888 | 18.26 | 15.85 |
| 213 | 213 | 341 | 6.383 | 8.107 | 1.505 | 8.57 | 23.1 |
| 255 | 230 | 341 | 29.867 | 32.287 | 6.343 | 25.18 | 12.68 |
| 52 | 186 | 341 | 25.1 | 26.837 | 6.005 | 22.53 | 14.36 |
| 263 | 202 | 341 | 18.383 | 19.584 | 4.758 | 17.35 | 15.55 |
| 233 | 217 | 341 | 24.867 | 26.113 | 5.553 | 22.25 | 13.71 |