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 |
|---|---|---|---|---|---|---|---|
| 38 | 132 | 34 | 14.817 | 17.422 | 6.748 | 22.8 | 27.56 |
| 147 | 69 | 34 | 12.417 | 13.233 | 2.054 | 10.57 | 9.52 |
| 213 | 162 | 34 | 32.717 | 34.353 | 10.194 | 31.51 | 18.59 |
| 190 | 62 | 34 | 7.142 | 8.393 | 1.322 | 7.18 | 11.09 |
| 40 | 11 | 34 | 17.167 | 18.147 | 7.195 | 22.71 | 24.4 |
| 238 | 121 | 34 | 36.542 | 39.694 | 15.018 | 45.26 | 24.43 |
| 63 | 258 | 34 | 10.25 | 9.57 | 1.681 | 8.44 | 11.11 |
| 193 | 4 | 34 | 20.125 | 19.911 | 5.478 | 19.46 | 17.69 |
| 79 | 205 | 34 | 43.817 | 49.513 | 17.278 | 51.02 | 22.96 |
| 62 | 36 | 34 | 21.008 | 23.515 | 4.18 | 18.07 | 11.86 |
| 166 | 240 | 34 | 23.633 | 25.333 | 9.791 | 30.69 | 24.36 |
| 88 | 185 | 34 | 40.792 | 43.974 | 16.578 | 48.4 | 24.44 |
| 107 | 139 | 34 | 77.575 | 73.268 | 18.364 | 60.14 | 17.02 |
| 14 | 170 | 34 | 36.308 | 38.258 | 12.465 | 38.13 | 19.99 |
| 193 | 152 | 34 | 24.642 | 26.726 | 7.256 | 24.49 | 17.15 |
| 25 | 21 | 34 | 27.508 | 28.838 | 8.439 | 28.41 | 18.71 |
| 89 | 162 | 34 | 37.917 | 40.674 | 12.115 | 38.74 | 19.49 |
| 129 | 102 | 34 | 21.892 | 22.957 | 6.699 | 23.03 | 18.12 |
| 152 | 129 | 34 | 28.117 | 31.323 | 8.347 | 29.03 | 16.82 |
| 234 | 31 | 34 | 37.958 | 39.687 | 13.475 | 41.65 | 22.37 |
| 219 | 158 | 34 | 55.15 | 55.96 | 18.353 | 52.75 | 21.72 |
| 14 | 150 | 34 | 20.608 | 23.812 | 7.73 | 25.77 | 21.19 |
| 138 | 44 | 34 | 69.9 | 78.591 | 34.914 | 96.28 | 29.27 |
| 235 | 20 | 34 | 15.675 | 16.781 | 2.475 | 12.75 | 9.23 |
| 12 | 151 | 34 | 29.308 | 30.969 | 8.344 | 28.94 | 17.36 |