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 |
|---|---|---|---|---|---|---|---|
| 157 | 234 | 95 | 17.383 | 18.634 | 5.995 | 49.84 | 21.65 |
| 80 | 138 | 95 | 16.783 | 21.129 | 7.844 | 25.64 | 25.48 |
| 145 | 70 | 95 | 19.467 | 22.236 | 6.327 | 22.57 | 19.4 |
| 246 | 173 | 95 | 41.5 | 44.055 | 10.428 | 37.16 | 15.11 |
| 24 | 65 | 95 | 28.1 | 32.208 | 10.541 | 33.57 | 20.92 |
| 95 | 164 | 95 | 30.867 | 31.227 | 8.672 | 31.21 | 17.72 |
| 143 | 136 | 95 | 24.4 | 25.73 | 9.46 | 29.43 | 23.33 |
| 186 | 98 | 95 | 36.783 | 38.254 | 13.152 | 40.94 | 22.45 |
| 231 | 258 | 95 | 40.967 | 42.812 | 12.801 | 41.41 | 20.22 |
| 256 | 146 | 95 | 18.283 | 19.272 | 4.337 | 16.8 | 13.94 |
| 162 | 81 | 95 | 37.433 | 43.358 | 15.101 | 45.41 | 23.67 |
| 41 | 200 | 95 | 21.567 | 23.799 | 8.211 | 26.39 | 22.03 |
| 234 | 147 | 95 | 27.767 | 31.031 | 9.37 | 30.81 | 19.84 |
| 262 | 216 | 95 | 39.033 | 42.658 | 16.506 | 50.72 | 26.43 |
| 166 | 254 | 95 | 26.5 | 29.129 | 10.945 | 33.52 | 23.7 |
| 152 | 167 | 95 | 20.983 | 22.089 | 4.588 | 18.47 | 13.31 |
| 12 | 255 | 95 | 25.783 | 27.191 | 5.655 | 22.25 | 12.96 |
| 33 | 35 | 95 | 34.283 | 34.475 | 5.73 | 24.47 | 10.47 |
| 7 | 256 | 95 | 20.3 | 21.249 | 5.935 | 20.79 | 18.42 |
| 237 | 174 | 95 | 31.15 | 34.145 | 12.395 | 38.03 | 23.26 |
| 137 | 190 | 95 | 29.75 | 31.417 | 8.115 | 28.33 | 16.56 |
| 48 | 77 | 95 | 53.183 | 54.75 | 14.192 | 46.97 | 16.93 |
| 42 | 129 | 95 | 18.433 | 20.779 | 7.188 | 23.25 | 22.72 |
| 163 | 178 | 95 | 41.55 | 46.021 | 13.417 | 43.28 | 18.65 |
| 45 | 22 | 95 | 33.883 | 34.331 | 10.128 | 32.82 | 19.16 |