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 |
|---|---|---|---|---|---|---|---|
| 8 | 262 | 37 | 10.15 | 12.012 | 4.731 | 52 | 26.23 |
| 137 | 156 | 37 | 42 | 45.409 | 21.354 | 61.19 | 29.62 |
| 106 | 225 | 37 | 23.05 | 23.972 | 4.133 | 18.16 | 11.17 |
| 146 | 192 | 37 | 22.517 | 25.804 | 8.912 | 28.66 | 22.32 |
| 254 | 78 | 37 | 19.1 | 20.148 | 4.326 | 17.64 | 14.39 |
| 225 | 189 | 37 | 16.95 | 18.624 | 2.982 | 14.22 | 10.23 |
| 219 | 236 | 37 | 40.917 | 44.087 | 17.152 | 52.8 | 25.78 |
| 89 | 129 | 37 | 34.8 | 34.873 | 12.577 | 36.83 | 22.35 |
| 67 | 228 | 37 | 16.717 | 16.395 | 3.307 | 14.1 | 13.06 |
| 257 | 230 | 37 | 24.267 | 27.603 | 9.541 | 29.92 | 22.21 |
| 263 | 190 | 37 | 32.533 | 34.473 | 11.127 | 35.54 | 20.26 |
| 7 | 15 | 37 | 20.683 | 21.291 | 9.869 | 29.17 | 29.51 |
| 230 | 139 | 37 | 47.583 | 50.008 | 19.853 | 57.81 | 25.32 |
| 83 | 142 | 37 | 25.817 | 26.947 | 6.158 | 23.11 | 14.31 |
| 45 | 157 | 37 | 28.117 | 29.842 | 7.881 | 27.27 | 17.84 |
| 89 | 138 | 37 | 38.583 | 40.917 | 16.046 | 47.09 | 25.63 |
| 39 | 230 | 37 | 51.15 | 56.195 | 17.187 | 54.17 | 19.04 |
| 229 | 63 | 37 | 40.533 | 41.119 | 11.454 | 38.21 | 17.34 |
| 233 | 98 | 37 | 30.5 | 33.006 | 12.523 | 37.2 | 24.68 |
| 7 | 33 | 37 | 30.65 | 31.368 | 8.798 | 29.27 | 18.46 |
| 8 | 145 | 37 | 9.967 | 11.581 | 2.665 | 11.03 | 14.91 |
| 163 | 240 | 37 | 28.85 | 30.051 | 12.929 | 38.15 | 27.12 |
| 195 | 257 | 37 | 11.15 | 11.515 | 3.564 | 12.86 | 22.23 |
| 256 | 166 | 37 | 35.617 | 36.477 | 10.544 | 34.96 | 18.25 |
| 145 | 24 | 37 | 21.933 | 24.018 | 5.805 | 21.03 | 15.61 |