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 |
|---|---|---|---|---|---|---|---|
| 129 | 29 | 3 | 32.933 | 39.806 | 23.053 | 62.83 | 37.04 |
| 210 | 168 | 3 | 54.183 | 56.083 | 21.48 | 64.33 | 23.15 |
| 120 | 167 | 3 | 23.95 | 23.417 | 4.787 | 19.33 | 13.35 |
| 167 | 89 | 3 | 71.067 | 62.656 | 19.67 | 57 | 20.42 |
| 51 | 31 | 3 | 18.217 | 21.144 | 4.657 | 19.11 | 15.19 |
| 65 | 115 | 3 | 27.45 | 27.394 | 13.897 | 39.5 | 31.19 |
| 150 | 228 | 3 | 45.967 | 42.367 | 14.11 | 42.19 | 27.42 |
| 93 | 15 | 3 | 19.067 | 18.917 | 6.187 | 21.17 | 20.11 |
| 72 | 94 | 3 | 48.033 | 49.961 | 21.237 | 59.97 | 25.65 |
| 129 | 3 | 3 | 32.25 | 35.228 | 12.3 | 36.34 | 21.24 |
| 141 | 204 | 3 | 52.9 | 48.661 | 30.86 | 82 | 39.07 |
| 71 | 196 | 3 | 37.683 | 38.789 | 9.26 | 33.5 | 14.49 |
| 218 | 160 | 3 | 28.95 | 28.311 | 11.383 | 31.07 | 24.3 |
| 96 | 130 | 3 | 18.5 | 23.406 | 5.377 | 20.33 | 15.58 |
| 33 | 169 | 3 | 42.433 | 46.367 | 16.987 | 50.67 | 25.84 |
| 37 | 185 | 3 | 61.633 | 57.528 | 19.563 | 59.95 | 20.73 |
| 52 | 109 | 3 | 35.317 | 35.844 | 15.09 | 44.5 | 25.39 |
| 165 | 151 | 3 | 56.9 | 58.017 | 16.45 | 53.53 | 18.02 |
| 258 | 228 | 3 | 52.45 | 52.222 | 13.52 | 46.5 | 16.23 |
| 227 | 53 | 3 | 42.117 | 42.078 | 18.327 | 47.96 | 26.38 |
| 141 | 44 | 3 | 43.967 | 43.622 | 32 | 83.33 | 44.2 |
| 32 | 142 | 3 | 51.733 | 55.533 | 17.45 | 54.11 | 20.47 |
| 195 | 167 | 3 | 50.333 | 54.978 | 15.58 | 49.5 | 17.67 |
| 94 | 88 | 3 | 30.833 | 33.067 | 15.11 | 42.83 | 28.24 |
| 258 | 158 | 3 | 35.95 | 36.333 | 11.873 | 47.67 | 19.81 |