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 |
|---|---|---|---|---|---|---|---|
| 26 | 55 | 39 | 24.967 | 25.676 | 6.732 | 23.74 | 16.04 |
| 34 | 148 | 39 | 8.467 | 9.315 | 2.289 | 9.72 | 16.16 |
| 231 | 6 | 39 | 27.083 | 29.201 | 12.605 | 37 | 28.43 |
| 26 | 72 | 39 | 25.967 | 28.947 | 4.71 | 20.75 | 10.37 |
| 40 | 145 | 39 | 23.317 | 24.999 | 7.356 | 24.5 | 18.5 |
| 35 | 41 | 39 | 50 | 55.172 | 18.918 | 55.7 | 22.39 |
| 162 | 58 | 39 | 43.717 | 43.86 | 12.413 | 39.76 | 19.42 |
| 97 | 69 | 39 | 43.95 | 48.202 | 14.37 | 45.45 | 20 |
| 50 | 16 | 39 | 38.25 | 41.107 | 17.975 | 52.03 | 28.01 |
| 161 | 128 | 39 | 29.533 | 32.182 | 10.417 | 33.87 | 20.79 |
| 248 | 212 | 39 | 4.733 | 5.684 | 0.924 | 7.15 | 10.92 |
| 114 | 108 | 39 | 32.733 | 35.129 | 14.667 | 43.5 | 25.93 |
| 136 | 78 | 39 | 17.667 | 19.055 | 2.441 | 13.42 | 7.93 |
| 76 | 14 | 39 | 33.017 | 35.607 | 16.107 | 45.99 | 27.98 |
| 95 | 218 | 39 | 26.717 | 27.294 | 6.636 | 23.43 | 15.96 |
| 235 | 174 | 39 | 17.317 | 18.541 | 4.576 | 17.44 | 16.36 |
| 47 | 143 | 39 | 36.25 | 37.647 | 9.032 | 32.21 | 14.83 |
| 13 | 85 | 39 | 30.783 | 30.619 | 8.024 | 27.99 | 16.33 |
| 205 | 28 | 39 | 14.233 | 17.385 | 3.94 | 15.31 | 14.27 |
| 236 | 210 | 39 | 56.083 | 57.961 | 21.84 | 64.28 | 23.59 |
| 179 | 166 | 39 | 32.333 | 29.863 | 5.685 | 23.03 | 12.11 |
| 74 | 85 | 39 | 57.867 | 57.806 | 16.29 | 53.39 | 18.14 |
| 247 | 231 | 39 | 42.633 | 45.873 | 12.755 | 40.26 | 17.35 |
| 166 | 242 | 39 | 29 | 30.766 | 9.681 | 30.91 | 20.84 |
| 159 | 242 | 39 | 26.333 | 27.623 | 6.382 | 23.57 | 14.5 |