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 |
|---|---|---|---|---|---|---|---|
| 7 | 16 | 59 | 23 | 24.898 | 11.803 | 34.34 | 29.84 |
| 143 | 185 | 59 | 29.683 | 30.886 | 12.785 | 37.35 | 26.03 |
| 168 | 254 | 59 | 20.917 | 23.129 | 8.553 | 27.02 | 24.4 |
| 17 | 234 | 59 | 35.733 | 34.985 | 6.148 | 25.78 | 11.37 |
| 229 | 252 | 59 | 32.25 | 34.077 | 12.975 | 39.18 | 24.74 |
| 61 | 79 | 59 | 27.733 | 30.053 | 5.837 | 23.76 | 12.44 |
| 166 | 60 | 59 | 23.683 | 26.689 | 6.923 | 24.41 | 17.85 |
| 50 | 32 | 59 | 31.833 | 31.682 | 14.093 | 40.39 | 28.1 |
| 61 | 107 | 59 | 33.167 | 34.149 | 7.322 | 26.9 | 13.81 |
| 70 | 146 | 59 | 17.1 | 19.198 | 4.55 | 17.27 | 15.2 |
| 212 | 250 | 59 | 8.333 | 9.77 | 1.619 | 8.58 | 11.22 |
| 243 | 237 | 59 | 30.133 | 30.105 | 7.875 | 27.56 | 17.49 |
| 157 | 198 | 59 | 10.033 | 11.005 | 1.947 | 11.03 | 11.23 |
| 61 | 100 | 59 | 54.133 | 52.412 | 9.854 | 38.9 | 12.35 |
| 249 | 10 | 59 | 44.317 | 47.316 | 16.662 | 50.55 | 23.45 |
| 127 | 235 | 59 | 13.8 | 13.226 | 2.123 | 11.03 | 10.09 |
| 22 | 11 | 59 | 8.467 | 8.887 | 1.144 | 7.69 | 8.56 |
| 246 | 213 | 59 | 31.167 | 37.008 | 12.988 | 40.27 | 23.92 |
| 87 | 191 | 59 | 54.7 | 58.233 | 22.421 | 66.84 | 24.09 |
| 231 | 124 | 59 | 46.017 | 52.992 | 18.61 | 55.15 | 23.9 |
| 48 | 180 | 59 | 42.9 | 46.761 | 13.618 | 44.65 | 18.37 |
| 241 | 136 | 59 | 7.8 | 8.43 | 1.236 | 7.45 | 9.82 |
| 143 | 21 | 59 | 64.2 | 63.366 | 15.917 | 53.58 | 16.13 |
| 72 | 97 | 59 | 28.933 | 30.801 | 5.43 | 21.55 | 10.89 |
| 24 | 179 | 59 | 24.85 | 27.205 | 6.278 | 22.7 | 15.09 |