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 |
|---|---|---|---|---|---|---|---|
| 25 | 145 | 84 | 21.725 | 24.156 | 6.781 | 23.42 | 18.16 |
| 74 | 31 | 84 | 20.133 | 23.967 | 7.633 | 24.98 | 21.58 |
| 37 | 157 | 84 | 9.167 | 10.31 | 2.326 | 10.15 | 14.55 |
| 235 | 41 | 84 | 21.108 | 23.134 | 4.749 | 19.32 | 13.09 |
| 82 | 216 | 84 | 26.417 | 27.656 | 7.524 | 26.15 | 17.56 |
| 168 | 243 | 84 | 18.675 | 19.982 | 4.843 | 20.34 | 16.41 |
| 6 | 6 | 84 | 0.717 | 3.214 | 0.735 | 6.15 | 48.28 |
| 112 | 138 | 84 | 20.117 | 23.134 | 7.68 | 25.03 | 22.37 |
| 232 | 260 | 84 | 16.242 | 17.911 | 6.844 | 22.61 | 25.48 |
| 168 | 60 | 84 | 15.075 | 17.122 | 3.338 | 14.54 | 12.94 |
| 158 | 168 | 84 | 28.083 | 29.264 | 10.07 | 31.82 | 21.45 |
| 188 | 37 | 84 | 22.883 | 23.963 | 4.189 | 18.2 | 10.93 |
| 162 | 35 | 84 | 45.825 | 47.668 | 12.779 | 42.58 | 17.2 |
| 226 | 116 | 84 | 28.1 | 30.829 | 8.599 | 29.34 | 17.7 |
| 215 | 50 | 84 | 45.242 | 47.186 | 15.216 | 52.08 | 20.75 |
| 24 | 128 | 84 | 18.417 | 20.155 | 6.145 | 20.93 | 19.35 |
| 261 | 34 | 84 | 21.217 | 20.89 | 3.642 | 16.23 | 11.04 |
| 33 | 129 | 84 | 21.292 | 23.63 | 8.608 | 27.2 | 24.22 |
| 87 | 11 | 84 | 24.842 | 26.343 | 10.786 | 32.38 | 25.82 |
| 56 | 148 | 84 | 24.858 | 25.088 | 9.495 | 51.28 | 25.23 |
| 164 | 29 | 84 | 44.6 | 45.925 | 18.551 | 54.23 | 25.4 |
| 35 | 89 | 84 | 22.308 | 23.193 | 4.029 | 17.72 | 10.84 |
| 188 | 232 | 84 | 24.342 | 25.585 | 6.002 | 22.27 | 14.39 |
| 24 | 25 | 84 | 36.333 | 37.818 | 10.99 | 36.18 | 18.36 |
| 196 | 68 | 84 | 26.467 | 29.478 | 8.685 | 47.29 | 19.77 |