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 |
|---|---|---|---|---|---|---|---|
| 100 | 6 | 59 | 41.133 | 42.32 | 16.451 | 49.68 | 24.07 |
| 244 | 226 | 59 | 30.133 | 31.309 | 9.979 | 32.33 | 20.75 |
| 232 | 54 | 59 | 17.5 | 18.234 | 4.74 | 17.36 | 16.84 |
| 209 | 22 | 59 | 28.9 | 31.262 | 10.423 | 32.76 | 21.66 |
| 196 | 234 | 58 | 20.392 | 23.082 | 8.121 | 46.05 | 22.99 |
| 28 | 50 | 58 | 36.875 | 39.143 | 13.37 | 51.98 | 21.87 |
| 21 | 11 | 58 | 11.025 | 11.618 | 1.822 | 9.83 | 9.6 |
| 87 | 20 | 58 | 30.683 | 38.648 | 15.445 | 45.22 | 27.06 |
| 35 | 49 | 58 | 25.292 | 27.721 | 4.485 | 19.9 | 10.46 |
| 88 | 149 | 58 | 34.183 | 33.812 | 10.503 | 33.39 | 19.34 |
| 40 | 4 | 58 | 18 | 19.368 | 5.518 | 19.02 | 17.75 |
| 133 | 188 | 58 | 14.558 | 15.38 | 2.275 | 11.87 | 9.62 |
| 182 | 75 | 58 | 30.342 | 31.554 | 7.7 | 27.02 | 15.8 |
| 182 | 174 | 58 | 19.692 | 20.072 | 4.724 | 17.8 | 16.19 |
| 166 | 216 | 58 | 47.967 | 52.702 | 16.445 | 50.66 | 20.78 |
| 48 | 57 | 58 | 38.125 | 39.62 | 10.621 | 36.2 | 17.35 |
| 22 | 55 | 58 | 15.867 | 16.71 | 3.39 | 14.41 | 12.47 |
| 179 | 157 | 58 | 19.167 | 20.092 | 5.549 | 19.81 | 17.98 |
| 100 | 128 | 58 | 26.908 | 28.284 | 10.384 | 32.35 | 23.59 |
| 65 | 179 | 58 | 24.275 | 26.072 | 9.392 | 29.34 | 23.86 |
| 237 | 55 | 58 | 50.217 | 52.757 | 19.828 | 58.69 | 23.98 |
| 157 | 137 | 58 | 13.55 | 16.46 | 5.515 | 42.47 | 24.26 |
| 107 | 254 | 58 | 35.7 | 42.905 | 15.197 | 45.42 | 24.29 |
| 249 | 178 | 58 | 27.917 | 30.36 | 10.023 | 31.76 | 20.83 |
| 137 | 171 | 58 | 34.533 | 37.984 | 12.954 | 39.73 | 22.58 |