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 |
|---|---|---|---|---|---|---|---|
| 260 | 98 | 9 | 23.15 | 21.883 | 9.856 | 29.28 | 31.75 |
| 150 | 170 | 9 | 51.517 | 50.143 | 18.009 | 54.56 | 21.11 |
| 157 | 258 | 9 | 21.833 | 23.211 | 4.839 | 19.17 | 13.24 |
| 11 | 39 | 9 | 21.433 | 27.543 | 10.066 | 30.9 | 25.64 |
| 194 | 13 | 9 | 29.017 | 29.459 | 11.042 | 45.22 | 23.68 |
| 74 | 19 | 9 | 41.833 | 40.198 | 16.802 | 47.52 | 26.58 |
| 130 | 180 | 9 | 16.85 | 17.743 | 4.498 | 16.78 | 15.69 |
| 92 | 80 | 9 | 30.6 | 28.163 | 8.783 | 28.78 | 19.27 |
| 20 | 259 | 9 | 18.55 | 16.537 | 4.639 | 17 | 17.94 |
| 195 | 36 | 9 | 28.95 | 29.876 | 7.846 | 26.57 | 16.08 |
| 215 | 146 | 9 | 29.367 | 35.715 | 13.019 | 43.89 | 24.77 |
| 147 | 25 | 9 | 54.517 | 50.724 | 13.964 | 46.61 | 17.71 |
| 119 | 35 | 9 | 38.233 | 39.265 | 20.53 | 57.5 | 32.07 |
| 242 | 238 | 9 | 45.433 | 41.6 | 11.738 | 38.39 | 17.66 |
| 168 | 134 | 9 | 29.183 | 30.922 | 12.148 | 34.59 | 24.87 |
| 92 | 163 | 9 | 35.283 | 37.961 | 14.69 | 41.97 | 23.61 |
| 28 | 152 | 9 | 29.667 | 35.137 | 13.566 | 51.94 | 25.14 |
| 254 | 161 | 9 | 47.883 | 53.644 | 13.384 | 45.18 | 16.36 |
| 211 | 221 | 9 | 26.067 | 28.443 | 13.16 | 38.11 | 29.31 |
| 92 | 258 | 9 | 25.4 | 24.822 | 8.386 | 26.82 | 21.93 |
| 168 | 149 | 9 | 68.95 | 64.524 | 22.528 | 68.22 | 21.6 |
| 263 | 150 | 9 | 50.033 | 49.607 | 22.34 | 62.59 | 28.4 |
| 247 | 249 | 9 | 42.083 | 40.189 | 10.779 | 36.33 | 17.08 |
| 171 | 196 | 9 | 23.467 | 25.215 | 7.074 | 24.28 | 16.98 |
| 212 | 263 | 9 | 41.433 | 41.722 | 7.422 | 30.28 | 11.14 |