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 | 69 | 269 | 6.833 | 8.26 | 1.116 | 7.53 | 8.69 |
| 45 | 116 | 269 | 36.75 | 39.434 | 10.432 | 35.59 | 18.05 |
| 215 | 163 | 269 | 46 | 47.567 | 14.232 | 52.06 | 20.22 |
| 188 | 72 | 268 | 12.867 | 13.208 | 2.036 | 10.89 | 9.67 |
| 231 | 200 | 268 | 33.308 | 37.724 | 14.766 | 44.2 | 25.36 |
| 256 | 45 | 268 | 13.192 | 14.695 | 2.703 | 14.07 | 12.58 |
| 246 | 200 | 268 | 26.35 | 28.738 | 12.219 | 36.08 | 27.41 |
| 151 | 159 | 268 | 21.833 | 23.27 | 4.456 | 18.51 | 12.07 |
| 39 | 76 | 268 | 14.208 | 15.205 | 2.871 | 13.29 | 12.25 |
| 65 | 141 | 268 | 21.808 | 23.647 | 7.306 | 24.04 | 20.73 |
| 138 | 150 | 268 | 47.483 | 50.897 | 22.262 | 62.85 | 28.64 |
| 42 | 234 | 268 | 27.717 | 29.548 | 7.148 | 25.65 | 16.06 |
| 238 | 194 | 268 | 21.05 | 22.238 | 5.345 | 23.75 | 15.21 |
| 233 | 257 | 268 | 28.575 | 30.986 | 10.449 | 32.68 | 21.98 |
| 100 | 123 | 268 | 44.967 | 47.694 | 13.89 | 44.82 | 18.37 |
| 238 | 241 | 268 | 21.725 | 24.626 | 9.348 | 29.07 | 25.59 |
| 223 | 48 | 268 | 33.042 | 35.675 | 8.529 | 35.39 | 15.53 |
| 76 | 72 | 268 | 16.5 | 16.869 | 3.038 | 13.85 | 11.17 |
| 48 | 78 | 267 | 27.383 | 29.966 | 11.211 | 34.41 | 24.82 |
| 43 | 49 | 267 | 37.183 | 39.097 | 9.62 | 33.52 | 15.63 |
| 13 | 133 | 267 | 16.283 | 18.071 | 6.406 | 20.73 | 23.01 |
| 50 | 200 | 267 | 19.617 | 22.134 | 11.062 | 31.88 | 32.65 |
| 42 | 126 | 267 | 16.217 | 17.299 | 4.267 | 15.99 | 15.59 |
| 232 | 244 | 267 | 28.45 | 32.293 | 11.481 | 35.51 | 23.97 |
| 39 | 72 | 267 | 12.6 | 12.938 | 2.219 | 11.19 | 10.82 |