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 |
|---|---|---|---|---|---|---|---|
| 107 | 123 | 165 | 36.583 | 37.659 | 13.826 | 41.64 | 23.42 |
| 130 | 186 | 165 | 36.483 | 38.56 | 13.04 | 51.59 | 21.7 |
| 173 | 56 | 165 | 6.867 | 8.095 | 1.416 | 7.47 | 11.39 |
| 25 | 158 | 165 | 20.083 | 21.242 | 4.529 | 18.14 | 13.35 |
| 66 | 36 | 165 | 22.483 | 23.311 | 4.894 | 19.39 | 13.22 |
| 159 | 47 | 165 | 13.4 | 14.161 | 2.291 | 11.31 | 10.22 |
| 87 | 168 | 165 | 22.2 | 27.069 | 10.479 | 31.36 | 26.44 |
| 238 | 248 | 165 | 21.933 | 23.762 | 9.043 | 27.88 | 26.2 |
| 37 | 177 | 165 | 12.2 | 13.425 | 2.126 | 11.11 | 9.95 |
| 229 | 212 | 165 | 21.983 | 24.263 | 9.193 | 28.45 | 24.89 |
| 26 | 227 | 165 | 9.3 | 10.941 | 1.432 | 9.07 | 8.45 |
| 74 | 130 | 165 | 30.45 | 34.45 | 13.125 | 39.6 | 26.22 |
| 255 | 262 | 165 | 23.833 | 24.882 | 7.103 | 24.09 | 17.91 |
| 224 | 226 | 165 | 19.633 | 19.88 | 4.944 | 18.17 | 15.5 |
| 113 | 258 | 165 | 37.467 | 40.336 | 11.697 | 38.74 | 18.93 |
| 164 | 169 | 165 | 29.5 | 32.968 | 10.672 | 34.08 | 21.35 |
| 52 | 125 | 165 | 20.717 | 21.14 | 3.937 | 17.03 | 11.79 |
| 209 | 95 | 165 | 32.75 | 34.679 | 12.142 | 37.36 | 22.6 |
| 234 | 92 | 165 | 32.267 | 36.185 | 12.325 | 38.55 | 22.33 |
| 17 | 181 | 165 | 15.683 | 17.232 | 2.953 | 13.65 | 10.98 |
| 151 | 167 | 165 | 25.533 | 27.952 | 6.069 | 23.07 | 14.24 |
| 82 | 258 | 164 | 18.183 | 19.131 | 4.7 | 17.47 | 15.83 |
| 69 | 74 | 164 | 17.6 | 19.567 | 3.308 | 15.31 | 10.66 |
| 170 | 119 | 164 | 25.333 | 27.78 | 8.373 | 27.39 | 20.27 |
| 33 | 224 | 164 | 16.133 | 16.932 | 5.136 | 17.52 | 19.21 |