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 |
|---|---|---|---|---|---|---|---|
| 92 | 218 | 3 | 18.6 | 23.2 | 9.54 | 30.5 | 29.82 |
| 200 | 79 | 3 | 43.567 | 42.644 | 14.933 | 45.67 | 21.34 |
| 77 | 237 | 3 | 75.483 | 73.028 | 18.08 | 62.83 | 16.14 |
| 67 | 195 | 3 | 22.433 | 23 | 6.647 | 22.83 | 18.92 |
| 9 | 226 | 3 | 32.05 | 29.856 | 9.753 | 29.15 | 20.06 |
| 63 | 254 | 3 | 55.083 | 55.256 | 20.04 | 59.5 | 23.18 |
| 151 | 86 | 3 | 57.667 | 74.2 | 27.007 | 86.83 | 25.2 |
| 98 | 170 | 3 | 46.767 | 44.622 | 13.13 | 41.33 | 18.32 |
| 94 | 134 | 3 | 42.967 | 40.789 | 15.397 | 43.46 | 22.94 |
| 70 | 248 | 3 | 33.367 | 42.7 | 8.687 | 29.67 | 14.99 |
| 182 | 7 | 3 | 31.033 | 26.689 | 8.11 | 27.33 | 19.72 |
| 178 | 232 | 3 | 29.1 | 30.656 | 9.473 | 30.5 | 18.73 |
| 179 | 219 | 3 | 23.217 | 23.2 | 14.65 | 40.17 | 37.95 |
| 35 | 183 | 3 | 38 | 39.061 | 18.297 | 52.92 | 28.89 |
| 213 | 77 | 3 | 28.25 | 29.578 | 16.767 | 46.33 | 34.43 |
| 15 | 88 | 3 | 51.05 | 49.806 | 21.8 | 61.67 | 26.61 |
| 78 | 33 | 3 | 48.583 | 52.067 | 15.857 | 48.34 | 18.47 |
| 58 | 185 | 3 | 13.817 | 13.272 | 3.383 | 13 | 15.89 |
| 131 | 193 | 3 | 39.65 | 38.667 | 11.717 | 37.33 | 18.49 |
| 157 | 123 | 3 | 36.733 | 38.094 | 14.2 | 41.56 | 23.02 |
| 147 | 148 | 3 | 34.167 | 34.917 | 11.637 | 36 | 20.81 |
| 216 | 112 | 3 | 36.017 | 33.478 | 14.913 | 41.83 | 26.79 |
| 238 | 117 | 3 | 59.867 | 60.356 | 30.067 | 81.83 | 30.25 |
| 160 | 201 | 3 | 40.5 | 39.006 | 11.253 | 37.33 | 17.44 |
| 216 | 5 | 3 | 71.3 | 68.678 | 30.663 | 125.5 | 30.39 |