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 |
|---|---|---|---|---|---|---|---|
| 231 | 214 | 31 | 29.9 | 30.726 | 13.613 | 39.12 | 28.02 |
| 33 | 117 | 31 | 62.317 | 63.71 | 25.01 | 72.13 | 24.68 |
| 45 | 254 | 31 | 54.95 | 60.618 | 18.894 | 55.76 | 20.91 |
| 219 | 209 | 31 | 53.9 | 57.839 | 18.598 | 52.35 | 21.17 |
| 230 | 222 | 31 | 69.517 | 66.162 | 17.445 | 57.37 | 17.76 |
| 20 | 18 | 31 | 7.8 | 9.946 | 1.325 | 8.29 | 9.02 |
| 166 | 81 | 31 | 29.3 | 34.017 | 12.934 | 38.15 | 25.27 |
| 26 | 35 | 31 | 31.367 | 36.495 | 5.938 | 25.67 | 10.71 |
| 144 | 126 | 31 | 27.833 | 28.578 | 10.933 | 33.84 | 24.29 |
| 97 | 179 | 31 | 24.583 | 27.761 | 9.739 | 30.63 | 23.49 |
| 125 | 91 | 31 | 38.383 | 42.797 | 10.734 | 37.27 | 16.37 |
| 163 | 205 | 31 | 44.267 | 51.513 | 16.625 | 51.84 | 21.2 |
| 13 | 28 | 31 | 39.883 | 41.753 | 17.08 | 48.29 | 25.3 |
| 193 | 92 | 31 | 24.25 | 28.139 | 8.097 | 27.87 | 19.18 |
| 212 | 68 | 31 | 44.45 | 44.327 | 12.725 | 38.92 | 18.05 |
| 197 | 164 | 31 | 38.867 | 42.372 | 12.842 | 47.74 | 20.89 |
| 152 | 212 | 31 | 21.15 | 23.269 | 7.169 | 23.33 | 20.49 |
| 143 | 29 | 31 | 49.85 | 52.246 | 19.095 | 57.44 | 22.66 |
| 137 | 191 | 31 | 37 | 44.305 | 16.093 | 47.47 | 24.53 |
| 249 | 31 | 31 | 38.9 | 41.225 | 15.412 | 46.29 | 24.18 |
| 181 | 117 | 31 | 48.5 | 49.814 | 20.167 | 58.26 | 25.08 |
| 141 | 180 | 31 | 39.15 | 42.711 | 12.924 | 42 | 19.8 |
| 203 | 130 | 31 | 22.667 | 22.961 | 6.778 | 24.01 | 18.68 |
| 246 | 147 | 31 | 31.783 | 35.805 | 11.556 | 37.16 | 21.4 |
| 189 | 42 | 31 | 42.75 | 41.217 | 13.899 | 41.28 | 21.78 |