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 |
|---|---|---|---|---|---|---|---|
| 249 | 168 | 431 | 24.7 | 26.644 | 9.029 | 28.72 | 21.46 |
| 145 | 142 | 431 | 17.317 | 20.279 | 3.848 | 25.84 | 12.45 |
| 234 | 195 | 431 | 27.25 | 29.142 | 7.087 | 25.32 | 15.63 |
| 97 | 195 | 431 | 15.917 | 16.411 | 3.099 | 13.46 | 11.94 |
| 226 | 43 | 430 | 20.017 | 22.056 | 4.21 | 26.14 | 12.49 |
| 223 | 226 | 430 | 15.1 | 16.458 | 3.423 | 14.46 | 13.58 |
| 237 | 14 | 430 | 39.608 | 41.704 | 14.744 | 44.93 | 22.43 |
| 49 | 189 | 429 | 6.533 | 7.386 | 1.081 | 6.83 | 9.53 |
| 170 | 69 | 429 | 24.85 | 27.284 | 7.755 | 25.96 | 18.8 |
| 87 | 133 | 429 | 22.483 | 25.247 | 6.996 | 23.71 | 18.61 |
| 247 | 41 | 429 | 12.4 | 13.281 | 2.315 | 11.16 | 11.12 |
| 75 | 65 | 428 | 27.575 | 29.203 | 9.523 | 29.98 | 20.76 |
| 260 | 179 | 428 | 12.5 | 13.407 | 2.693 | 11.78 | 12.91 |
| 48 | 227 | 428 | 35.367 | 37.207 | 11.469 | 36.87 | 19.55 |
| 143 | 4 | 428 | 27.075 | 28.204 | 5.445 | 22.2 | 12.42 |
| 24 | 13 | 428 | 25.875 | 26.741 | 7.636 | 26 | 18.06 |
| 13 | 106 | 427 | 16.15 | 17.693 | 4.482 | 16.55 | 16.25 |
| 209 | 42 | 427 | 25.65 | 30.415 | 10.566 | 32.78 | 24.83 |
| 209 | 7 | 427 | 24.967 | 27.413 | 9.456 | 29.74 | 22.45 |
| 137 | 196 | 426 | 20.817 | 23.316 | 7.428 | 24.4 | 21.54 |
| 168 | 69 | 426 | 9.958 | 11.074 | 1.868 | 9.5 | 10.97 |
| 10 | 233 | 426 | 37.133 | 38.881 | 13.962 | 52.14 | 24.04 |
| 66 | 107 | 426 | 18.367 | 19.352 | 4.687 | 17.75 | 15.38 |
| 33 | 48 | 425 | 31.783 | 32.629 | 6.758 | 26.41 | 13.3 |
| 65 | 89 | 425 | 21.2 | 23.185 | 5.187 | 19.89 | 14.65 |