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 |
|---|---|---|---|---|---|---|---|
| 209 | 226 | 152 | 26.442 | 27.921 | 8.447 | 28.17 | 19.54 |
| 61 | 74 | 152 | 47.658 | 49.97 | 14.52 | 47.11 | 18.56 |
| 140 | 212 | 152 | 24.408 | 28.187 | 7.844 | 26.76 | 19.23 |
| 181 | 4 | 152 | 18.442 | 19.551 | 5.004 | 18.38 | 16.19 |
| 260 | 263 | 152 | 19.983 | 22.342 | 5.389 | 19.86 | 15.75 |
| 124 | 124 | 152 | 4.15 | 6.001 | 1.208 | 14.93 | 47.72 |
| 4 | 223 | 152 | 25.625 | 26.947 | 8.693 | 28.07 | 20.73 |
| 215 | 239 | 152 | 42.792 | 45.394 | 16.526 | 51.94 | 24.17 |
| 260 | 231 | 152 | 28.617 | 30.955 | 8.571 | 38.25 | 18.45 |
| 234 | 213 | 152 | 32.108 | 35.348 | 11.763 | 36.76 | 21.82 |
| 28 | 75 | 152 | 38.317 | 38.117 | 13.85 | 47.15 | 25.35 |
| 89 | 72 | 152 | 15.275 | 16.488 | 2.748 | 13.01 | 10.62 |
| 163 | 227 | 152 | 41.142 | 42.061 | 12.665 | 40.61 | 19.44 |
| 193 | 100 | 152 | 23.8 | 26.323 | 4.073 | 19.12 | 10.61 |
| 48 | 31 | 152 | 30.775 | 31.985 | 13.262 | 39.59 | 26.22 |
| 246 | 202 | 152 | 28.342 | 30.676 | 6.338 | 24.24 | 13.32 |
| 236 | 196 | 152 | 34.317 | 35.86 | 9.095 | 31.66 | 16.78 |
| 146 | 114 | 152 | 21.533 | 23.61 | 5.404 | 20.19 | 14.84 |
| 148 | 193 | 152 | 20.5 | 23.104 | 6.52 | 22.49 | 18.03 |
| 236 | 182 | 152 | 24.167 | 27.264 | 8.526 | 27.75 | 20.93 |
| 188 | 39 | 152 | 21.225 | 21.508 | 3.592 | 16.27 | 10.31 |
| 233 | 28 | 152 | 29.375 | 31.783 | 12.065 | 36.59 | 25.21 |
| 52 | 190 | 152 | 16.233 | 16.963 | 2.772 | 13.34 | 10.52 |
| 162 | 18 | 152 | 30.925 | 33.792 | 11.782 | 36.6 | 22.61 |
| 239 | 18 | 152 | 28 | 30.586 | 10.085 | 31.89 | 21.52 |