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 |
|---|---|---|---|---|---|---|---|
| 247 | 82 | 6 | 32.333 | 36.358 | 9.395 | 33.75 | 17.38 |
| 173 | 37 | 6 | 24.067 | 27.253 | 8.888 | 28.83 | 22.08 |
| 216 | 19 | 6 | 34.292 | 29.544 | 11.932 | 40.08 | 27.19 |
| 188 | 160 | 6 | 39.8 | 40.939 | 9.295 | 34.5 | 15.38 |
| 198 | 141 | 6 | 39.433 | 40.214 | 9.497 | 34.17 | 15.14 |
| 258 | 56 | 6 | 16.692 | 18.05 | 5.103 | 17.42 | 17.5 |
| 178 | 86 | 6 | 50.717 | 53.836 | 19.223 | 58.87 | 21.9 |
| 14 | 258 | 6 | 42.342 | 49.358 | 18.302 | 53.34 | 25.59 |
| 248 | 263 | 6 | 36.792 | 38.583 | 7.693 | 29.08 | 12.58 |
| 98 | 15 | 6 | 16.883 | 16.808 | 4.168 | 16.17 | 15.74 |
| 148 | 57 | 6 | 35.975 | 36.314 | 12.073 | 37.58 | 20.12 |
| 119 | 7 | 6 | 22.192 | 21.047 | 8.172 | 25.33 | 23.61 |
| 225 | 95 | 6 | 28.567 | 33.058 | 7.562 | 27.16 | 14.71 |
| 117 | 197 | 6 | 42.017 | 42.194 | 11.18 | 35.51 | 16.41 |
| 36 | 88 | 6 | 23.617 | 24.725 | 6.943 | 23.58 | 17.67 |
| 171 | 44 | 6 | 69.867 | 76.892 | 52.537 | 139.83 | 42.05 |
| 94 | 32 | 6 | 15.642 | 16.664 | 2.78 | 13.17 | 11.19 |
| 37 | 262 | 6 | 26.733 | 25.933 | 8.658 | 27.92 | 19.32 |
| 180 | 134 | 6 | 22.567 | 29.35 | 4.775 | 22.25 | 11.16 |
| 188 | 129 | 6 | 33.858 | 35.489 | 10.465 | 33.92 | 20.15 |
| 235 | 45 | 6 | 47.242 | 52.058 | 13.398 | 45.92 | 18.94 |
| 56 | 63 | 6 | 28.167 | 26.883 | 7.28 | 24.09 | 16.81 |
| 202 | 232 | 6 | 19.55 | 19.856 | 6.7 | 21.5 | 21.37 |
| 223 | 106 | 6 | 34.433 | 38.8 | 11.217 | 36.17 | 20.68 |
| 174 | 186 | 6 | 44.733 | 45.739 | 15.83 | 49.05 | 21.35 |