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 |
|---|---|---|---|---|---|---|---|
| 10 | 200 | 2 | 36.583 | 36.583 | 21.88 | 58.25 | 36.44 |
| 147 | 125 | 2 | 46.633 | 46.633 | 9.405 | 35.75 | 11.24 |
| 222 | 45 | 2 | 58.758 | 58.758 | 16.475 | 48.9 | 18.68 |
| 198 | 67 | 2 | 53.558 | 53.558 | 12.96 | 41.27 | 14.56 |
| 128 | 230 | 2 | 21.533 | 21.533 | 9.975 | 30 | 28.36 |
| 193 | 29 | 2 | 60.233 | 60.233 | 19.175 | 57.5 | 20.59 |
| 154 | 37 | 2 | 30.683 | 30.683 | 7.7 | 27.5 | 15.02 |
| 149 | 85 | 2 | 20.2 | 20.2 | 3.375 | 15.25 | 10.13 |
| 129 | 139 | 2 | 28.342 | 28.342 | 13.55 | 38 | 31.12 |
| 247 | 16 | 2 | 39.292 | 39.292 | 14.06 | 46 | 21.31 |
| 14 | 15 | 2 | 67.45 | 67.45 | 30.02 | 82 | 29.63 |
| 80 | 200 | 2 | 51.325 | 51.325 | 19.285 | 58.5 | 23.39 |
| 224 | 149 | 2 | 35.958 | 35.958 | 16.54 | 46.5 | 27.5 |
| 181 | 120 | 2 | 30.083 | 30.083 | 15.85 | 44.5 | 31.65 |
| 206 | 245 | 2 | 41.1 | 41.1 | 11.625 | 41 | 21.04 |
| 223 | 219 | 2 | 12.85 | 12.85 | 7.61 | 21.5 | 34.08 |
| 258 | 239 | 2 | 43.292 | 43.292 | 13.185 | 47.75 | 18.28 |
| 10 | 29 | 2 | 27.683 | 27.683 | 13.715 | 40 | 29.74 |
| 191 | 31 | 2 | 42.067 | 42.067 | 18.025 | 52.25 | 25.93 |
| 57 | 62 | 2 | 29.325 | 29.325 | 10.615 | 32.5 | 22.05 |
| 220 | 205 | 2 | 78.867 | 78.867 | 22.79 | 60.75 | 17.85 |
| 191 | 163 | 2 | 45.192 | 45.192 | 19.935 | 57.83 | 29.08 |
| 86 | 149 | 2 | 44.775 | 44.775 | 13.905 | 44.5 | 18.66 |
| 86 | 22 | 2 | 41.458 | 41.458 | 17.1 | 49.75 | 24.84 |
| 74 | 165 | 2 | 63.583 | 63.583 | 17.39 | 57.75 | 17.13 |