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 |
|---|---|---|---|---|---|---|---|
| 74 | 93 | 45 | 20.283 | 23.925 | 9.787 | 31.8 | 27.93 |
| 7 | 97 | 45 | 28.817 | 28.467 | 8.159 | 27.54 | 19.71 |
| 243 | 94 | 45 | 13.05 | 14.291 | 2.545 | 11.78 | 11.34 |
| 70 | 164 | 45 | 31.1 | 33.749 | 10.06 | 33.36 | 18.89 |
| 163 | 19 | 45 | 39.967 | 42.267 | 16.505 | 49.39 | 24.77 |
| 49 | 164 | 45 | 26.967 | 29.077 | 6.674 | 24.81 | 14.52 |
| 141 | 10 | 45 | 41.833 | 47.86 | 15.64 | 48.52 | 22.84 |
| 8 | 263 | 45 | 13.233 | 13.842 | 4.812 | 48.18 | 22.87 |
| 88 | 121 | 45 | 37.9 | 42.173 | 15.662 | 46.33 | 23.45 |
| 144 | 72 | 45 | 35.367 | 36.596 | 7.641 | 28.97 | 13.34 |
| 114 | 35 | 45 | 34.233 | 36.76 | 8.112 | 29.62 | 14 |
| 82 | 193 | 45 | 19.417 | 20.761 | 4.76 | 19.38 | 14.34 |
| 7 | 192 | 45 | 18.767 | 19.951 | 7.695 | 23.99 | 25.25 |
| 166 | 80 | 45 | 36.683 | 41.473 | 10.908 | 37.56 | 17.21 |
| 186 | 101 | 45 | 42.767 | 49.558 | 17.834 | 54.22 | 24.27 |
| 68 | 183 | 45 | 37.983 | 42.079 | 15.601 | 46.23 | 24.01 |
| 226 | 89 | 45 | 38.967 | 43.708 | 11.945 | 39.82 | 19.97 |
| 234 | 191 | 45 | 50.75 | 53.144 | 18.035 | 55.27 | 22.12 |
| 36 | 89 | 45 | 28 | 32.303 | 7.174 | 26.28 | 14.07 |
| 12 | 195 | 45 | 18.867 | 19.984 | 5.133 | 17.78 | 16.35 |
| 41 | 202 | 45 | 25.433 | 28.9 | 7.28 | 25.68 | 16.31 |
| 217 | 36 | 45 | 13.133 | 13.839 | 2.427 | 11.31 | 10.85 |
| 196 | 231 | 45 | 26.867 | 30.71 | 10.859 | 47.47 | 23.7 |
| 194 | 223 | 45 | 6.767 | 9.033 | 3.448 | 13.52 | 28.6 |
| 158 | 92 | 45 | 44.45 | 45.054 | 14.7 | 46.11 | 20.53 |