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 |
|---|---|---|---|---|---|---|---|
| 45 | 123 | 33 | 28.867 | 31.818 | 10.756 | 33.98 | 21.39 |
| 25 | 136 | 33 | 68.333 | 71.397 | 16.767 | 57.73 | 15.08 |
| 43 | 254 | 33 | 33.783 | 36.069 | 12.276 | 38.36 | 22.02 |
| 243 | 167 | 33 | 18.067 | 19.535 | 3.72 | 15.88 | 12.63 |
| 232 | 173 | 33 | 23 | 26.15 | 9.626 | 30.23 | 24.41 |
| 195 | 41 | 33 | 45.75 | 48.758 | 14.835 | 46.5 | 19.52 |
| 14 | 140 | 33 | 39.917 | 41.63 | 13.651 | 41.38 | 20.83 |
| 228 | 138 | 33 | 35.067 | 35.756 | 13.925 | 41.11 | 25.5 |
| 188 | 256 | 33 | 26.283 | 24.826 | 4.539 | 19.27 | 12.04 |
| 255 | 35 | 33 | 30.483 | 31.719 | 7.097 | 25.79 | 13.4 |
| 218 | 28 | 33 | 19.75 | 20.92 | 4.25 | 17.39 | 13.09 |
| 95 | 171 | 33 | 22.15 | 21.393 | 6.092 | 21.55 | 18.34 |
| 228 | 48 | 33 | 37.567 | 38.477 | 8.913 | 30.75 | 14.56 |
| 119 | 49 | 33 | 39.633 | 44.237 | 15.387 | 46.21 | 23.66 |
| 107 | 221 | 33 | 42.067 | 42.782 | 17.124 | 50.42 | 24.75 |
| 259 | 3 | 33 | 16.733 | 17.808 | 3.699 | 15.73 | 12.97 |
| 22 | 165 | 33 | 17.7 | 18.9 | 2.895 | 14.33 | 9.59 |
| 238 | 227 | 33 | 37.3 | 43.978 | 13.89 | 44 | 20.61 |
| 230 | 206 | 33 | 48.083 | 52.493 | 18.985 | 57.32 | 22.78 |
| 61 | 195 | 33 | 21.067 | 22.333 | 4.523 | 17.79 | 12.84 |
| 239 | 1 | 33 | 44.767 | 49.581 | 20.026 | 74.77 | 27.18 |
| 134 | 93 | 33 | 12.033 | 13.407 | 4.904 | 21.21 | 23.4 |
| 80 | 67 | 33 | 20.333 | 23.271 | 10.276 | 30.67 | 28.85 |
| 259 | 213 | 33 | 16.733 | 18.839 | 7.239 | 22.87 | 24.33 |
| 179 | 160 | 33 | 20.15 | 21.304 | 6.67 | 22.06 | 19.61 |