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 |
|---|---|---|---|---|---|---|---|
| 181 | 68 | 258 | 27.692 | 28.876 | 6.261 | 23.94 | 13.63 |
| 231 | 34 | 258 | 17.442 | 18.299 | 3.289 | 14.72 | 11.45 |
| 257 | 181 | 257 | 7.433 | 8.784 | 1.661 | 8.49 | 12.51 |
| 41 | 213 | 257 | 20.967 | 23.02 | 6.622 | 22.49 | 19.2 |
| 231 | 26 | 257 | 26.2 | 28.399 | 7.907 | 26.78 | 18.16 |
| 193 | 170 | 257 | 16.083 | 18.804 | 3.687 | 15.54 | 13.85 |
| 260 | 193 | 257 | 11.8 | 12.866 | 2.467 | 11.01 | 12.15 |
| 45 | 145 | 257 | 22.117 | 24.229 | 6.546 | 22.9 | 17.43 |
| 166 | 119 | 257 | 17.35 | 18.381 | 4.047 | 16.06 | 14.33 |
| 231 | 165 | 257 | 29.033 | 32.35 | 9.254 | 30.64 | 18.58 |
| 43 | 220 | 257 | 22.267 | 24.79 | 9.589 | 29.54 | 25.17 |
| 219 | 230 | 256 | 49.825 | 51.991 | 16.058 | 52.5 | 20.27 |
| 162 | 197 | 256 | 35.217 | 39.259 | 12.207 | 40.22 | 20.95 |
| 157 | 170 | 256 | 11.717 | 14.07 | 5.204 | 49.93 | 26.65 |
| 170 | 250 | 256 | 26.642 | 29.785 | 11.454 | 34.89 | 24.73 |
| 33 | 50 | 256 | 28.567 | 29.63 | 6.786 | 25.51 | 14.61 |
| 10 | 130 | 256 | 11.942 | 13.978 | 2.766 | 15.17 | 13.02 |
| 193 | 234 | 256 | 17.658 | 20.692 | 4.255 | 17.17 | 13.52 |
| 143 | 179 | 256 | 26.358 | 27.408 | 5.703 | 22.29 | 13.06 |
| 224 | 181 | 256 | 24.858 | 26.561 | 7.125 | 24.64 | 17.06 |
| 226 | 238 | 256 | 22.483 | 24.726 | 5.55 | 22.51 | 14.51 |
| 239 | 61 | 256 | 46.725 | 49.546 | 11.913 | 41.56 | 15.22 |
| 164 | 67 | 255 | 33.067 | 35.319 | 12.871 | 39.16 | 22.86 |
| 107 | 247 | 255 | 24.317 | 27.695 | 8.924 | 28.64 | 22.59 |
| 87 | 198 | 255 | 30.017 | 31.555 | 8.31 | 28.3 | 16.76 |