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 |
|---|---|---|---|---|---|---|---|
| 244 | 183 | 19 | 29.033 | 27.731 | 8.925 | 28.98 | 22.04 |
| 47 | 185 | 19 | 23.917 | 21.625 | 3.977 | 17.98 | 11.95 |
| 261 | 172 | 19 | 31.367 | 32.804 | 15.643 | 44.18 | 29.23 |
| 170 | 57 | 19 | 26.917 | 30.474 | 10.554 | 33.45 | 22.68 |
| 138 | 5 | 19 | 56.4 | 69.984 | 32.519 | 90 | 31.89 |
| 197 | 121 | 19 | 16.417 | 19.209 | 3.423 | 14.98 | 11.8 |
| 65 | 178 | 19 | 29.083 | 29.125 | 7.14 | 25.84 | 15.99 |
| 111 | 111 | 19 | 5.25 | 9.006 | 2.257 | 12.22 | 22.88 |
| 74 | 252 | 19 | 26.617 | 27.717 | 10.702 | 32.18 | 25.74 |
| 9 | 15 | 19 | 11.717 | 12.128 | 2.355 | 11.05 | 12.04 |
| 87 | 32 | 19 | 48.1 | 51.861 | 17.125 | 51.17 | 21.69 |
| 71 | 166 | 19 | 72.217 | 70.096 | 17.664 | 60.68 | 16.02 |
| 145 | 195 | 19 | 28.4 | 30.627 | 8.928 | 28.89 | 19.89 |
| 256 | 24 | 19 | 30.4 | 32.889 | 9.916 | 32.58 | 19.23 |
| 222 | 13 | 19 | 32.067 | 34.996 | 21.027 | 55.19 | 38.16 |
| 196 | 131 | 19 | 18.533 | 19.327 | 6.195 | 20.04 | 21.09 |
| 93 | 131 | 19 | 10.217 | 11.745 | 5.024 | 20.5 | 32.29 |
| 37 | 193 | 19 | 20.183 | 23.321 | 4.861 | 19.11 | 13.31 |
| 243 | 248 | 19 | 14.7 | 17.586 | 4.391 | 16.71 | 16.81 |
| 254 | 61 | 19 | 53.433 | 55.867 | 22.174 | 64.35 | 24.92 |
| 127 | 159 | 19 | 26.267 | 26.876 | 5.322 | 21.71 | 13.72 |
| 22 | 25 | 19 | 40.283 | 40.265 | 7.2 | 28.23 | 11.45 |
| 52 | 166 | 19 | 36.483 | 38.218 | 11.413 | 37.24 | 18.38 |
| 249 | 120 | 19 | 27.8 | 30.849 | 10.672 | 33.61 | 21.98 |
| 179 | 49 | 19 | 25.633 | 28.75 | 8.383 | 28.24 | 19.96 |