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 | 164 | 224 | 30.317 | 31.479 | 8.158 | 29.07 | 16.69 |
| 140 | 136 | 224 | 22.35 | 25.663 | 8.963 | 28.21 | 23.44 |
| 260 | 196 | 224 | 13 | 14.683 | 3.191 | 13.32 | 14.2 |
| 65 | 239 | 224 | 31.475 | 32.947 | 8.683 | 30.07 | 16.77 |
| 49 | 66 | 223 | 11.167 | 11.838 | 2.1 | 10.1 | 11.14 |
| 170 | 51 | 223 | 43.817 | 47.14 | 14.95 | 46.42 | 21.15 |
| 232 | 40 | 223 | 18.467 | 19.474 | 4.575 | 17.09 | 14.92 |
| 28 | 130 | 223 | 6.933 | 8.1 | 1.378 | 7.6 | 11.02 |
| 129 | 161 | 223 | 21.55 | 26.599 | 6.595 | 23.4 | 15.88 |
| 135 | 44 | 223 | 60.117 | 62.661 | 38.192 | 102.81 | 37.88 |
| 193 | 229 | 223 | 12.283 | 14.912 | 2.571 | 13.62 | 12.8 |
| 152 | 7 | 223 | 29.033 | 28.793 | 7.099 | 25.96 | 15.24 |
| 10 | 249 | 223 | 46.7 | 49.314 | 15.948 | 52.21 | 21.1 |
| 50 | 257 | 223 | 29.533 | 32.698 | 9.839 | 32.16 | 19.15 |
| 127 | 42 | 223 | 13.083 | 13.964 | 4.216 | 15.26 | 19.36 |
| 66 | 106 | 223 | 15.067 | 15.373 | 2.679 | 12.79 | 11.05 |
| 179 | 113 | 223 | 26.717 | 28.923 | 6.086 | 23.25 | 14.06 |
| 7 | 88 | 223 | 28.967 | 30.138 | 9.244 | 30.66 | 20.69 |
| 137 | 173 | 222 | 30.367 | 33.108 | 8.54 | 29.5 | 16.95 |
| 168 | 167 | 222 | 11.058 | 12.092 | 2.04 | 10.16 | 10.86 |
| 89 | 133 | 222 | 8.158 | 9.431 | 1.21 | 7.9 | 8.71 |
| 141 | 257 | 222 | 27.192 | 30.051 | 11.96 | 35.7 | 26.3 |
| 188 | 17 | 222 | 14.883 | 16.405 | 2.716 | 12.97 | 10.75 |
| 142 | 195 | 222 | 36.8 | 38.279 | 9.721 | 33.4 | 16.12 |
| 181 | 137 | 222 | 24.508 | 26.533 | 6.604 | 24.01 | 15.89 |