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 |
|---|---|---|---|---|---|---|---|
| 247 | 28 | 47 | 37.35 | 42.791 | 15.328 | 47.71 | 23.81 |
| 41 | 14 | 47 | 45.183 | 49.376 | 17.41 | 52.52 | 22.71 |
| 142 | 187 | 47 | 49.9 | 53.116 | 22.24 | 65.27 | 26.27 |
| 68 | 240 | 47 | 31.217 | 33.04 | 14.356 | 41.9 | 28 |
| 257 | 14 | 47 | 17.283 | 17.888 | 5.526 | 19.12 | 19.9 |
| 247 | 78 | 47 | 20.55 | 21.361 | 4.096 | 17.28 | 13.12 |
| 119 | 243 | 47 | 13.95 | 15.979 | 2.331 | 14.13 | 9.74 |
| 39 | 107 | 47 | 47.6 | 52.934 | 12.174 | 41.82 | 14.26 |
| 211 | 1 | 47 | 35.883 | 42.847 | 14.733 | 75.06 | 25.01 |
| 113 | 241 | 46 | 35.867 | 39.224 | 13.918 | 42.78 | 23.18 |
| 164 | 8 | 46 | 24.383 | 24.724 | 5.883 | 21.66 | 14.98 |
| 195 | 170 | 46 | 28.717 | 31.334 | 8.813 | 28.97 | 18.08 |
| 137 | 183 | 46 | 28.367 | 31.253 | 13.208 | 38.39 | 27.52 |
| 42 | 65 | 46 | 41.017 | 41.104 | 12.646 | 40.25 | 21.08 |
| 129 | 121 | 46 | 17.65 | 18.837 | 6.967 | 22.32 | 23.95 |
| 158 | 21 | 46 | 33.717 | 34.635 | 12.806 | 38.63 | 22.71 |
| 7 | 66 | 46 | 28.317 | 28.809 | 9.013 | 28.24 | 20.84 |
| 174 | 69 | 46 | 30.758 | 30.956 | 5.064 | 22.64 | 10.95 |
| 142 | 35 | 46 | 56.525 | 57.886 | 15.213 | 51.74 | 16.48 |
| 230 | 203 | 46 | 45.425 | 51.953 | 20.259 | 58.29 | 25.52 |
| 244 | 217 | 46 | 47.675 | 48.7 | 13.766 | 45.21 | 18.54 |
| 179 | 209 | 46 | 30.325 | 31.808 | 9.658 | 31.62 | 19.02 |
| 78 | 244 | 46 | 22.567 | 23.123 | 4.375 | 20.93 | 13.43 |
| 19 | 101 | 46 | 5.9 | 6.732 | 1.425 | 7.21 | 14.34 |
| 216 | 71 | 46 | 29.942 | 30.256 | 7.912 | 27.6 | 16.05 |