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 |
|---|---|---|---|---|---|---|---|
| 43 | 18 | 40 | 30.45 | 31.603 | 10.325 | 32.9 | 20.2 |
| 254 | 74 | 40 | 30.133 | 33.705 | 9.642 | 31.37 | 18.9 |
| 161 | 122 | 40 | 59.683 | 57.17 | 16.013 | 51.32 | 18.83 |
| 114 | 94 | 40 | 32.317 | 35.029 | 13.326 | 40.38 | 24.25 |
| 237 | 53 | 40 | 36.533 | 39.121 | 12.418 | 39.64 | 20.22 |
| 13 | 10 | 40 | 53.158 | 57.113 | 21.5 | 59.4 | 24.2 |
| 65 | 160 | 40 | 24.125 | 24.962 | 7.745 | 25.34 | 20.06 |
| 230 | 221 | 40 | 45.967 | 44.499 | 16.53 | 49.59 | 22.55 |
| 226 | 72 | 40 | 48.183 | 50.302 | 11.218 | 39.56 | 13.47 |
| 125 | 76 | 40 | 45.667 | 49.874 | 11.978 | 40.39 | 15.33 |
| 13 | 18 | 40 | 38.767 | 41.195 | 17.393 | 48.96 | 26.28 |
| 19 | 131 | 40 | 12.967 | 15.572 | 4.134 | 16.23 | 16.1 |
| 62 | 132 | 40 | 37.158 | 38.138 | 11.852 | 39.86 | 19.21 |
| 36 | 229 | 40 | 35.592 | 37.776 | 7.578 | 28.71 | 13.29 |
| 4 | 12 | 40 | 10.817 | 12.736 | 3.527 | 13.5 | 18.25 |
| 68 | 15 | 40 | 40.042 | 46.095 | 17.429 | 52.19 | 24.93 |
| 129 | 238 | 40 | 31.825 | 31.645 | 8.18 | 28.5 | 16.57 |
| 21 | 149 | 40 | 15.308 | 15.338 | 2.746 | 12.74 | 11.05 |
| 61 | 155 | 40 | 26.967 | 27.88 | 5.31 | 21.18 | 11.79 |
| 3 | 81 | 40 | 9.833 | 11.051 | 1.959 | 9.95 | 10.89 |
| 24 | 147 | 40 | 24.742 | 26.076 | 5.184 | 20.95 | 12.38 |
| 181 | 11 | 40 | 21.708 | 22.287 | 7.754 | 25.06 | 22.47 |
| 18 | 94 | 40 | 6.475 | 7.01 | 0.917 | 6.44 | 8.38 |
| 8 | 75 | 40 | 11.042 | 15.526 | 4.541 | 45.84 | 23.08 |
| 219 | 151 | 40 | 43.017 | 45.68 | 18.63 | 55.32 | 25.84 |