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 |
|---|---|---|---|---|---|---|---|
| 186 | 160 | 538 | 27.492 | 30.608 | 7.906 | 28.26 | 16.96 |
| 217 | 256 | 538 | 3.975 | 4.968 | 0.782 | 5.4 | 11.15 |
| 17 | 97 | 538 | 9.425 | 10.638 | 1.745 | 9.05 | 10.75 |
| 229 | 37 | 538 | 26.6 | 28.904 | 7.26 | 25.55 | 15.93 |
| 234 | 202 | 537 | 25.25 | 26.778 | 5.655 | 21.52 | 13.41 |
| 74 | 223 | 537 | 13.7 | 15.121 | 4.733 | 16.77 | 20.62 |
| 40 | 13 | 537 | 10.867 | 12.315 | 3.176 | 13.62 | 17.24 |
| 246 | 95 | 537 | 33.767 | 36.198 | 10.38 | 34.6 | 18.63 |
| 74 | 212 | 536 | 15.033 | 17.166 | 5.107 | 17.82 | 19.91 |
| 70 | 95 | 536 | 10.292 | 11.567 | 4.381 | 14.69 | 28.44 |
| 247 | 74 | 536 | 10.95 | 11.905 | 2.149 | 10.48 | 11.8 |
| 161 | 134 | 536 | 33.042 | 36.458 | 11.979 | 38.8 | 21.92 |
| 255 | 25 | 536 | 16.833 | 17.948 | 4.363 | 16.66 | 15.82 |
| 161 | 198 | 535 | 29.167 | 30.897 | 7.483 | 26.64 | 15.27 |
| 170 | 70 | 535 | 25.217 | 29.206 | 9.109 | 30.17 | 21.83 |
| 163 | 247 | 534 | 26.325 | 28.838 | 7.312 | 26.15 | 17.04 |
| 137 | 52 | 534 | 20.917 | 22.577 | 6.292 | 21.3 | 18.26 |
| 113 | 106 | 534 | 24.833 | 25.404 | 5.321 | 20.75 | 13.16 |
| 138 | 124 | 534 | 33.433 | 36.141 | 12.745 | 38.54 | 23.34 |
| 162 | 188 | 533 | 38.033 | 40.036 | 10.318 | 35.34 | 16.31 |
| 161 | 188 | 533 | 42.883 | 44.447 | 10.665 | 37.42 | 15.1 |
| 107 | 217 | 533 | 22.233 | 23.389 | 3.983 | 18.33 | 10.87 |
| 152 | 186 | 533 | 20.683 | 22.322 | 6.33 | 22.45 | 18.28 |
| 125 | 7 | 532 | 31.067 | 32.205 | 8.44 | 29.26 | 17.54 |
| 130 | 230 | 532 | 39.4 | 41.355 | 13.349 | 51.97 | 21.24 |