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 |
|---|---|---|---|---|---|---|---|
| 229 | 185 | 123 | 24.817 | 27.387 | 11.207 | 33.29 | 26.39 |
| 256 | 75 | 123 | 23.167 | 24.784 | 8.293 | 26.84 | 21.52 |
| 238 | 242 | 123 | 28.183 | 29.723 | 10.456 | 32.6 | 23.14 |
| 181 | 209 | 123 | 16.2 | 17.811 | 3.767 | 15.53 | 13.46 |
| 148 | 18 | 123 | 29.683 | 32.942 | 14.528 | 42.35 | 28.31 |
| 41 | 179 | 123 | 15.483 | 17.51 | 4.787 | 17.51 | 17.83 |
| 33 | 72 | 123 | 33.517 | 33.787 | 5.781 | 24.62 | 10.78 |
| 42 | 148 | 123 | 30.067 | 31.931 | 9.402 | 30.73 | 19.53 |
| 256 | 125 | 123 | 17.083 | 18.191 | 3.478 | 20.7 | 12.57 |
| 151 | 18 | 123 | 30.767 | 32.048 | 8.957 | 30.04 | 17.81 |
| 157 | 82 | 123 | 11.017 | 12.311 | 2.153 | 10.43 | 11.71 |
| 260 | 92 | 123 | 18.217 | 19.405 | 6.209 | 21.04 | 21.2 |
| 234 | 250 | 123 | 33.667 | 37.068 | 12.618 | 39.33 | 22.22 |
| 66 | 257 | 123 | 13.267 | 14.561 | 4.831 | 16.35 | 22.12 |
| 232 | 147 | 123 | 47.267 | 47.25 | 10.092 | 37.06 | 15.52 |
| 10 | 114 | 123 | 46.533 | 48.378 | 15.496 | 51.99 | 21.25 |
| 232 | 62 | 123 | 25.95 | 27.865 | 5.788 | 22.43 | 13.27 |
| 52 | 256 | 123 | 16.567 | 17.517 | 4.539 | 16.85 | 16.88 |
| 189 | 52 | 123 | 11.733 | 12.896 | 2.003 | 10.41 | 9.8 |
| 140 | 20 | 122 | 26.675 | 29.42 | 9.82 | 31.01 | 21.6 |
| 239 | 198 | 122 | 35.158 | 38.043 | 9.329 | 32.29 | 15.28 |
| 50 | 193 | 122 | 22.292 | 23.92 | 4.444 | 18.58 | 12.13 |
| 164 | 241 | 122 | 31.267 | 32.655 | 12.761 | 38.64 | 25.08 |
| 7 | 93 | 122 | 16.258 | 18.386 | 6.39 | 21.11 | 23.33 |
| 130 | 216 | 122 | 14.883 | 15.776 | 3.133 | 14.41 | 12.7 |