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 |
|---|---|---|---|---|---|---|---|
| 216 | 186 | 25 | 51.833 | 53.125 | 14.552 | 51.32 | 19.54 |
| 233 | 101 | 25 | 42.567 | 45.909 | 17.37 | 50.74 | 24.82 |
| 75 | 58 | 25 | 25.583 | 27.076 | 9.802 | 30.44 | 23.84 |
| 143 | 210 | 25 | 45.9 | 47.623 | 20.159 | 58.19 | 25.78 |
| 178 | 149 | 25 | 13.1 | 13.272 | 1.918 | 10.62 | 8.6 |
| 106 | 170 | 25 | 26.933 | 26.078 | 7.605 | 25.64 | 18.34 |
| 197 | 74 | 25 | 35.433 | 36.902 | 13.884 | 44.92 | 24.6 |
| 224 | 190 | 25 | 25.183 | 25.881 | 7.227 | 24.88 | 17.34 |
| 41 | 62 | 25 | 48.917 | 53.607 | 15.132 | 48.44 | 18.55 |
| 247 | 223 | 25 | 19.583 | 20.233 | 6.299 | 21.1 | 21.52 |
| 14 | 79 | 25 | 35.433 | 36.063 | 10.908 | 35.08 | 18.77 |
| 80 | 70 | 25 | 24.95 | 25.679 | 7.394 | 25.13 | 20.04 |
| 183 | 208 | 25 | 7.017 | 8.929 | 2.368 | 11.31 | 13.52 |
| 33 | 93 | 25 | 29.9 | 32.269 | 12.768 | 37.96 | 26.59 |
| 197 | 186 | 25 | 48.217 | 49.17 | 12.518 | 48.52 | 16.88 |
| 193 | 13 | 25 | 26.767 | 27.993 | 8.37 | 28.4 | 19.71 |
| 188 | 29 | 24 | 31.758 | 32.265 | 7.179 | 26.13 | 13.62 |
| 224 | 217 | 24 | 17.792 | 19.147 | 4.192 | 17.06 | 14.22 |
| 236 | 46 | 24 | 33.75 | 38.914 | 14.608 | 43.98 | 24.57 |
| 13 | 259 | 24 | 67.558 | 66.684 | 20.682 | 63.41 | 20.93 |
| 45 | 191 | 24 | 44.067 | 51.199 | 19.626 | 58.37 | 26.24 |
| 28 | 35 | 24 | 33.508 | 33.888 | 8.319 | 27.97 | 15.11 |
| 114 | 250 | 24 | 37.358 | 40.328 | 14.482 | 44.17 | 22.79 |
| 114 | 32 | 24 | 37.467 | 40.109 | 15.465 | 46.31 | 25.22 |
| 179 | 192 | 24 | 16.508 | 19.27 | 7.471 | 24.21 | 26.94 |