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 |
|---|---|---|---|---|---|---|---|
| 137 | 36 | 367 | 28.133 | 30.141 | 7.282 | 26.25 | 15.49 |
| 164 | 157 | 367 | 20.6 | 23.018 | 6.688 | 23.83 | 18.87 |
| 74 | 88 | 367 | 23.317 | 24.124 | 9.24 | 27.9 | 25.56 |
| 88 | 225 | 367 | 30.183 | 30.564 | 6.486 | 24.66 | 13.53 |
| 28 | 170 | 367 | 23.1 | 25.386 | 11.145 | 51.03 | 29.49 |
| 143 | 45 | 366 | 29.308 | 30.4 | 5.86 | 23.95 | 12.19 |
| 209 | 52 | 366 | 13.108 | 13.765 | 2.715 | 11.43 | 12.87 |
| 143 | 129 | 366 | 32.442 | 34.176 | 7.566 | 28.27 | 13.96 |
| 22 | 22 | 366 | 5 | 5.931 | 0.92 | 6.71 | 13.17 |
| 48 | 160 | 366 | 29.625 | 32.156 | 8.543 | 29.86 | 17.27 |
| 93 | 79 | 365 | 24.517 | 26.55 | 10.663 | 50.49 | 26.46 |
| 68 | 227 | 365 | 29.65 | 31.512 | 9.644 | 31.27 | 19.1 |
| 263 | 56 | 365 | 30.45 | 31.511 | 8.294 | 28.68 | 16.73 |
| 13 | 116 | 365 | 28.567 | 30.83 | 9.719 | 31.6 | 19.8 |
| 25 | 74 | 365 | 42.6 | 44.168 | 11.353 | 38.34 | 17.79 |
| 43 | 25 | 365 | 33.583 | 35.115 | 9.277 | 31.55 | 16.97 |
| 12 | 66 | 365 | 16.567 | 17.275 | 3.018 | 13.66 | 11.23 |
| 129 | 92 | 365 | 15.233 | 16.712 | 4.395 | 16.51 | 17.77 |
| 42 | 170 | 365 | 26.017 | 28.368 | 6.178 | 23.48 | 15.59 |
| 88 | 260 | 365 | 26.45 | 29.307 | 9.46 | 30.49 | 20.77 |
| 10 | 229 | 364 | 41.242 | 42.109 | 14.591 | 52.02 | 23.21 |
| 224 | 143 | 364 | 24.975 | 26.665 | 4.458 | 19.8 | 10.76 |
| 65 | 50 | 364 | 23.433 | 25.642 | 6.34 | 23.13 | 16.05 |
| 232 | 42 | 364 | 22.133 | 24.469 | 9.343 | 28.54 | 25.42 |
| 226 | 255 | 364 | 16.358 | 17.034 | 3.423 | 14.38 | 13.02 |