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 |
|---|---|---|---|---|---|---|---|
| 114 | 1 | 27 | 36.967 | 37.496 | 14.65 | 74.28 | 24.86 |
| 182 | 231 | 27 | 40.533 | 44.423 | 15.46 | 46.15 | 22.25 |
| 125 | 197 | 27 | 43.45 | 46.94 | 14.551 | 47.11 | 20.52 |
| 131 | 114 | 27 | 49.667 | 52.293 | 16.584 | 51.07 | 21.34 |
| 195 | 81 | 27 | 47.75 | 51.896 | 23.605 | 65.37 | 28.93 |
| 232 | 200 | 27 | 36.9 | 41.641 | 16.54 | 48.57 | 26.75 |
| 189 | 236 | 27 | 37.483 | 37.238 | 10.026 | 33.81 | 16.96 |
| 195 | 189 | 27 | 18.817 | 19.434 | 3.351 | 14.91 | 10.57 |
| 144 | 208 | 27 | 39.4 | 42.582 | 16.295 | 48.02 | 24.48 |
| 33 | 21 | 27 | 30.1 | 30.478 | 9.86 | 31.3 | 20.61 |
| 85 | 225 | 27 | 23.967 | 25.69 | 4.296 | 18.64 | 10.54 |
| 114 | 252 | 27 | 32.75 | 34.824 | 15.352 | 45.17 | 27.32 |
| 74 | 217 | 27 | 31.95 | 31.986 | 10.661 | 33.78 | 20.74 |
| 33 | 69 | 27 | 46.583 | 52.628 | 13.176 | 43.87 | 16.84 |
| 63 | 177 | 27 | 12.617 | 16.759 | 3.235 | 14.06 | 11.06 |
| 74 | 14 | 27 | 40.883 | 44.083 | 17.533 | 51.42 | 25.77 |
| 231 | 31 | 27 | 45.733 | 46.451 | 16.214 | 49.63 | 41.92 |
| 72 | 142 | 27 | 40.633 | 48.312 | 12.62 | 40.78 | 17.24 |
| 29 | 165 | 27 | 17.8 | 19.806 | 3.284 | 15.39 | 10.6 |
| 242 | 114 | 27 | 42.883 | 44.422 | 14.111 | 44.16 | 19.3 |
| 45 | 56 | 27 | 29.617 | 31.419 | 10.846 | 33.57 | 23.25 |
| 63 | 25 | 27 | 37.85 | 38.675 | 7.011 | 27.26 | 11.15 |
| 133 | 21 | 27 | 16.417 | 16.763 | 2.902 | 13.5 | 11.15 |
| 218 | 188 | 27 | 44.5 | 42.525 | 12.449 | 40.98 | 18.65 |
| 149 | 39 | 27 | 22.483 | 23.647 | 5.931 | 21.48 | 15.65 |