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 |
|---|---|---|---|---|---|---|---|
| 74 | 60 | 296 | 17.975 | 20.101 | 4.972 | 18.62 | 17.09 |
| 75 | 241 | 296 | 29.783 | 31.548 | 7.946 | 28.15 | 18.06 |
| 113 | 133 | 296 | 26.133 | 28.289 | 8.64 | 28.1 | 19.49 |
| 247 | 244 | 296 | 13.125 | 14.404 | 2.335 | 12.14 | 10.72 |
| 90 | 247 | 295 | 30 | 34.647 | 9.855 | 33.19 | 19.54 |
| 236 | 189 | 295 | 39.333 | 41.026 | 10.82 | 36.56 | 16.81 |
| 162 | 135 | 295 | 29.367 | 31.756 | 11.077 | 34.44 | 23.01 |
| 233 | 225 | 295 | 32.15 | 33.826 | 7.75 | 28.28 | 14.51 |
| 142 | 188 | 295 | 45.25 | 47.495 | 11.523 | 40.11 | 15.25 |
| 95 | 134 | 295 | 8.3 | 9.814 | 1.746 | 9.24 | 11.16 |
| 106 | 14 | 295 | 14.417 | 15.426 | 4.717 | 16.78 | 20.1 |
| 12 | 4 | 294 | 12.375 | 12.928 | 3.537 | 13.22 | 17.29 |
| 215 | 162 | 294 | 35.825 | 37.355 | 13.338 | 51.98 | 23.37 |
| 237 | 225 | 294 | 38.683 | 40.529 | 8.714 | 32.49 | 13.49 |
| 68 | 248 | 294 | 29.5 | 32.719 | 12.486 | 38.05 | 25.13 |
| 50 | 17 | 294 | 37.533 | 39.416 | 8.927 | 32.47 | 14.28 |
| 145 | 87 | 294 | 21.117 | 22.7 | 6.88 | 43.97 | 19.68 |
| 75 | 33 | 294 | 29.492 | 31.145 | 9.626 | 30.89 | 20.01 |
| 143 | 12 | 294 | 25.15 | 25.829 | 5.801 | 22.07 | 14.35 |
| 233 | 195 | 294 | 25.075 | 27.602 | 8.705 | 28.08 | 20.25 |
| 40 | 246 | 294 | 23.125 | 24.689 | 6.263 | 22.6 | 16.15 |
| 181 | 138 | 294 | 30.183 | 32.524 | 11.865 | 36.39 | 23.91 |
| 100 | 167 | 294 | 31.283 | 34.425 | 9.901 | 32.96 | 18.44 |
| 66 | 158 | 294 | 19 | 20.687 | 3.951 | 16.91 | 12.03 |
| 238 | 216 | 294 | 48.083 | 50.12 | 17.82 | 53.05 | 22.97 |