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 |
|---|---|---|---|---|---|---|---|
| 200 | 140 | 31 | 42.433 | 39.939 | 12.406 | 39.44 | 20.03 |
| 91 | 66 | 31 | 42.883 | 43.209 | 9.257 | 34.44 | 13.16 |
| 150 | 149 | 31 | 13.683 | 15.46 | 2.489 | 12.45 | 10.43 |
| 144 | 60 | 31 | 24.85 | 30.11 | 12.229 | 36.69 | 26.08 |
| 102 | 36 | 31 | 14.083 | 14.792 | 2.72 | 12.47 | 11.11 |
| 3 | 233 | 31 | 59.333 | 58.011 | 14.211 | 47.29 | 16.02 |
| 254 | 169 | 31 | 23.65 | 26.719 | 5.559 | 21.58 | 13.71 |
| 60 | 169 | 31 | 15.667 | 16.38 | 2.162 | 12.08 | 8.59 |
| 197 | 117 | 31 | 37.917 | 39.604 | 12.148 | 38.97 | 18.92 |
| 257 | 87 | 31 | 22 | 22.986 | 6.167 | 21.55 | 16.85 |
| 164 | 38 | 31 | 42.583 | 47.198 | 18.775 | 55.97 | 26.4 |
| 33 | 123 | 31 | 30 | 30.73 | 8.286 | 29.07 | 16.66 |
| 158 | 29 | 31 | 36.767 | 39.935 | 16.541 | 47.13 | 26.51 |
| 177 | 137 | 31 | 36.383 | 42.416 | 9.438 | 33.04 | 14.83 |
| 39 | 26 | 31 | 30.517 | 31.916 | 7.305 | 25.96 | 13.78 |
| 24 | 60 | 31 | 23.067 | 26.17 | 7.931 | 26.24 | 19.99 |
| 41 | 227 | 31 | 36.317 | 38.404 | 16.264 | 47.45 | 26.5 |
| 229 | 9 | 31 | 31.667 | 34.846 | 13.289 | 40.18 | 24.67 |
| 152 | 171 | 31 | 32.967 | 33.949 | 11.734 | 37.18 | 21.51 |
| 25 | 69 | 31 | 52.817 | 54.017 | 13.565 | 44.92 | 16.57 |
| 122 | 230 | 31 | 54.817 | 52.144 | 16.134 | 48.05 | 25.68 |
| 211 | 76 | 31 | 42.183 | 45.058 | 9.864 | 36.61 | 13.57 |
| 149 | 55 | 31 | 20.683 | 20.328 | 4.077 | 16.79 | 12.24 |
| 133 | 178 | 31 | 8.183 | 9.055 | 1.797 | 8.82 | 13.06 |
| 51 | 136 | 31 | 30.833 | 32.83 | 7.011 | 26.61 | 14.01 |