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 |
|---|---|---|---|---|---|---|---|
| 82 | 33 | 4 | 36.625 | 35.237 | 8.607 | 29.12 | 16.03 |
| 125 | 153 | 4 | 33.275 | 35.108 | 12.973 | 40.25 | 22.46 |
| 85 | 108 | 4 | 30.558 | 30.558 | 5.39 | 23.38 | 10.78 |
| 180 | 234 | 4 | 31.3 | 33.471 | 12.33 | 45.5 | 22.69 |
| 28 | 208 | 4 | 17.675 | 22.458 | 12.892 | 43.75 | 42.56 |
| 63 | 134 | 4 | 17.075 | 16.358 | 5.207 | 17.71 | 19.31 |
| 253 | 41 | 4 | 32.175 | 33.258 | 9.695 | 41.88 | 19.83 |
| 41 | 156 | 4 | 66.308 | 69.438 | 26.977 | 80.5 | 24.92 |
| 135 | 38 | 4 | 34.475 | 35.983 | 13.395 | 41 | 23.1 |
| 225 | 179 | 4 | 30.558 | 32.092 | 9.815 | 32.25 | 19.73 |
| 31 | 263 | 4 | 36.083 | 37.871 | 9.39 | 32.5 | 15.24 |
| 228 | 208 | 4 | 65.542 | 63.754 | 23.03 | 66.05 | 22.97 |
| 76 | 134 | 4 | 18.4 | 19.167 | 6.232 | 21 | 21.95 |
| 80 | 55 | 4 | 59.433 | 58.754 | 16.485 | 54.5 | 20.62 |
| 212 | 238 | 4 | 31.6 | 31.192 | 10.377 | 33.75 | 21.76 |
| 20 | 164 | 4 | 43.133 | 43.038 | 12.42 | 40.12 | 18.71 |
| 77 | 148 | 4 | 35.5 | 44.287 | 11.222 | 33.6 | 16.82 |
| 181 | 121 | 4 | 38.592 | 36.296 | 13.138 | 40 | 22.78 |
| 49 | 174 | 4 | 42.35 | 42.763 | 18.848 | 54.88 | 27.54 |
| 140 | 99 | 4 | 58.833 | 59.854 | 27.715 | 78.88 | 28.76 |
| 260 | 203 | 4 | 35.067 | 49.304 | 19.207 | 58.12 | 28.22 |
| 42 | 196 | 4 | 35.05 | 33.387 | 11.387 | 35.75 | 21.2 |
| 173 | 134 | 4 | 14.542 | 14.504 | 6.008 | 18.75 | 25.91 |
| 70 | 247 | 4 | 16.9 | 23.671 | 8.985 | 27.25 | 25.27 |
| 202 | 152 | 4 | 28.408 | 35.529 | 8.732 | 30.62 | 16.74 |