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 |
|---|---|---|---|---|---|---|---|
| 256 | 226 | 282 | 16.325 | 16.969 | 4.003 | 15.4 | 15.15 |
| 43 | 200 | 282 | 24.683 | 26.598 | 10.332 | 31.6 | 24.7 |
| 145 | 263 | 282 | 13.508 | 15.028 | 3.675 | 14.56 | 16.22 |
| 237 | 36 | 282 | 32.492 | 34.382 | 7.751 | 28.27 | 14.19 |
| 132 | 46 | 282 | 37.958 | 41.166 | 21.771 | 59.24 | 33.76 |
| 100 | 35 | 282 | 51.3 | 53.328 | 12.39 | 43.78 | 14.99 |
| 170 | 227 | 282 | 31.733 | 33.46 | 11.41 | 35.68 | 21.86 |
| 24 | 114 | 282 | 29.533 | 30.951 | 6.974 | 26.12 | 14.22 |
| 166 | 144 | 282 | 34.725 | 35.885 | 8.027 | 30.18 | 15.78 |
| 238 | 119 | 282 | 20.425 | 21.966 | 5.975 | 21.14 | 18.42 |
| 137 | 157 | 282 | 16.892 | 19.439 | 5.83 | 20.16 | 19.96 |
| 228 | 14 | 282 | 10.308 | 11.032 | 2.267 | 10.33 | 12.77 |
| 249 | 217 | 282 | 21.008 | 22.149 | 4.119 | 17.95 | 12.04 |
| 148 | 196 | 282 | 18.392 | 21.256 | 8.483 | 26.47 | 26.61 |
| 24 | 87 | 282 | 32.533 | 34.357 | 8.985 | 31.16 | 16.55 |
| 88 | 179 | 281 | 26.9 | 28.543 | 10.185 | 31.48 | 22.88 |
| 186 | 254 | 281 | 40.3 | 44.216 | 15.923 | 48.6 | 23.39 |
| 263 | 37 | 281 | 29.967 | 31.81 | 9.261 | 30.84 | 18.39 |
| 145 | 246 | 281 | 22.133 | 24.491 | 3.982 | 39.98 | 10.88 |
| 52 | 88 | 281 | 15.5 | 16.474 | 3.762 | 15.02 | 14.69 |
| 226 | 148 | 281 | 21.317 | 22.189 | 5.453 | 33.86 | 16.46 |
| 232 | 143 | 281 | 27.5 | 28.704 | 6.068 | 23.39 | 13.41 |
| 230 | 167 | 281 | 28.2 | 30.224 | 9.457 | 30.64 | 19.83 |
| 148 | 202 | 280 | 22.658 | 24.117 | 7.359 | 24.1 | 19 |
| 36 | 198 | 280 | 6.892 | 7.781 | 1.341 | 7.33 | 10.89 |