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 |
|---|---|---|---|---|---|---|---|
| 74 | 119 | 661 | 12.583 | 14.493 | 3.489 | 13.71 | 16.9 |
| 181 | 66 | 661 | 13.917 | 14.559 | 2.213 | 11.44 | 9.5 |
| 116 | 127 | 660 | 12 | 13.276 | 3.82 | 14.14 | 18.4 |
| 80 | 79 | 660 | 14.958 | 16.115 | 3.593 | 17.26 | 14.54 |
| 261 | 89 | 659 | 22.117 | 24.323 | 7.185 | 24.17 | 19.29 |
| 262 | 69 | 659 | 15.5 | 17.18 | 4.481 | 16.53 | 17.01 |
| 261 | 228 | 659 | 18.217 | 19.667 | 5.661 | 19.88 | 18.37 |
| 4 | 163 | 659 | 20.467 | 21.8 | 3.895 | 17.01 | 11.6 |
| 97 | 89 | 659 | 20.117 | 21.33 | 4.188 | 17.39 | 12.58 |
| 7 | 48 | 659 | 21.65 | 23.986 | 4.661 | 19.27 | 12.66 |
| 40 | 66 | 659 | 11.5 | 12.265 | 2.034 | 10.05 | 10.69 |
| 255 | 145 | 659 | 12.3 | 12.92 | 2.644 | 11.55 | 12.8 |
| 93 | 48 | 658 | 33.125 | 35.744 | 10.588 | 51.84 | 19.81 |
| 138 | 203 | 658 | 33.258 | 36.738 | 14.931 | 43.41 | 26.96 |
| 151 | 87 | 657 | 30.333 | 32.068 | 8.705 | 29.82 | 17.41 |
| 231 | 62 | 657 | 26.783 | 27.996 | 5.513 | 21.83 | 12.58 |
| 238 | 145 | 657 | 25.15 | 26.452 | 5.277 | 21.11 | 12.8 |
| 106 | 228 | 657 | 7.75 | 8.42 | 1.773 | 8.51 | 13.3 |
| 90 | 95 | 657 | 31.85 | 34.5 | 10.065 | 33.24 | 19.01 |
| 42 | 230 | 656 | 25.158 | 26.571 | 5.409 | 21.54 | 13.47 |
| 33 | 186 | 656 | 25.483 | 26.493 | 5.288 | 21.31 | 12.93 |
| 50 | 226 | 656 | 22.942 | 24.535 | 5.039 | 20.4 | 13.29 |
| 66 | 79 | 656 | 15.475 | 16.095 | 3.987 | 15.24 | 15.64 |
| 25 | 225 | 655 | 19.4 | 20.329 | 3.553 | 15.73 | 11.02 |
| 137 | 14 | 655 | 29.283 | 31.36 | 12.403 | 36.85 | 25.29 |