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 |
|---|---|---|---|---|---|---|---|
| 165 | 162 | 21 | 57.567 | 54.975 | 13.839 | 44.27 | 15.92 |
| 257 | 161 | 21 | 23.933 | 27.575 | 11.226 | 36.92 | 26.21 |
| 143 | 214 | 21 | 58.233 | 58.966 | 18.556 | 57.6 | 19.17 |
| 261 | 252 | 21 | 43.05 | 47.782 | 18.887 | 55.79 | 26.21 |
| 209 | 98 | 21 | 38.017 | 41.327 | 16.014 | 46.64 | 25.75 |
| 250 | 18 | 21 | 25.133 | 25.935 | 4.813 | 20.12 | 12.78 |
| 238 | 72 | 21 | 61.3 | 62.158 | 14.992 | 51.33 | 14.74 |
| 161 | 204 | 21 | 47.833 | 50.577 | 28.687 | 78.33 | 35.14 |
| 3 | 208 | 21 | 11.083 | 13.492 | 3.546 | 13.88 | 17.23 |
| 224 | 242 | 21 | 34.967 | 35.791 | 12.733 | 38.9 | 22.25 |
| 74 | 128 | 21 | 21.65 | 22.066 | 5.961 | 23.14 | 18.11 |
| 188 | 226 | 21 | 27.533 | 29.311 | 8.732 | 28.86 | 18.98 |
| 142 | 23 | 21 | 49.467 | 52.445 | 19.712 | 59.24 | 23.14 |
| 16 | 19 | 21 | 20.767 | 18.725 | 5.185 | 18.21 | 17.83 |
| 14 | 71 | 21 | 35.667 | 36.961 | 8.598 | 30.85 | 15.11 |
| 193 | 93 | 21 | 23.467 | 29.24 | 9.924 | 31.12 | 23.06 |
| 263 | 35 | 21 | 47.417 | 48.091 | 14.971 | 47.05 | 19.73 |
| 210 | 188 | 21 | 24.633 | 24.892 | 5.181 | 19.84 | 12.97 |
| 24 | 213 | 21 | 31.483 | 34.416 | 8.852 | 30.19 | 15.92 |
| 13 | 20 | 21 | 48.517 | 50.084 | 17.441 | 53.38 | 22.27 |
| 24 | 3 | 21 | 34.3 | 34.88 | 12.758 | 39.21 | 23.21 |
| 119 | 60 | 21 | 15.35 | 16.714 | 3.813 | 15.26 | 14.41 |
| 12 | 145 | 21 | 28.133 | 30.5 | 7.983 | 27.93 | 16.63 |
| 191 | 218 | 21 | 14.667 | 15.895 | 5.381 | 18.29 | 21.25 |
| 218 | 170 | 21 | 48.683 | 48.487 | 15.929 | 48.67 | 22.6 |