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 |
|---|---|---|---|---|---|---|---|
| 166 | 220 | 556 | 17.083 | 18.606 | 6.629 | 21.45 | 22.99 |
| 163 | 70 | 556 | 32.758 | 36.154 | 9.752 | 33.83 | 17.72 |
| 224 | 145 | 555 | 16.467 | 17.196 | 4.204 | 16.01 | 15.2 |
| 232 | 163 | 555 | 22.183 | 24.022 | 4.75 | 19.58 | 12.95 |
| 162 | 160 | 555 | 23.5 | 25.517 | 7.256 | 24.82 | 18.4 |
| 239 | 146 | 555 | 21.267 | 22.942 | 4.627 | 18.81 | 13.01 |
| 170 | 135 | 554 | 32.908 | 34.645 | 13.153 | 40.02 | 24.76 |
| 138 | 32 | 554 | 25.625 | 28.785 | 11.877 | 35.2 | 26.86 |
| 116 | 237 | 554 | 25.308 | 25.77 | 5.341 | 21.08 | 13.21 |
| 223 | 230 | 554 | 34.067 | 35.783 | 7.898 | 33.93 | 14.83 |
| 52 | 106 | 553 | 8.167 | 8.668 | 1.426 | 7.73 | 10.45 |
| 179 | 260 | 553 | 12.25 | 12.979 | 2.741 | 11.84 | 13.71 |
| 152 | 230 | 553 | 18.317 | 19.775 | 5.354 | 19.67 | 17.79 |
| 52 | 13 | 552 | 15.25 | 16.156 | 3.495 | 14.43 | 13.85 |
| 144 | 24 | 552 | 26.758 | 29.157 | 7.281 | 26 | 15.94 |
| 75 | 129 | 552 | 21.058 | 23.338 | 7.048 | 23.61 | 20.2 |
| 230 | 106 | 551 | 36.3 | 37.706 | 8.73 | 31.46 | 14.69 |
| 138 | 212 | 551 | 21.1 | 24.259 | 9.218 | 28.57 | 25.18 |
| 142 | 61 | 551 | 45.467 | 47.172 | 10.86 | 38.48 | 14.56 |
| 36 | 37 | 551 | 6.333 | 7.676 | 1.312 | 7.12 | 11.1 |
| 186 | 54 | 551 | 28.65 | 30.254 | 6.855 | 25.12 | 14.34 |
| 209 | 74 | 551 | 20.717 | 23.826 | 8.725 | 26.86 | 24.43 |
| 62 | 61 | 551 | 7.333 | 8.76 | 1.35 | 7.96 | 10.5 |
| 48 | 241 | 550 | 26.458 | 28.758 | 11.756 | 35.29 | 26.41 |
| 88 | 37 | 549 | 25.717 | 26.882 | 6.336 | 23.31 | 15.17 |