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 |
|---|---|---|---|---|---|---|---|
| 250 | 151 | 3 | 42.9 | 39.167 | 10.633 | 35.17 | 17.57 |
| 11 | 206 | 3 | 14.583 | 16.828 | 9.243 | 26.5 | 33.09 |
| 26 | 218 | 3 | 42.217 | 47.722 | 22.527 | 64.33 | 30.09 |
| 247 | 196 | 3 | 24.733 | 27.461 | 12.123 | 35.5 | 26.85 |
| 9 | 203 | 3 | 23.483 | 23.039 | 10.097 | 29.49 | 26.44 |
| 207 | 262 | 3 | 28.633 | 27.867 | 7.527 | 36.83 | 16.2 |
| 16 | 75 | 3 | 47.867 | 45.894 | 15.247 | 46.33 | 20.17 |
| 242 | 179 | 3 | 32.117 | 30.25 | 10.813 | 33.67 | 21.76 |
| 145 | 96 | 3 | 34.35 | 28.206 | 7.357 | 26 | 18.14 |
| 225 | 134 | 3 | 27.667 | 36.344 | 9.537 | 33.33 | 16.7 |
| 117 | 91 | 3 | 33.95 | 40.067 | 14.13 | 41.76 | 21.06 |
| 241 | 170 | 3 | 51.05 | 50.583 | 12.827 | 43 | 15.22 |
| 212 | 163 | 3 | 42.917 | 42.661 | 10.407 | 35.09 | 16.43 |
| 178 | 48 | 3 | 45.833 | 51.6 | 12.033 | 43.98 | 15.3 |
| 217 | 67 | 3 | 22.933 | 22.906 | 10.353 | 30.83 | 27.19 |
| 74 | 96 | 3 | 34.317 | 39.206 | 14.593 | 44.83 | 24.68 |
| 218 | 88 | 3 | 45.017 | 44.544 | 18.703 | 52 | 25.14 |
| 220 | 129 | 3 | 29.483 | 27.044 | 11.987 | 35.33 | 27.92 |
| 216 | 190 | 3 | 37.333 | 44.806 | 10.317 | 37.5 | 13.77 |
| 23 | 15 | 3 | 71.167 | 70.55 | 40.037 | 107 | 34.45 |
| 63 | 4 | 3 | 53.95 | 54.906 | 14.203 | 49 | 16.98 |
| 128 | 48 | 3 | 16.883 | 19.35 | 7.19 | 23.67 | 22.06 |
| 131 | 142 | 3 | 58.017 | 54.05 | 16.433 | 52.56 | 19.23 |
| 3 | 116 | 3 | 33.283 | 37.867 | 10.147 | 34.55 | 17.36 |
| 183 | 141 | 3 | 46.883 | 50.789 | 11.603 | 38.72 | 16.15 |