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 |
|---|---|---|---|---|---|---|---|
| 65 | 4 | 409 | 12.5 | 13.106 | 3.799 | 13.88 | 18.47 |
| 4 | 42 | 409 | 20.45 | 22.791 | 8.284 | 25.91 | 23.78 |
| 13 | 17 | 409 | 27.317 | 27.521 | 6.3 | 23.25 | 14.18 |
| 260 | 230 | 409 | 24.55 | 26.435 | 5.508 | 41.82 | 13.98 |
| 76 | 61 | 409 | 24.617 | 25.387 | 4.595 | 19.43 | 11.39 |
| 262 | 179 | 408 | 17.467 | 18.129 | 5.237 | 18.48 | 19.15 |
| 211 | 89 | 408 | 26.733 | 29.201 | 7.76 | 26.78 | 17.02 |
| 112 | 36 | 408 | 15.083 | 15.883 | 3.074 | 13.06 | 11.97 |
| 170 | 247 | 407 | 24.233 | 27.81 | 7.933 | 26.71 | 19.29 |
| 232 | 238 | 407 | 27.933 | 29.435 | 7.438 | 26.37 | 16.46 |
| 40 | 87 | 407 | 16.217 | 16.89 | 3.701 | 15.46 | 14.01 |
| 170 | 220 | 407 | 32.467 | 35.099 | 12.016 | 37.57 | 22.34 |
| 255 | 113 | 407 | 20.483 | 21.736 | 3.939 | 17.04 | 11.63 |
| 237 | 89 | 406 | 40.942 | 44.248 | 13.259 | 42.6 | 19.51 |
| 151 | 69 | 406 | 24.117 | 25.165 | 5.1 | 20.31 | 12.93 |
| 158 | 188 | 406 | 30.967 | 32.918 | 7.844 | 28.12 | 15.05 |
| 107 | 69 | 406 | 25.7 | 30.193 | 8.685 | 28.86 | 20 |
| 65 | 228 | 405 | 16 | 17.658 | 4.805 | 17.32 | 17.59 |
| 138 | 183 | 405 | 21.833 | 24.105 | 10.733 | 31.53 | 28.69 |
| 166 | 211 | 405 | 30.833 | 32.49 | 7.658 | 28.15 | 14.87 |
| 12 | 234 | 405 | 21.7 | 22.625 | 4.447 | 18.6 | 12.4 |
| 142 | 257 | 405 | 35 | 37.113 | 11.204 | 36.19 | 18.86 |
| 166 | 247 | 405 | 17.867 | 19.256 | 3.47 | 15.4 | 11.54 |
| 48 | 182 | 405 | 29.1 | 32.76 | 12.476 | 37.84 | 25.5 |
| 87 | 54 | 404 | 15.858 | 16.716 | 3.559 | 14.11 | 13.7 |