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 |
|---|---|---|---|---|---|---|---|
| 225 | 193 | 15 | 27.5 | 28.874 | 5.712 | 21.91 | 12.14 |
| 260 | 10 | 15 | 30.283 | 31.77 | 10.154 | 33.46 | 22.54 |
| 35 | 133 | 15 | 24.117 | 26.312 | 4.726 | 19.87 | 11.09 |
| 49 | 222 | 15 | 39.133 | 38.334 | 6.479 | 27.06 | 10.35 |
| 217 | 138 | 15 | 15.45 | 19.364 | 8.577 | 25.9 | 31.41 |
| 222 | 242 | 15 | 40.05 | 40.672 | 18.409 | 50.44 | 27.59 |
| 169 | 49 | 15 | 55.067 | 52.181 | 17.187 | 51.09 | 21.22 |
| 258 | 134 | 15 | 15.65 | 15.637 | 3.182 | 13.67 | 12.65 |
| 89 | 197 | 15 | 36.817 | 41.524 | 12.325 | 39.77 | 18.65 |
| 117 | 130 | 15 | 40.217 | 40.818 | 12.756 | 40.8 | 19.09 |
| 79 | 86 | 15 | 53.4 | 62.594 | 23.197 | 70.83 | 25.56 |
| 218 | 140 | 15 | 55.25 | 56.572 | 18.307 | 55.53 | 20.29 |
| 177 | 42 | 15 | 45.7 | 49.187 | 17.778 | 53.61 | 23.41 |
| 144 | 9 | 15 | 41.217 | 42.63 | 14.514 | 44.7 | 21.3 |
| 152 | 208 | 15 | 25.833 | 27.239 | 9.932 | 30.8 | 24.53 |
| 70 | 222 | 15 | 43.85 | 45.023 | 12.727 | 40.84 | 17.87 |
| 226 | 119 | 15 | 26.433 | 28.101 | 9.521 | 31.1 | 22.26 |
| 177 | 106 | 15 | 21.5 | 24.359 | 5.147 | 19.66 | 13.13 |
| 106 | 149 | 15 | 35.217 | 33.344 | 11.341 | 35.8 | 20.95 |
| 74 | 131 | 15 | 30.317 | 32.203 | 14.009 | 38.92 | 28.18 |
| 169 | 248 | 15 | 12.3 | 18.624 | 4.042 | 16.73 | 14.96 |
| 152 | 146 | 15 | 28.567 | 27.136 | 7.339 | 25.4 | 16.96 |
| 129 | 218 | 15 | 30.15 | 37.572 | 13.433 | 41.1 | 25.3 |
| 89 | 7 | 15 | 45.85 | 44.608 | 14.169 | 43.04 | 20.98 |
| 22 | 150 | 15 | 17.217 | 16.974 | 5.418 | 20.28 | 20.67 |