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 |
|---|---|---|---|---|---|---|---|
| 146 | 4 | 91 | 19.217 | 21.447 | 5.503 | 19.65 | 17.15 |
| 141 | 197 | 91 | 38.117 | 42.487 | 13.025 | 42.21 | 20.63 |
| 237 | 147 | 91 | 21.7 | 24.102 | 6.247 | 22.17 | 17.29 |
| 233 | 212 | 91 | 22.083 | 24.593 | 9.349 | 28.57 | 24.52 |
| 37 | 226 | 91 | 17.85 | 21.321 | 4.222 | 17.48 | 13.29 |
| 132 | 184 | 91 | 38.633 | 40.04 | 20.536 | 58.52 | 32.85 |
| 49 | 34 | 91 | 5.95 | 7.638 | 1.195 | 7.04 | 9.91 |
| 74 | 97 | 91 | 36.55 | 37.642 | 11.506 | 36.86 | 19.61 |
| 49 | 87 | 91 | 22.517 | 22.961 | 4.043 | 21.03 | 11.61 |
| 263 | 20 | 91 | 28.317 | 28.835 | 8.88 | 28.87 | 19.87 |
| 42 | 97 | 90 | 41.633 | 42.769 | 13.072 | 41.24 | 19.5 |
| 75 | 76 | 90 | 55.625 | 56.581 | 18.441 | 57.23 | 21.84 |
| 178 | 178 | 90 | 1.583 | 6.84 | 1.398 | 8.8 | 37.83 |
| 163 | 102 | 90 | 34.492 | 35.013 | 8.555 | 30.42 | 15.16 |
| 79 | 215 | 90 | 60.05 | 60.163 | 15.158 | 49.85 | 17.03 |
| 142 | 131 | 90 | 41.017 | 43.777 | 15.368 | 47.26 | 22.04 |
| 87 | 91 | 90 | 39.275 | 43.054 | 9.939 | 35.26 | 14.89 |
| 246 | 18 | 90 | 29.983 | 32.786 | 12.913 | 39.12 | 25.66 |
| 127 | 152 | 90 | 13.092 | 14.54 | 4.503 | 16.04 | 21.1 |
| 116 | 120 | 90 | 8.9 | 10.181 | 1.996 | 9.46 | 12.43 |
| 142 | 254 | 90 | 32.783 | 36.42 | 14.062 | 41.95 | 24.87 |
| 144 | 193 | 90 | 28.267 | 33.024 | 7.078 | 26.37 | 14.62 |
| 146 | 166 | 90 | 27.917 | 28.313 | 6.252 | 23.2 | 14.17 |
| 137 | 126 | 90 | 25.842 | 29.58 | 8.771 | 28.6 | 20.25 |
| 90 | 78 | 90 | 48.742 | 48.844 | 12.603 | 42.67 | 17.45 |