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 |
|---|---|---|---|---|---|---|---|
| 130 | 249 | 82 | 35.383 | 37.747 | 14.614 | 51.98 | 24.93 |
| 62 | 35 | 82 | 14.558 | 14.092 | 2.38 | 11.55 | 10.64 |
| 7 | 216 | 82 | 29.167 | 31.859 | 12.36 | 37.12 | 25.38 |
| 28 | 244 | 82 | 39.492 | 41.286 | 15.49 | 50.63 | 26.34 |
| 142 | 248 | 82 | 28.7 | 30.342 | 10.5 | 32.7 | 23.05 |
| 166 | 66 | 82 | 37.042 | 38.044 | 10.947 | 36.08 | 18.27 |
| 90 | 20 | 82 | 40.667 | 41.397 | 13.287 | 41.98 | 20.61 |
| 166 | 12 | 82 | 32.358 | 33.893 | 8.995 | 30.93 | 17.11 |
| 107 | 242 | 82 | 36.667 | 40.433 | 13.004 | 40.41 | 21.27 |
| 21 | 22 | 82 | 8.8 | 9.705 | 1.418 | 8.39 | 9.48 |
| 142 | 185 | 82 | 37.192 | 40.094 | 13.496 | 41.72 | 22.35 |
| 259 | 259 | 82 | 3.708 | 6.541 | 1.533 | 11.59 | 27.55 |
| 113 | 92 | 82 | 38.375 | 40.728 | 13.199 | 41.85 | 20.79 |
| 25 | 41 | 82 | 43.908 | 43.724 | 11.654 | 38.98 | 17.45 |
| 234 | 32 | 82 | 36.75 | 38.422 | 14.14 | 42.54 | 23.53 |
| 69 | 48 | 82 | 24.492 | 28.412 | 9.706 | 31.49 | 22.43 |
| 209 | 165 | 82 | 30.275 | 32.994 | 9.26 | 30.93 | 18.37 |
| 68 | 250 | 82 | 31.95 | 34.921 | 14.207 | 41.94 | 26.39 |
| 256 | 34 | 82 | 9.975 | 11.221 | 1.762 | 9.38 | 10.38 |
| 236 | 72 | 82 | 50.683 | 57.507 | 14.605 | 48.97 | 16.34 |
| 215 | 137 | 81 | 29.8 | 34.238 | 13.339 | 49.15 | 25.95 |
| 229 | 167 | 81 | 23.483 | 24.949 | 7.392 | 24.9 | 19.12 |
| 129 | 90 | 81 | 23.767 | 28.768 | 7.594 | 26.19 | 17.28 |
| 137 | 136 | 81 | 25.95 | 29.832 | 11.016 | 33.63 | 25.33 |
| 249 | 126 | 81 | 30.833 | 33.232 | 11.353 | 35.49 | 21.52 |