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 |
|---|---|---|---|---|---|---|---|
| 100 | 200 | 482 | 28.267 | 31.618 | 12.368 | 37.46 | 25.27 |
| 25 | 170 | 482 | 20.417 | 22.122 | 6.369 | 22.07 | 18.81 |
| 4 | 37 | 481 | 22.6 | 23.599 | 4.86 | 19.55 | 12.86 |
| 162 | 133 | 481 | 33.583 | 35.972 | 11.637 | 36.71 | 20.84 |
| 134 | 134 | 481 | 3.55 | 6.443 | 1.734 | 18.55 | 37.76 |
| 10 | 186 | 481 | 47.85 | 49.234 | 14.586 | 52.25 | 19.69 |
| 262 | 247 | 481 | 14.7 | 16.352 | 4.449 | 16.23 | 18.04 |
| 52 | 230 | 481 | 30.533 | 32.04 | 7.032 | 26.18 | 13.79 |
| 261 | 74 | 481 | 26 | 29.147 | 9.695 | 30.54 | 21.88 |
| 65 | 158 | 480 | 17.458 | 18.12 | 3.908 | 16.07 | 13.46 |
| 25 | 256 | 480 | 16.533 | 17.24 | 3.81 | 15.44 | 14.42 |
| 33 | 261 | 479 | 11.917 | 12.986 | 2.74 | 12.2 | 13.72 |
| 151 | 148 | 479 | 30.55 | 31.95 | 7.891 | 28.15 | 15.69 |
| 164 | 227 | 479 | 33.667 | 34.938 | 11.142 | 35.35 | 20.52 |
| 238 | 33 | 479 | 33.933 | 35.554 | 9.907 | 32.87 | 17.54 |
| 88 | 195 | 479 | 16.283 | 18.043 | 4.761 | 17.02 | 17.05 |
| 261 | 37 | 479 | 29.05 | 29.968 | 6.476 | 24.67 | 13.7 |
| 236 | 49 | 478 | 35.842 | 37.379 | 10.246 | 34.27 | 17.3 |
| 223 | 163 | 478 | 23.142 | 27.353 | 6.494 | 27.85 | 15.33 |
| 89 | 188 | 478 | 10.542 | 11.725 | 1.646 | 9.56 | 9.25 |
| 233 | 189 | 478 | 32.308 | 34.602 | 8.017 | 28.87 | 15 |
| 66 | 52 | 477 | 8.85 | 9.231 | 1.601 | 8.24 | 11 |
| 146 | 79 | 477 | 17.183 | 18.489 | 4.51 | 16.64 | 16.12 |
| 237 | 196 | 476 | 29.833 | 31.355 | 7.649 | 27.64 | 15.8 |
| 25 | 45 | 476 | 9.775 | 11.53 | 2.353 | 11.03 | 14.18 |