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 |
|---|---|---|---|---|---|---|---|
| 144 | 223 | 569 | 26.85 | 28.845 | 9.349 | 30.45 | 21.91 |
| 224 | 238 | 569 | 24.283 | 25.618 | 5.747 | 21.71 | 14.5 |
| 168 | 41 | 568 | 11.608 | 12.906 | 1.916 | 10.39 | 9.88 |
| 97 | 188 | 568 | 16.475 | 17.792 | 3.195 | 14.22 | 11.59 |
| 39 | 39 | 568 | 6.75 | 8.252 | 1.4 | 8.8 | 22.42 |
| 226 | 262 | 567 | 18.783 | 20.302 | 4.212 | 18.14 | 13.62 |
| 138 | 136 | 567 | 26.867 | 30.175 | 10.817 | 33.61 | 24.1 |
| 256 | 198 | 567 | 15 | 15.707 | 3.309 | 13.4 | 13.15 |
| 66 | 261 | 567 | 10.317 | 11.203 | 2.492 | 11.26 | 14.5 |
| 239 | 12 | 566 | 26.367 | 27.4 | 6.755 | 24.41 | 15.44 |
| 233 | 52 | 566 | 23.483 | 24.821 | 6.957 | 23.35 | 18.07 |
| 223 | 238 | 566 | 21.092 | 23.545 | 7.051 | 45.94 | 19.68 |
| 75 | 145 | 566 | 18.092 | 19.629 | 4.701 | 17.49 | 16.7 |
| 233 | 82 | 565 | 24.967 | 26.505 | 6.614 | 23.69 | 16.36 |
| 79 | 69 | 565 | 24.317 | 26.237 | 9.418 | 29.16 | 23.21 |
| 256 | 4 | 565 | 11.533 | 12.226 | 2.428 | 12.65 | 13.51 |
| 4 | 181 | 565 | 23.3 | 23.857 | 6.112 | 21.88 | 16.12 |
| 223 | 239 | 565 | 24.217 | 25.534 | 7.621 | 45.24 | 19.18 |
| 261 | 166 | 564 | 30.2 | 32.768 | 8.466 | 29.87 | 16.6 |
| 7 | 163 | 563 | 17.667 | 20.028 | 3.787 | 16.26 | 12.5 |
| 100 | 52 | 563 | 28.683 | 30.272 | 7.043 | 25.31 | 14.92 |
| 125 | 189 | 562 | 22.517 | 24.113 | 4.539 | 18.92 | 11.97 |
| 33 | 249 | 562 | 18.7 | 19.651 | 3.952 | 16.38 | 12.75 |
| 238 | 181 | 562 | 40.083 | 42.573 | 11.611 | 38.77 | 17.15 |
| 230 | 93 | 562 | 44.375 | 46.101 | 12.608 | 42.55 | 17.83 |