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 |
|---|---|---|---|---|---|---|---|
| 169 | 50 | 4 | 36.383 | 32.433 | 9.305 | 31.75 | 20.75 |
| 101 | 85 | 4 | 56.908 | 61.542 | 19.7 | 60.8 | 20.2 |
| 12 | 149 | 4 | 33.033 | 37.229 | 10.325 | 34.12 | 17.47 |
| 165 | 246 | 4 | 49.075 | 48.417 | 13.577 | 45.88 | 18.94 |
| 208 | 71 | 4 | 63.958 | 64.567 | 19.035 | 61.88 | 18.33 |
| 234 | 207 | 4 | 22.467 | 30.704 | 9.853 | 31.88 | 21.9 |
| 131 | 63 | 4 | 27.958 | 25.592 | 8.88 | 28.38 | 23.21 |
| 166 | 155 | 4 | 59.283 | 66.075 | 25.398 | 74 | 25.48 |
| 259 | 71 | 4 | 72.942 | 75.767 | 25.155 | 75.4 | 21.11 |
| 130 | 51 | 4 | 35.517 | 40.221 | 18.15 | 52 | 28.78 |
| 118 | 141 | 4 | 84.692 | 88.354 | 32.195 | 93.75 | 22.06 |
| 37 | 126 | 4 | 37.225 | 36.075 | 14.635 | 43.88 | 24.19 |
| 165 | 256 | 4 | 43.133 | 43.312 | 8.85 | 34.12 | 12.45 |
| 188 | 60 | 4 | 63.325 | 60.867 | 20.475 | 63.38 | 21.3 |
| 34 | 125 | 4 | 18.842 | 20.196 | 3.938 | 17 | 12.74 |
| 212 | 220 | 4 | 25.35 | 25.742 | 8.637 | 26.9 | 20.23 |
| 167 | 33 | 4 | 52.6 | 52.979 | 14.025 | 46.75 | 16.7 |
| 42 | 46 | 4 | 25.533 | 31.587 | 12.418 | 37.5 | 26.66 |
| 173 | 36 | 4 | 23.483 | 24.575 | 7.242 | 23.88 | 18.06 |
| 108 | 72 | 4 | 39.092 | 37.038 | 8.327 | 29.5 | 14.13 |
| 238 | 58 | 4 | 26.508 | 28.825 | 12.643 | 37.12 | 30.01 |
| 4 | 10 | 4 | 56.083 | 54.317 | 18.42 | 56.91 | 20.94 |
| 49 | 127 | 4 | 37.833 | 38.283 | 16.488 | 45.74 | 26.77 |
| 256 | 203 | 4 | 48.625 | 50.188 | 18.935 | 55.75 | 23.1 |
| 191 | 179 | 4 | 29.308 | 31.425 | 13.64 | 39.12 | 26.47 |