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 |
|---|---|---|---|---|---|---|---|
| 12 | 211 | 459 | 14.783 | 15.418 | 2.187 | 11.77 | 9.07 |
| 170 | 133 | 459 | 31.483 | 34.009 | 11.111 | 35.03 | 21.47 |
| 196 | 82 | 459 | 8.25 | 8.775 | 1.39 | 8.8 | 11.24 |
| 231 | 168 | 458 | 29.792 | 33.41 | 10.931 | 34.56 | 22.69 |
| 186 | 157 | 458 | 27.65 | 29.961 | 6.896 | 26.07 | 15.08 |
| 162 | 93 | 458 | 33.017 | 37.119 | 11.554 | 37.46 | 20.83 |
| 36 | 36 | 458 | 4.358 | 6.112 | 1.132 | 7.48 | 24.02 |
| 232 | 50 | 457 | 25.233 | 26.948 | 5.238 | 21.45 | 12.3 |
| 87 | 24 | 457 | 28.9 | 30.413 | 8.711 | 29.35 | 18.11 |
| 61 | 62 | 457 | 6.95 | 8.627 | 1.279 | 7.67 | 10.33 |
| 243 | 116 | 457 | 12.633 | 13.328 | 2.47 | 11.52 | 12.04 |
| 50 | 220 | 457 | 18.8 | 21.69 | 10.159 | 29.81 | 30.91 |
| 42 | 235 | 457 | 15.767 | 17.19 | 3.804 | 15.3 | 14.65 |
| 164 | 195 | 457 | 30.167 | 31.48 | 8.417 | 28.92 | 17.23 |
| 209 | 17 | 456 | 21.6 | 22.651 | 4.636 | 18.47 | 13.09 |
| 75 | 144 | 456 | 26.675 | 27.587 | 7.027 | 24.92 | 16.76 |
| 43 | 146 | 456 | 17.967 | 19.237 | 3.711 | 15.93 | 12.44 |
| 161 | 92 | 456 | 35.508 | 38.066 | 11.82 | 38.02 | 19.99 |
| 107 | 127 | 456 | 28.083 | 30.313 | 11.186 | 34.48 | 24.08 |
| 186 | 227 | 456 | 35.8 | 37.539 | 10.304 | 34.39 | 17.6 |
| 61 | 181 | 456 | 12.308 | 14.032 | 2.344 | 11.37 | 10.84 |
| 226 | 249 | 455 | 22.233 | 24.002 | 6.049 | 28.65 | 16.12 |
| 65 | 106 | 455 | 12.25 | 12.923 | 2.1 | 10.77 | 10.09 |
| 231 | 260 | 455 | 28.083 | 30.897 | 9.038 | 30.1 | 19.66 |
| 244 | 263 | 455 | 24.483 | 25.306 | 6.078 | 22.45 | 15.61 |