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 |
|---|---|---|---|---|---|---|---|
| 91 | 114 | 5 | 47.7 | 48.043 | 12.182 | 42.4 | 15.53 |
| 133 | 112 | 5 | 24.05 | 25.163 | 9.394 | 29.6 | 26.14 |
| 40 | 124 | 5 | 42.017 | 42.54 | 20.28 | 57.6 | 31.51 |
| 128 | 200 | 5 | 13.217 | 16.547 | 3.71 | 15.3 | 15.08 |
| 14 | 50 | 5 | 31.883 | 34.923 | 8.84 | 31.6 | 16.31 |
| 111 | 227 | 5 | 6.067 | 6.69 | 1.524 | 7.2 | 14.62 |
| 3 | 230 | 5 | 55.75 | 54.67 | 17.122 | 53.6 | 18.94 |
| 165 | 234 | 5 | 52.8 | 52.093 | 11.078 | 39.84 | 13.16 |
| 208 | 126 | 5 | 20.433 | 23.267 | 6.406 | 21.8 | 18.22 |
| 41 | 171 | 5 | 30.283 | 32.043 | 12.016 | 36.9 | 22.58 |
| 98 | 90 | 5 | 31.083 | 38.033 | 13.16 | 40.6 | 22.44 |
| 145 | 155 | 5 | 47.033 | 62.017 | 18.588 | 56.75 | 22.01 |
| 198 | 218 | 5 | 27.55 | 27.473 | 8.67 | 27.13 | 19.08 |
| 56 | 37 | 5 | 28.2 | 27 | 9.278 | 29.5 | 22.39 |
| 249 | 8 | 5 | 37.233 | 35.38 | 7.134 | 27.4 | 12.43 |
| 42 | 34 | 5 | 35.833 | 38.78 | 13.256 | 40.9 | 21.39 |
| 228 | 127 | 5 | 45.417 | 58.473 | 19.054 | 58.4 | 23.52 |
| 255 | 203 | 5 | 47.217 | 48.757 | 18.696 | 54.27 | 23.48 |
| 165 | 190 | 5 | 24.183 | 27.073 | 3.782 | 19.2 | 9.57 |
| 180 | 89 | 5 | 35.967 | 38.957 | 11.856 | 38.5 | 18.23 |
| 208 | 41 | 5 | 21.55 | 23.583 | 9.47 | 28.02 | 25.15 |
| 64 | 132 | 5 | 19.4 | 21.23 | 12.872 | 35.1 | 37.37 |
| 70 | 127 | 5 | 32.267 | 30.49 | 11.366 | 34.39 | 24.33 |
| 175 | 71 | 5 | 40.833 | 40.41 | 15.48 | 46.9 | 23.09 |
| 139 | 157 | 5 | 52.7 | 52.107 | 12.656 | 39.62 | 15.02 |