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 |
|---|---|---|---|---|---|---|---|
| 28 | 101 | 23 | 22.967 | 23.446 | 7.464 | 29.76 | 22.26 |
| 53 | 252 | 23 | 11.317 | 11.426 | 2.385 | 10.63 | 12.76 |
| 148 | 251 | 23 | 33.05 | 34.336 | 17.638 | 49.59 | 31.82 |
| 7 | 35 | 23 | 34.417 | 37.637 | 14.341 | 43.04 | 24.92 |
| 170 | 86 | 23 | 86.883 | 82.856 | 22.943 | 73.31 | 17.63 |
| 134 | 234 | 23 | 26.7 | 28.521 | 11.614 | 50.72 | 25.54 |
| 229 | 3 | 23 | 33.4 | 34.971 | 13.089 | 39.76 | 23.74 |
| 216 | 225 | 23 | 33.45 | 35.657 | 9.267 | 31.8 | 15.52 |
| 246 | 131 | 23 | 45.583 | 49.445 | 15.707 | 48.33 | 20.98 |
| 124 | 170 | 23 | 46.05 | 45.84 | 12.317 | 40.52 | 16.77 |
| 247 | 129 | 23 | 21.017 | 21.645 | 8.12 | 25.44 | 23.97 |
| 70 | 43 | 23 | 27.45 | 27.936 | 8.047 | 26.96 | 17.46 |
| 92 | 37 | 23 | 36.717 | 34.205 | 9.461 | 31.03 | 18.01 |
| 24 | 126 | 23 | 27.133 | 27.902 | 5.732 | 22.65 | 12.93 |
| 217 | 170 | 23 | 35.267 | 35.612 | 5.412 | 24.2 | 9.96 |
| 89 | 80 | 23 | 30.7 | 32.175 | 7.286 | 27.02 | 15.04 |
| 197 | 65 | 23 | 46.717 | 47.443 | 14.333 | 45.49 | 18.77 |
| 244 | 70 | 23 | 27.8 | 31.463 | 10.41 | 34.03 | 22.61 |
| 260 | 57 | 23 | 16.35 | 17.345 | 3.542 | 14.63 | 12.78 |
| 209 | 11 | 23 | 29.417 | 31.728 | 10.715 | 33.43 | 21.26 |
| 159 | 238 | 23 | 24.033 | 25.022 | 4.94 | 19.98 | 12.89 |
| 97 | 197 | 23 | 32.733 | 33.364 | 12.201 | 37.38 | 23.48 |
| 36 | 186 | 23 | 29.483 | 30.201 | 7.563 | 26.5 | 15.88 |
| 174 | 75 | 23 | 36.583 | 41.499 | 10.197 | 35.65 | 16.37 |
| 158 | 174 | 23 | 38.367 | 39.232 | 16.141 | 48.09 | 25.85 |