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 |
|---|---|---|---|---|---|---|---|
| 161 | 216 | 501 | 46.817 | 50.734 | 14.86 | 49.89 | 19.9 |
| 256 | 97 | 501 | 13.4 | 14.414 | 2.703 | 12.12 | 12 |
| 75 | 179 | 501 | 17.817 | 18.572 | 5.14 | 18.22 | 18.34 |
| 144 | 198 | 501 | 24.417 | 26.101 | 6.367 | 23.22 | 15.47 |
| 74 | 246 | 501 | 24.983 | 26.871 | 6.544 | 24.1 | 15.84 |
| 229 | 160 | 500 | 21.433 | 23.582 | 6.868 | 23.44 | 18.41 |
| 244 | 186 | 500 | 25.7 | 27.892 | 7.981 | 27.69 | 18.69 |
| 247 | 116 | 499 | 9.15 | 10.309 | 1.564 | 9.86 | 9.81 |
| 238 | 45 | 499 | 29.917 | 31.053 | 7.705 | 27.67 | 15.87 |
| 132 | 27 | 499 | 30.483 | 32.529 | 16.147 | 44.92 | 31.33 |
| 33 | 163 | 499 | 29.467 | 31.025 | 7.579 | 27.25 | 15.76 |
| 230 | 133 | 499 | 33.833 | 35.68 | 11.511 | 36.53 | 20.27 |
| 232 | 97 | 498 | 16.442 | 18.01 | 3.627 | 15.16 | 12.83 |
| 209 | 143 | 498 | 24.467 | 26.235 | 6.154 | 22.81 | 14.76 |
| 4 | 74 | 497 | 19.217 | 21.076 | 6.68 | 21.98 | 20.74 |
| 138 | 210 | 497 | 46.317 | 49.987 | 21.463 | 60.99 | 28.41 |
| 217 | 17 | 497 | 7.567 | 8.967 | 1.138 | 7.65 | 8.65 |
| 261 | 42 | 497 | 29.35 | 31.834 | 10.65 | 33.61 | 22.38 |
| 90 | 260 | 496 | 25.558 | 27.654 | 6.97 | 24.71 | 16.22 |
| 7 | 186 | 496 | 26.958 | 29.851 | 5.375 | 22.51 | 12.01 |
| 65 | 100 | 495 | 25.5 | 27.071 | 5.732 | 22.57 | 13.83 |
| 116 | 263 | 495 | 22.25 | 23.227 | 4.599 | 18.73 | 12.6 |
| 261 | 257 | 495 | 17.283 | 18.841 | 5.752 | 19.51 | 20.04 |
| 7 | 263 | 495 | 17 | 18.848 | 4.482 | 16.76 | 15.59 |
| 211 | 226 | 495 | 27.133 | 28.33 | 6.801 | 25.18 | 15.64 |