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 |
|---|---|---|---|---|---|---|---|
| 65 | 190 | 318 | 17.058 | 18.241 | 2.89 | 14.07 | 9.99 |
| 56 | 170 | 318 | 16.808 | 19.627 | 7.615 | 48.81 | 27.1 |
| 181 | 80 | 318 | 18.208 | 19.636 | 4.855 | 18.2 | 16.02 |
| 243 | 42 | 318 | 13.908 | 14.734 | 3.426 | 13.93 | 15.49 |
| 107 | 196 | 317 | 22.283 | 25.208 | 8.158 | 26.76 | 21.91 |
| 229 | 36 | 317 | 29.933 | 32.008 | 7.561 | 27.09 | 15.08 |
| 151 | 224 | 317 | 24.117 | 25.277 | 6.235 | 22.61 | 15.57 |
| 75 | 182 | 317 | 22.4 | 24.838 | 7.572 | 24.85 | 20.1 |
| 170 | 173 | 317 | 30.483 | 31.863 | 8.315 | 28.8 | 16.94 |
| 137 | 159 | 317 | 20.083 | 23.503 | 7.231 | 23.89 | 20.64 |
| 173 | 129 | 317 | 7.433 | 8.687 | 1.316 | 7.67 | 9.43 |
| 50 | 95 | 317 | 33.833 | 36.417 | 11.052 | 36.24 | 19.25 |
| 262 | 181 | 317 | 31.033 | 32.193 | 10.592 | 33.25 | 20.97 |
| 166 | 159 | 317 | 18.65 | 20.19 | 3.391 | 15.54 | 10.61 |
| 113 | 195 | 317 | 25.933 | 27.408 | 6.23 | 22.8 | 14.45 |
| 230 | 22 | 316 | 41.1 | 42.295 | 14.486 | 44.75 | 21.47 |
| 166 | 148 | 316 | 34.392 | 36.281 | 8.726 | 31.29 | 15.35 |
| 43 | 80 | 316 | 29.375 | 30.88 | 7.039 | 26.14 | 14.14 |
| 233 | 70 | 316 | 24.467 | 27.545 | 9.222 | 29.65 | 22.99 |
| 230 | 212 | 316 | 25.992 | 29.32 | 10.605 | 32.79 | 23.6 |
| 238 | 255 | 316 | 37.067 | 38.386 | 8.757 | 31.98 | 14.21 |
| 238 | 235 | 316 | 19.267 | 21.312 | 6.794 | 22.58 | 21.59 |
| 157 | 230 | 316 | 24.9 | 27.544 | 6.358 | 50.96 | 15.9 |
| 97 | 36 | 316 | 20.542 | 21.345 | 4.156 | 17.01 | 12.19 |
| 256 | 113 | 316 | 17.967 | 18.963 | 3.478 | 17.11 | 11.89 |