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 |
|---|---|---|---|---|---|---|---|
| 119 | 230 | 36 | 29.117 | 30.942 | 8.466 | 29.62 | 17.42 |
| 127 | 94 | 36 | 15.008 | 14.971 | 2.231 | 11.58 | 9.21 |
| 223 | 225 | 36 | 29.367 | 30.35 | 8.306 | 28.28 | 17.45 |
| 168 | 7 | 36 | 17.133 | 18.931 | 5.12 | 18.18 | 17.83 |
| 61 | 205 | 36 | 42.9 | 44.322 | 12.281 | 39.64 | 17.24 |
| 246 | 20 | 36 | 32.583 | 34.301 | 12.176 | 37.81 | 22.95 |
| 237 | 139 | 36 | 54.367 | 62.487 | 22.099 | 65.14 | 23.87 |
| 146 | 24 | 36 | 26.042 | 26.984 | 5.368 | 21.36 | 12.69 |
| 261 | 219 | 36 | 54 | 55.569 | 21.907 | 60.36 | 25.23 |
| 66 | 26 | 36 | 26.392 | 27.208 | 6.589 | 24.75 | 16.11 |
| 65 | 135 | 36 | 24.133 | 28.058 | 12.345 | 35.55 | 28.66 |
| 88 | 221 | 36 | 27.3 | 31.713 | 13.629 | 39.79 | 28.09 |
| 256 | 244 | 36 | 33.925 | 37.711 | 13.185 | 41.24 | 22.96 |
| 168 | 239 | 35 | 21.133 | 23.045 | 4.788 | 19.28 | 13.48 |
| 113 | 60 | 35 | 29.683 | 36.657 | 11.416 | 36.53 | 20.96 |
| 118 | 229 | 35 | 89.2 | 87.694 | 30.725 | 90.11 | 21.52 |
| 56 | 260 | 35 | 14.45 | 15.491 | 3.493 | 15.13 | 14.63 |
| 63 | 170 | 35 | 53.683 | 52.34 | 12.626 | 44.25 | 15.23 |
| 76 | 233 | 35 | 36.467 | 39.522 | 13.453 | 41.67 | 21.01 |
| 238 | 157 | 35 | 37.533 | 37.91 | 9.032 | 32.03 | 14.71 |
| 235 | 167 | 35 | 17.217 | 18.089 | 2.819 | 13.6 | 9.89 |
| 226 | 62 | 35 | 35.133 | 37.269 | 6.836 | 27.29 | 11.89 |
| 143 | 16 | 35 | 32 | 33.836 | 14.679 | 43.21 | 26.51 |
| 215 | 4 | 35 | 33.9 | 34.44 | 14.943 | 52.04 | 27.28 |
| 39 | 65 | 35 | 48.567 | 49.246 | 9.486 | 34.96 | 12.32 |