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 |
|---|---|---|---|---|---|---|---|
| 159 | 145 | 10 | 28.475 | 29.36 | 6.709 | 24.85 | 14.1 |
| 117 | 97 | 10 | 60.242 | 60.208 | 18.954 | 58.23 | 18.91 |
| 76 | 92 | 10 | 26.533 | 28.848 | 10.401 | 30.87 | 22.73 |
| 135 | 24 | 10 | 30.483 | 36.272 | 14.29 | 44.25 | 25.85 |
| 219 | 69 | 10 | 55.075 | 56.312 | 20.089 | 58.56 | 23.77 |
| 51 | 61 | 10 | 43.325 | 47.945 | 21.008 | 60.81 | 26.96 |
| 254 | 247 | 10 | 24.9 | 26.003 | 6.967 | 23.58 | 17.38 |
| 74 | 133 | 10 | 30.342 | 32.915 | 15.398 | 43.9 | 28.98 |
| 63 | 196 | 10 | 23.233 | 24.543 | 5.67 | 20.02 | 14.44 |
| 191 | 177 | 10 | 27.125 | 32.23 | 13.808 | 40.49 | 27.34 |
| 85 | 228 | 10 | 18.2 | 19.073 | 3.922 | 16.5 | 13.06 |
| 49 | 95 | 10 | 26.725 | 27.637 | 9.427 | 29.21 | 21.68 |
| 197 | 78 | 10 | 43.067 | 45.315 | 15.374 | 46.06 | 21.39 |
| 119 | 250 | 10 | 19.883 | 19.672 | 6.684 | 21.85 | 21.79 |
| 125 | 254 | 10 | 54.367 | 63.597 | 17.546 | 58.74 | 17.92 |
| 133 | 210 | 10 | 24.175 | 23.885 | 4.612 | 18.25 | 11.73 |
| 181 | 154 | 10 | 34.608 | 34.56 | 10.757 | 34.8 | 18.88 |
| 28 | 168 | 10 | 27.608 | 28.758 | 13.082 | 42.1 | 30.18 |
| 70 | 33 | 10 | 36.692 | 36.987 | 11.508 | 36.48 | 21.4 |
| 178 | 65 | 10 | 44.533 | 44.787 | 6.7 | 31.5 | 9.99 |
| 195 | 22 | 10 | 22.792 | 24.047 | 7.512 | 24.26 | 20.43 |
| 254 | 142 | 10 | 53.342 | 54.618 | 16.37 | 51.39 | 19.19 |
| 241 | 162 | 10 | 42.7 | 43.492 | 12.834 | 40.38 | 18.68 |
| 217 | 162 | 10 | 26.633 | 26.14 | 5.907 | 21.98 | 14.53 |
| 260 | 212 | 10 | 18.283 | 22.372 | 9.595 | 29 | 27.78 |