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 |
|---|---|---|---|---|---|---|---|
| 226 | 127 | 34 | 34.942 | 38.55 | 11.441 | 37.28 | 20.41 |
| 247 | 200 | 34 | 24.892 | 29.079 | 8.275 | 28.18 | 19.33 |
| 36 | 189 | 34 | 20.05 | 21.253 | 4.371 | 17.18 | 12.79 |
| 149 | 21 | 34 | 14.825 | 14.793 | 2.246 | 11.68 | 9.69 |
| 254 | 41 | 34 | 30.375 | 32.142 | 10.65 | 34.62 | 20.97 |
| 61 | 215 | 34 | 41.917 | 41.974 | 10.952 | 36.82 | 16.12 |
| 138 | 156 | 34 | 52.483 | 59.556 | 26.687 | 75.59 | 29.83 |
| 62 | 137 | 34 | 37.467 | 36.65 | 8.383 | 29.61 | 14.56 |
| 37 | 90 | 34 | 33.367 | 34.583 | 6.6 | 26.06 | 12.6 |
| 71 | 210 | 34 | 27.933 | 28.965 | 5.509 | 22.36 | 11.73 |
| 134 | 262 | 34 | 25.508 | 29.036 | 13.596 | 48.51 | 30.31 |
| 240 | 240 | 34 | 4.558 | 5.136 | 1.291 | 12.06 | 33.46 |
| 231 | 15 | 34 | 41.267 | 43.681 | 18.211 | 52.57 | 26.7 |
| 3 | 254 | 34 | 11.625 | 12.869 | 2.143 | 10.76 | 10.61 |
| 145 | 217 | 34 | 17.883 | 20.416 | 4.674 | 17.74 | 16.72 |
| 231 | 38 | 34 | 74.083 | 70.013 | 22.444 | 68.25 | 21.3 |
| 232 | 185 | 34 | 36.517 | 37.361 | 15.062 | 43.96 | 25.61 |
| 242 | 235 | 34 | 30.833 | 31.2 | 5.383 | 22.43 | 11.52 |
| 235 | 140 | 34 | 30.325 | 33.847 | 8.439 | 29.25 | 16.47 |
| 247 | 50 | 34 | 28.767 | 28.493 | 7.567 | 27.79 | 16.7 |
| 161 | 8 | 34 | 22.383 | 23.915 | 6.338 | 22.6 | 15.98 |
| 159 | 250 | 34 | 18.508 | 22.431 | 4.979 | 19.08 | 15.68 |
| 134 | 145 | 34 | 33.958 | 32.247 | 9.657 | 32.99 | 20.64 |
| 135 | 129 | 34 | 17.167 | 18.93 | 6.294 | 21.01 | 21.07 |
| 211 | 21 | 34 | 32.558 | 33.776 | 11.218 | 35.26 | 20.75 |