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 |
|---|---|---|---|---|---|---|---|
| 87 | 157 | 187 | 26.9 | 29.208 | 8.958 | 29.19 | 20.27 |
| 255 | 52 | 187 | 14.967 | 16.059 | 4.944 | 16.93 | 20.03 |
| 161 | 197 | 186 | 39.358 | 44.285 | 12.563 | 42.22 | 18.74 |
| 52 | 158 | 186 | 21.067 | 22.633 | 4.942 | 19.24 | 13.76 |
| 255 | 140 | 186 | 21.567 | 22.894 | 6.093 | 21.53 | 16.75 |
| 68 | 92 | 186 | 37.4 | 38.835 | 12.65 | 40.24 | 26.21 |
| 164 | 171 | 186 | 32.15 | 33.856 | 12.906 | 39.08 | 24.06 |
| 263 | 193 | 186 | 16.35 | 17.987 | 4.101 | 15.9 | 15.21 |
| 107 | 173 | 186 | 34.883 | 36.277 | 9.308 | 32.08 | 16.67 |
| 249 | 202 | 186 | 28.308 | 30.05 | 6.83 | 24.69 | 14.64 |
| 10 | 137 | 186 | 34.4 | 36.346 | 13.983 | 52.08 | 25.86 |
| 167 | 159 | 186 | 5.9 | 6.545 | 0.93 | 6.22 | 9.59 |
| 107 | 165 | 186 | 38.6 | 40.035 | 11.892 | 38.37 | 18.75 |
| 106 | 87 | 186 | 12.442 | 13.475 | 4.364 | 15.56 | 20.3 |
| 40 | 45 | 186 | 14.25 | 15.87 | 3.458 | 14.08 | 14.26 |
| 129 | 140 | 186 | 27 | 28.016 | 6.191 | 23.14 | 14.36 |
| 164 | 28 | 185 | 28.35 | 31.128 | 11.973 | 36.39 | 24.76 |
| 100 | 78 | 185 | 34.517 | 37.23 | 11.305 | 36.66 | 19.92 |
| 181 | 261 | 185 | 17.45 | 19.248 | 4.035 | 16.47 | 13.46 |
| 7 | 196 | 185 | 19.167 | 20.696 | 6.355 | 21.65 | 19.72 |
| 237 | 173 | 185 | 30.117 | 31.333 | 7.212 | 26.63 | 14.39 |
| 49 | 231 | 185 | 17.6 | 18.957 | 3.626 | 17.46 | 12.54 |
| 100 | 208 | 185 | 34.083 | 37.175 | 14.424 | 43.26 | 30.25 |
| 143 | 95 | 185 | 41.083 | 43.003 | 10.888 | 38.11 | 16.21 |
| 92 | 129 | 185 | 16.017 | 18.56 | 4.391 | 17.12 | 15.2 |