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 |
|---|---|---|---|---|---|---|---|
| 32 | 173 | 5 | 50.7 | 52.563 | 11.92 | 42.8 | 14.41 |
| 108 | 85 | 5 | 37.017 | 37.46 | 5.948 | 25.63 | 9.72 |
| 259 | 107 | 5 | 48.867 | 45.633 | 16.428 | 48.2 | 23.47 |
| 209 | 53 | 5 | 43 | 39.5 | 17.312 | 49 | 26.84 |
| 94 | 238 | 5 | 35.367 | 35.553 | 8.766 | 32.8 | 15.74 |
| 157 | 262 | 5 | 25.6 | 30.277 | 8.626 | 39.1 | 19.54 |
| 102 | 222 | 5 | 19.85 | 22.03 | 5.582 | 19.6 | 15.38 |
| 117 | 219 | 5 | 23.567 | 25.293 | 7.498 | 24.73 | 17.77 |
| 226 | 81 | 5 | 39.933 | 46.067 | 15.118 | 46.7 | 22.34 |
| 63 | 78 | 5 | 50.667 | 52.103 | 25.294 | 77.1 | 32.51 |
| 116 | 34 | 5 | 41.833 | 41.213 | 12.43 | 39.5 | 19.01 |
| 250 | 161 | 5 | 39.333 | 41.08 | 11.814 | 37.41 | 17.54 |
| 213 | 209 | 5 | 53.017 | 54.703 | 14.62 | 44.03 | 16.68 |
| 182 | 35 | 5 | 38.833 | 39.853 | 16.958 | 47.6 | 25.62 |
| 205 | 235 | 5 | 49.6 | 47.343 | 21.524 | 60.75 | 28.47 |
| 126 | 61 | 5 | 46.233 | 46 | 17.418 | 51.9 | 23.5 |
| 53 | 9 | 5 | 26.317 | 25.077 | 7.15 | 23.78 | 17.71 |
| 185 | 107 | 5 | 62.183 | 61.057 | 14.752 | 47.55 | 14.74 |
| 135 | 181 | 5 | 44.367 | 56.93 | 15.79 | 51.4 | 17.69 |
| 74 | 73 | 5 | 24.783 | 28.477 | 11.85 | 34.5 | 25.47 |
| 197 | 125 | 5 | 43.05 | 48.43 | 17.03 | 49.5 | 22.57 |
| 63 | 232 | 5 | 40.7 | 44.787 | 11.038 | 40.11 | 14.69 |
| 244 | 62 | 5 | 49.4 | 49.757 | 18.848 | 56.4 | 23.57 |
| 39 | 1 | 5 | 41.433 | 41.003 | 27.706 | 144 | 42.71 |
| 29 | 227 | 5 | 20.85 | 23.147 | 7.668 | 25.1 | 20.87 |