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 |
|---|---|---|---|---|---|---|---|
| 75 | 67 | 19 | 47.967 | 49.418 | 15.665 | 48.24 | 19.89 |
| 246 | 81 | 19 | 47.217 | 50.671 | 17.211 | 53.58 | 22.56 |
| 94 | 20 | 19 | 10.45 | 9.982 | 1.295 | 8.16 | 8.36 |
| 164 | 86 | 19 | 61.75 | 75.07 | 23.703 | 75.61 | 21.18 |
| 95 | 122 | 19 | 24.333 | 26.41 | 6.204 | 22.79 | 16.62 |
| 51 | 167 | 19 | 28.283 | 28.236 | 8.688 | 27.91 | 20.08 |
| 260 | 135 | 19 | 21.183 | 23.58 | 8.553 | 26.92 | 24.27 |
| 70 | 262 | 19 | 23.533 | 24.084 | 8.664 | 29 | 24.4 |
| 37 | 133 | 19 | 30.833 | 31.914 | 7.872 | 27.89 | 16.91 |
| 91 | 237 | 19 | 42.95 | 46.527 | 16.428 | 46.54 | 21.73 |
| 236 | 11 | 19 | 45.367 | 47.399 | 18.591 | 54.56 | 25.21 |
| 87 | 18 | 19 | 40.567 | 43.365 | 15.739 | 47.29 | 23.2 |
| 186 | 59 | 19 | 36.1 | 40.556 | 11.927 | 38.89 | 19.46 |
| 231 | 139 | 19 | 60.983 | 63.513 | 24.071 | 68.27 | 25.46 |
| 216 | 263 | 19 | 39.483 | 40.03 | 15.779 | 49.11 | 24.37 |
| 13 | 213 | 19 | 34.367 | 36.175 | 15.155 | 43.87 | 26.2 |
| 188 | 203 | 19 | 47.833 | 49.237 | 13.441 | 44.66 | 16.82 |
| 195 | 76 | 19 | 39.433 | 40.529 | 11.039 | 37.72 | 17.67 |
| 143 | 81 | 19 | 31.883 | 38.716 | 15.156 | 45.18 | 26.28 |
| 88 | 32 | 19 | 50.183 | 61.005 | 17.619 | 57.16 | 20.64 |
| 117 | 201 | 19 | 10.567 | 11.113 | 2.438 | 10.47 | 14.7 |
| 63 | 180 | 19 | 8.817 | 8.369 | 1.618 | 8.24 | 12.23 |
| 203 | 76 | 19 | 30.4 | 29.685 | 9.577 | 29.07 | 21.79 |
| 241 | 3 | 19 | 23.267 | 23.239 | 4.804 | 19.26 | 12.66 |
| 127 | 167 | 19 | 27.017 | 26.295 | 6.017 | 22.82 | 15.25 |