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 |
|---|---|---|---|---|---|---|---|
| 127 | 127 | 958 | 3.183 | 4.544 | 0.817 | 7.93 | 19.65 |
| 238 | 232 | 958 | 26.483 | 27.608 | 7.383 | 25.71 | 17.14 |
| 4 | 237 | 958 | 18.583 | 19.662 | 3.93 | 16.39 | 13.2 |
| 262 | 226 | 958 | 18.333 | 19.618 | 4.367 | 17.2 | 14.11 |
| 75 | 249 | 957 | 27.55 | 28.671 | 6.26 | 23.71 | 14.26 |
| 161 | 82 | 956 | 27.467 | 28.576 | 6.631 | 24.6 | 14.66 |
| 186 | 220 | 956 | 28.65 | 31.747 | 11.635 | 36.05 | 23.61 |
| 138 | 101 | 956 | 27.9 | 31.751 | 13.474 | 39.28 | 28.19 |
| 164 | 82 | 955 | 26.2 | 27.948 | 7.499 | 26 | 17.22 |
| 74 | 234 | 954 | 24.308 | 25.421 | 5.933 | 21.95 | 15.69 |
| 164 | 52 | 953 | 25.85 | 26.862 | 6.715 | 23.63 | 15.97 |
| 232 | 229 | 952 | 13.5 | 14.97 | 3.687 | 14.24 | 16.38 |
| 74 | 163 | 952 | 18.908 | 20.407 | 3.83 | 16.5 | 12.75 |
| 234 | 228 | 951 | 29.967 | 31.203 | 8.613 | 29.13 | 17.51 |
| 24 | 234 | 951 | 27.2 | 28.659 | 5.835 | 23.13 | 13.1 |
| 65 | 209 | 950 | 7.167 | 8.066 | 2.047 | 10.22 | 17.31 |
| 48 | 225 | 950 | 38.992 | 41.293 | 8.843 | 32.92 | 13.61 |
| 43 | 4 | 950 | 21.308 | 22.789 | 5.06 | 19.56 | 14.32 |
| 17 | 217 | 949 | 4.7 | 5.692 | 0.832 | 5.74 | 10.54 |
| 49 | 61 | 949 | 9.033 | 9.95 | 1.731 | 8.84 | 11.08 |
| 230 | 36 | 948 | 33.6 | 35.887 | 8.444 | 30.22 | 14.86 |
| 158 | 116 | 948 | 22.467 | 24.479 | 8.06 | 26.28 | 20.77 |
| 116 | 247 | 948 | 9.817 | 11.178 | 1.738 | 9.49 | 10.02 |
| 93 | 170 | 947 | 18.933 | 21.12 | 9.172 | 51.05 | 29.34 |
| 261 | 49 | 946 | 21.692 | 22.227 | 4.275 | 17.59 | 12.01 |