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 |
|---|---|---|---|---|---|---|---|
| 188 | 148 | 34 | 22.567 | 23.137 | 5.089 | 20.55 | 14.05 |
| 229 | 60 | 34 | 26.492 | 31.99 | 8.613 | 29.36 | 18.55 |
| 242 | 167 | 34 | 22.725 | 23.327 | 4.279 | 18.04 | 11.42 |
| 37 | 140 | 34 | 49.2 | 44.819 | 8.281 | 31.62 | 12.87 |
| 226 | 19 | 34 | 34.033 | 35.607 | 14.192 | 41.74 | 26.4 |
| 18 | 75 | 34 | 29.725 | 33.893 | 8.377 | 29.77 | 16.07 |
| 232 | 210 | 34 | 42.842 | 44.069 | 16.967 | 50.18 | 24.92 |
| 40 | 116 | 34 | 33.45 | 34.238 | 12.571 | 38.5 | 22.74 |
| 237 | 9 | 34 | 41.85 | 45.513 | 14.379 | 45.38 | 20.13 |
| 65 | 193 | 34 | 27.542 | 26.719 | 7.205 | 24.41 | 17.55 |
| 107 | 222 | 34 | 62.575 | 64.955 | 16.756 | 55.47 | 16.62 |
| 125 | 169 | 34 | 64.592 | 60.573 | 13.108 | 46.78 | 14.43 |
| 48 | 86 | 34 | 69.708 | 70.268 | 24.99 | 76.26 | 22.04 |
| 165 | 76 | 34 | 33.05 | 34.111 | 7.258 | 27.76 | 13.24 |
| 76 | 10 | 34 | 21.267 | 25.284 | 6.72 | 23.94 | 18.4 |
| 247 | 233 | 34 | 29.317 | 31.1 | 7.642 | 26.75 | 16.17 |
| 188 | 145 | 34 | 35.925 | 37.562 | 8.329 | 29.66 | 13.83 |
| 190 | 52 | 34 | 17.533 | 17.489 | 3.028 | 13.84 | 10.75 |
| 236 | 6 | 34 | 51.25 | 52.509 | 18.506 | 54.29 | 22.33 |
| 170 | 96 | 34 | 29.417 | 33.513 | 10.479 | 34.4 | 21.08 |
| 160 | 258 | 34 | 13.475 | 15.104 | 3.296 | 12.99 | 14.86 |
| 33 | 196 | 34 | 35.417 | 34.509 | 8.566 | 28.75 | 16.68 |
| 239 | 192 | 34 | 35.967 | 38.758 | 12.935 | 40.96 | 20.99 |
| 210 | 89 | 34 | 21.217 | 21.255 | 4.242 | 17.16 | 12.42 |
| 158 | 182 | 34 | 27.2 | 31.3 | 13.813 | 40.62 | 28.38 |