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 | 74 | 116 | 16.8 | 19.022 | 5.549 | 19.64 | 19.26 |
| 232 | 106 | 116 | 19.867 | 20.738 | 4.898 | 18.46 | 14.79 |
| 63 | 76 | 116 | 9.983 | 10.438 | 1.779 | 9.16 | 11.06 |
| 45 | 54 | 116 | 14.9 | 15.784 | 3.528 | 13.99 | 14.9 |
| 143 | 47 | 116 | 37.467 | 39.272 | 9.034 | 32.12 | 16.59 |
| 56 | 100 | 116 | 26.825 | 28.419 | 8.365 | 49.26 | 20.07 |
| 162 | 235 | 115 | 24.833 | 28.7 | 9.369 | 29.96 | 21.7 |
| 76 | 25 | 115 | 46.35 | 45.953 | 7.552 | 31.04 | 10.27 |
| 4 | 198 | 115 | 25.9 | 27.282 | 6.777 | 24.28 | 15.42 |
| 151 | 241 | 115 | 25.85 | 27.807 | 9.173 | 29.5 | 21.45 |
| 237 | 130 | 115 | 37.383 | 40.3 | 13.698 | 42.72 | 22.24 |
| 157 | 233 | 115 | 13.017 | 15.46 | 5.312 | 49.03 | 24.26 |
| 228 | 61 | 115 | 23.367 | 27.137 | 4.647 | 20.06 | 11.28 |
| 228 | 40 | 115 | 10.083 | 11.337 | 2.143 | 10.04 | 11.82 |
| 152 | 78 | 115 | 20.633 | 21.101 | 5.984 | 20.73 | 18.5 |
| 88 | 69 | 115 | 29.2 | 37.417 | 12.232 | 37.94 | 23.38 |
| 7 | 125 | 115 | 26.7 | 26.949 | 7.295 | 24.73 | 17.1 |
| 255 | 179 | 115 | 19.583 | 20.686 | 5.754 | 20.29 | 17.39 |
| 25 | 142 | 115 | 34.083 | 35.408 | 8.481 | 30.7 | 15.51 |
| 113 | 26 | 115 | 32.833 | 35.053 | 10.028 | 33.03 | 18.19 |
| 163 | 258 | 115 | 39.55 | 40.265 | 11.205 | 37.72 | 17.75 |
| 68 | 135 | 115 | 38.317 | 40.102 | 12.666 | 40.13 | 20.54 |
| 85 | 85 | 115 | 4.15 | 5.906 | 0.864 | 6.88 | 23.61 |
| 137 | 147 | 115 | 23.467 | 26.174 | 8.054 | 26.42 | 20.41 |
| 162 | 98 | 115 | 36.283 | 38.265 | 12.303 | 37.94 | 20.73 |