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 |
|---|---|---|---|---|---|---|---|
| 210 | 39 | 31 | 20.567 | 22.167 | 6.083 | 21.63 | 18.23 |
| 76 | 219 | 31 | 16.517 | 17.002 | 6.408 | 21.13 | 24.16 |
| 173 | 95 | 31 | 13.067 | 16.125 | 3.47 | 14.23 | 14.63 |
| 181 | 28 | 31 | 37.183 | 39.3 | 13.548 | 42.19 | 22.15 |
| 244 | 26 | 31 | 61.05 | 65.245 | 18.397 | 59.39 | 17.54 |
| 157 | 246 | 31 | 27.933 | 27.327 | 6.645 | 49.52 | 15.68 |
| 209 | 136 | 31 | 35.517 | 38.283 | 14.591 | 43.43 | 26.59 |
| 17 | 26 | 31 | 32.85 | 33.792 | 7.645 | 27.65 | 14.44 |
| 36 | 249 | 31 | 26.15 | 26.888 | 6.252 | 23.05 | 14.39 |
| 246 | 31 | 31 | 33.867 | 37.822 | 14.489 | 43.95 | 25.66 |
| 132 | 59 | 31 | 42.017 | 46.451 | 20.929 | 59.02 | 28.75 |
| 246 | 258 | 31 | 40.567 | 43.464 | 12.262 | 40.55 | 18.1 |
| 61 | 7 | 31 | 28.083 | 30.923 | 9.811 | 31.97 | 20.65 |
| 223 | 235 | 31 | 14.783 | 16.833 | 7.612 | 22.71 | 28.85 |
| 37 | 261 | 31 | 28.95 | 33.337 | 6.577 | 27.15 | 12.94 |
| 124 | 13 | 31 | 45.317 | 47.241 | 19.952 | 52 | 29.83 |
| 133 | 261 | 31 | 22.067 | 23.287 | 5.986 | 21.52 | 16.61 |
| 45 | 193 | 31 | 30.333 | 35.687 | 7.964 | 28.55 | 15.12 |
| 261 | 109 | 31 | 46.367 | 46.756 | 19.531 | 56.61 | 25.56 |
| 76 | 203 | 31 | 22.35 | 25.117 | 9.557 | 30.25 | 24.34 |
| 22 | 97 | 31 | 37.75 | 39.501 | 7.853 | 30.8 | 12.1 |
| 82 | 166 | 31 | 31.3 | 34.842 | 8.299 | 30.02 | 15.36 |
| 21 | 230 | 31 | 45.25 | 45.097 | 14.572 | 43.45 | 19.82 |
| 42 | 35 | 31 | 43.15 | 49.774 | 18.205 | 54.3 | 23.99 |
| 25 | 63 | 31 | 32.95 | 35.916 | 6.905 | 26.55 | 12.6 |