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 |
|---|---|---|---|---|---|---|---|
| 130 | 100 | 168 | 35.608 | 37.734 | 12.749 | 51.5 | 22.11 |
| 79 | 39 | 168 | 49.342 | 54.903 | 16.172 | 51.74 | 18.42 |
| 100 | 259 | 168 | 34.675 | 37.675 | 15.518 | 46.44 | 26.27 |
| 148 | 220 | 168 | 34.325 | 36.229 | 14.884 | 43.8 | 26.04 |
| 82 | 186 | 168 | 23.758 | 27.159 | 7.392 | 48.42 | 19.05 |
| 140 | 71 | 168 | 51.733 | 53.919 | 13.33 | 45.52 | 15.52 |
| 186 | 29 | 168 | 45.417 | 47.416 | 17.835 | 53.45 | 23.71 |
| 229 | 165 | 168 | 39.475 | 41.247 | 13.959 | 42.89 | 21.27 |
| 74 | 144 | 168 | 24.35 | 26.352 | 7.983 | 26.24 | 19.85 |
| 255 | 261 | 168 | 21.133 | 22.177 | 5.654 | 20.51 | 16.42 |
| 168 | 244 | 168 | 17.883 | 19.366 | 3.655 | 16.18 | 12.88 |
| 256 | 246 | 168 | 27.208 | 28.328 | 5.508 | 22.47 | 12.39 |
| 93 | 151 | 168 | 25.983 | 28.574 | 11.703 | 51.4 | 26.27 |
| 163 | 26 | 168 | 48.733 | 49.998 | 13.65 | 45.39 | 17.69 |
| 116 | 169 | 168 | 17.467 | 18.742 | 4.027 | 16.05 | 13.81 |
| 151 | 181 | 168 | 41.125 | 43.19 | 12.074 | 39.75 | 17.51 |
| 137 | 92 | 167 | 32.6 | 34.967 | 11.275 | 35.33 | 21.72 |
| 170 | 208 | 167 | 30.15 | 33.864 | 12.809 | 38.57 | 24.74 |
| 4 | 189 | 167 | 24.083 | 24.509 | 5.716 | 21.39 | 14.51 |
| 263 | 93 | 167 | 26.25 | 28.907 | 10.727 | 33.09 | 24.59 |
| 80 | 231 | 167 | 18.367 | 19.739 | 4.962 | 26.25 | 16.06 |
| 226 | 41 | 167 | 28.1 | 30.017 | 6.583 | 25.02 | 14.08 |
| 186 | 210 | 167 | 47.85 | 50.611 | 18.362 | 55.1 | 23 |
| 74 | 254 | 167 | 24.9 | 28.267 | 9.954 | 31 | 23.43 |
| 244 | 79 | 167 | 32.383 | 34.17 | 10.426 | 33.68 | 19.88 |