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 |
|---|---|---|---|---|---|---|---|
| 155 | 35 | 47 | 19.4 | 19.931 | 3.651 | 16.06 | 11.12 |
| 51 | 250 | 47 | 14.55 | 16.941 | 4.721 | 17.42 | 17.66 |
| 77 | 65 | 47 | 34.233 | 39.929 | 6.497 | 27.58 | 10.84 |
| 88 | 16 | 47 | 37.3 | 38.34 | 18.532 | 52.12 | 30.26 |
| 192 | 121 | 47 | 7.4 | 8.978 | 1.753 | 9.83 | 17.13 |
| 195 | 163 | 47 | 38.217 | 41.054 | 9.863 | 35.38 | 15.2 |
| 10 | 127 | 47 | 38.1 | 42.012 | 18.693 | 51.87 | 30.61 |
| 186 | 203 | 47 | 50.817 | 54.792 | 20.056 | 58.9 | 23.79 |
| 48 | 175 | 47 | 41.283 | 45.303 | 16.071 | 48.14 | 23.85 |
| 239 | 51 | 47 | 31.017 | 35.209 | 15.113 | 44.57 | 28.59 |
| 142 | 177 | 47 | 46.567 | 50.586 | 11.785 | 41.61 | 14.6 |
| 113 | 32 | 47 | 40.85 | 47.219 | 14.805 | 46.49 | 21.12 |
| 193 | 198 | 47 | 27.283 | 28.538 | 5.929 | 22.66 | 12.98 |
| 91 | 225 | 47 | 27.75 | 28.432 | 5.113 | 21.11 | 11.37 |
| 146 | 49 | 47 | 28.067 | 29.096 | 6.627 | 24.87 | 14.44 |
| 42 | 177 | 47 | 45.033 | 44.782 | 17.601 | 50.84 | 25.24 |
| 82 | 121 | 47 | 15.083 | 16.062 | 5.478 | 18.41 | 22.93 |
| 146 | 28 | 47 | 24.967 | 28.646 | 10.48 | 32.38 | 24.26 |
| 231 | 251 | 47 | 28.717 | 30.221 | 14.934 | 42.31 | 30.54 |
| 74 | 36 | 47 | 35.45 | 37.284 | 12.023 | 37.86 | 20.2 |
| 226 | 159 | 47 | 25.233 | 29.495 | 7.906 | 27.31 | 18.21 |
| 47 | 247 | 47 | 13.033 | 14.331 | 2.071 | 11.17 | 9.14 |
| 165 | 61 | 47 | 31.2 | 31.015 | 5.239 | 21.94 | 10.66 |
| 186 | 117 | 47 | 57.367 | 64.242 | 23.665 | 70.23 | 23.77 |
| 254 | 18 | 47 | 15.883 | 16.648 | 2.737 | 13.4 | 10.8 |