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 |
|---|---|---|---|---|---|---|---|
| 136 | 213 | 28 | 23.075 | 26.776 | 6.441 | 22.97 | 16.02 |
| 45 | 77 | 28 | 57.908 | 55.372 | 11.288 | 40.55 | 18.56 |
| 38 | 218 | 28 | 12.85 | 13.61 | 4.191 | 14.92 | 19.77 |
| 224 | 133 | 28 | 26.033 | 28.817 | 9.74 | 30.71 | 22.17 |
| 49 | 149 | 28 | 29.458 | 31.457 | 7.774 | 27.12 | 14.69 |
| 68 | 19 | 28 | 47.858 | 50.273 | 18.19 | 54.77 | 23.37 |
| 82 | 124 | 28 | 22.142 | 26.026 | 6.405 | 22.64 | 17.17 |
| 37 | 155 | 28 | 20.342 | 24.86 | 7.954 | 26.55 | 21.55 |
| 114 | 128 | 28 | 33.708 | 35.737 | 12.715 | 39.43 | 22.21 |
| 189 | 26 | 28 | 17.7 | 18.771 | 4.107 | 16.05 | 13.41 |
| 134 | 129 | 28 | 22.075 | 23.489 | 6.909 | 23.74 | 18.83 |
| 185 | 136 | 28 | 19.233 | 20.906 | 3.16 | 15.54 | 9.96 |
| 17 | 63 | 28 | 23.992 | 26.889 | 4.737 | 20.07 | 11.3 |
| 88 | 115 | 28 | 26.267 | 27.707 | 13.43 | 37.84 | 30.32 |
| 229 | 128 | 28 | 26.3 | 30.522 | 9.821 | 32.02 | 21.26 |
| 171 | 231 | 28 | 54.558 | 55.286 | 16.159 | 51.83 | 18.61 |
| 10 | 203 | 28 | 15.217 | 16.574 | 4.616 | 16.95 | 18.29 |
| 185 | 18 | 28 | 16.342 | 18.225 | 2.269 | 13.41 | 9.62 |
| 218 | 86 | 28 | 26.883 | 26.856 | 6.478 | 23.05 | 14.92 |
| 47 | 174 | 28 | 18.375 | 19.624 | 3.686 | 15.78 | 11.89 |
| 257 | 162 | 28 | 24.617 | 29.905 | 10.978 | 33.7 | 25.1 |
| 69 | 32 | 28 | 20.358 | 21.841 | 5.732 | 20.48 | 16.39 |
| 28 | 127 | 28 | 27.883 | 31.811 | 17.265 | 53.27 | 34.78 |
| 216 | 83 | 28 | 31.308 | 31.724 | 10.045 | 31.76 | 21.48 |
| 238 | 177 | 28 | 52.433 | 56.454 | 16.775 | 54.27 | 19.95 |