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 |
|---|---|---|---|---|---|---|---|
| 85 | 181 | 52 | 15.975 | 17.606 | 3.237 | 14.36 | 12.07 |
| 178 | 89 | 52 | 8.367 | 11.331 | 1.801 | 9.65 | 11.08 |
| 43 | 136 | 52 | 30.417 | 31.559 | 8.633 | 29.75 | 18.33 |
| 80 | 238 | 52 | 31.942 | 34.017 | 9.411 | 31.37 | 17.48 |
| 17 | 75 | 52 | 38.292 | 38.876 | 11.718 | 37.32 | 19.48 |
| 87 | 213 | 52 | 33.492 | 34.554 | 14.5 | 41.72 | 26.49 |
| 69 | 237 | 52 | 37.833 | 36.741 | 6.907 | 27.8 | 12.27 |
| 87 | 102 | 52 | 33.817 | 35.441 | 11.573 | 36.27 | 20.26 |
| 95 | 13 | 52 | 42.95 | 45.954 | 14.618 | 46.62 | 20.12 |
| 37 | 71 | 52 | 26.158 | 27.466 | 4.623 | 19.93 | 10.54 |
| 231 | 150 | 52 | 34.442 | 37.676 | 15.979 | 45.61 | 27.06 |
| 211 | 196 | 52 | 27.442 | 30.394 | 9.451 | 31.35 | 20.28 |
| 238 | 81 | 52 | 32.742 | 34.308 | 13.674 | 40.72 | 26.52 |
| 236 | 32 | 52 | 30.6 | 31.98 | 9.95 | 31.75 | 20.14 |
| 42 | 211 | 52 | 35.217 | 39.012 | 9.581 | 33.44 | 16.24 |
| 151 | 40 | 52 | 36.775 | 37.687 | 11.152 | 36.19 | 18.55 |
| 80 | 91 | 52 | 27.158 | 31.89 | 6.969 | 25.38 | 13.84 |
| 166 | 260 | 52 | 29.025 | 29.63 | 7.902 | 27.31 | 17.28 |
| 217 | 97 | 52 | 12.15 | 13.299 | 2.185 | 10.87 | 11.5 |
| 209 | 177 | 52 | 30.083 | 31.851 | 6.788 | 25.12 | 13.39 |
| 188 | 228 | 52 | 19.683 | 18.864 | 4.016 | 16.34 | 13.21 |
| 242 | 74 | 52 | 26.242 | 28.004 | 7.662 | 26.5 | 17.52 |
| 236 | 227 | 52 | 39.483 | 40.71 | 14.377 | 43.45 | 22.51 |
| 13 | 134 | 52 | 40.675 | 47.664 | 16.696 | 49.51 | 24 |
| 168 | 182 | 52 | 19.775 | 20.973 | 5.485 | 20.22 | 17.41 |