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 |
|---|---|---|---|---|---|---|---|
| 166 | 259 | 24 | 32.108 | 33.422 | 12.421 | 38.26 | 24.2 |
| 77 | 49 | 24 | 28.125 | 29.418 | 5.082 | 21.85 | 10.58 |
| 209 | 92 | 24 | 39.233 | 42.6 | 15.402 | 46.75 | 23.04 |
| 147 | 213 | 24 | 11.942 | 12.631 | 2.644 | 11.46 | 12.78 |
| 80 | 71 | 24 | 27.1 | 30.145 | 5.999 | 23.87 | 12.99 |
| 162 | 5 | 24 | 50.35 | 56.161 | 27.968 | 77.52 | 31.58 |
| 183 | 74 | 24 | 29.817 | 30.665 | 8.19 | 26.9 | 18.52 |
| 142 | 175 | 24 | 43.558 | 45.25 | 16.973 | 50.99 | 24.06 |
| 50 | 240 | 24 | 24.592 | 25.058 | 13.231 | 37.58 | 33.57 |
| 119 | 152 | 24 | 16.608 | 18.696 | 2.84 | 14.14 | 9.69 |
| 229 | 205 | 24 | 38.625 | 48.199 | 15.472 | 47.11 | 21.85 |
| 159 | 51 | 24 | 26.692 | 25.653 | 9.366 | 29.35 | 22.93 |
| 67 | 227 | 24 | 12.5 | 11.285 | 1.648 | 10.03 | 9.18 |
| 161 | 203 | 24 | 43.183 | 46.915 | 19.063 | 55.23 | 26.34 |
| 29 | 26 | 24 | 23.075 | 24.378 | 5.157 | 20.36 | 12.98 |
| 241 | 153 | 24 | 7.142 | 10.71 | 1.541 | 8.87 | 9.23 |
| 217 | 165 | 24 | 38.992 | 40.397 | 8.753 | 32.91 | 14.24 |
| 232 | 71 | 24 | 36.033 | 37.137 | 7.692 | 28.51 | 12.74 |
| 162 | 77 | 24 | 47.925 | 50.524 | 13.506 | 44.88 | 16.81 |
| 76 | 148 | 24 | 50.067 | 49.762 | 10.334 | 47.26 | 12.36 |
| 182 | 208 | 24 | 12.4 | 13.103 | 2.952 | 12.23 | 14.58 |
| 179 | 151 | 24 | 22.383 | 25.261 | 6.648 | 24.67 | 17.07 |
| 70 | 68 | 24 | 35.217 | 37.512 | 10.97 | 35.89 | 18.96 |
| 142 | 11 | 24 | 49.725 | 49.845 | 15.558 | 49.52 | 19.37 |
| 193 | 159 | 24 | 22.233 | 25.706 | 7.668 | 26 | 20.41 |