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 |
|---|---|---|---|---|---|---|---|
| 50 | 224 | 1142 | 21.417 | 22.556 | 3.557 | 16.48 | 10.08 |
| 158 | 112 | 1141 | 27.333 | 28.534 | 6.37 | 24.11 | 14.12 |
| 140 | 25 | 1140 | 24.475 | 26.252 | 8.049 | 26.42 | 20.08 |
| 75 | 4 | 1140 | 18.958 | 20.116 | 5.867 | 20 | 19.49 |
| 148 | 179 | 1139 | 21.25 | 22.979 | 8.296 | 26.2 | 23.17 |
| 75 | 231 | 1139 | 30 | 30.947 | 8.437 | 28.81 | 17.79 |
| 107 | 260 | 1139 | 22.1 | 23.746 | 6.173 | 21.88 | 16.59 |
| 186 | 36 | 1139 | 36.017 | 37.917 | 8.027 | 30.3 | 13.56 |
| 186 | 257 | 1139 | 30.833 | 33.014 | 9.265 | 31.03 | 17.93 |
| 231 | 257 | 1139 | 19.067 | 20.546 | 6.173 | 20.82 | 19.49 |
| 249 | 106 | 1138 | 21.875 | 23.463 | 5.414 | 20.24 | 14.6 |
| 237 | 82 | 1137 | 27.583 | 28.329 | 6.269 | 23.81 | 13.94 |
| 216 | 216 | 1136 | 1.058 | 4.666 | 1.322 | 28.4 | 114.72 |
| 226 | 48 | 1134 | 23.875 | 26.642 | 4.528 | 35.15 | 11.94 |
| 152 | 142 | 1133 | 16.95 | 17.416 | 3.886 | 15.72 | 14.21 |
| 144 | 74 | 1133 | 24.467 | 26.473 | 7.467 | 25.19 | 18.31 |
| 12 | 164 | 1132 | 24.475 | 25.948 | 5.354 | 21.64 | 13.32 |
| 238 | 88 | 1132 | 28.283 | 29.01 | 8.155 | 27.82 | 18.31 |
| 7 | 162 | 1129 | 15.717 | 17.602 | 3.529 | 14.88 | 13.37 |
| 186 | 168 | 1128 | 27.025 | 29.556 | 7.729 | 27.24 | 17.17 |
| 239 | 181 | 1128 | 39.375 | 40.955 | 10.964 | 36.94 | 16.75 |
| 230 | 225 | 1127 | 39.85 | 40.945 | 8.726 | 32.5 | 13.44 |
| 261 | 14 | 1127 | 20.567 | 22.073 | 8.362 | 25.91 | 24.2 |
| 230 | 247 | 1127 | 28.567 | 31.59 | 8.373 | 29.19 | 17.86 |
| 163 | 127 | 1126 | 22.033 | 24.819 | 9.162 | 28.86 | 24.45 |