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 |
|---|---|---|---|---|---|---|---|
| 37 | 162 | 29 | 24.217 | 28.421 | 6.989 | 25.41 | 16.1 |
| 81 | 74 | 29 | 31.017 | 32.966 | 11.103 | 35.52 | 22.55 |
| 179 | 205 | 29 | 29.083 | 34.057 | 12.583 | 39.22 | 24.32 |
| 61 | 242 | 29 | 42.083 | 46.976 | 18.399 | 53.8 | 24.68 |
| 222 | 49 | 29 | 33.883 | 37.352 | 6.637 | 27.16 | 11.23 |
| 179 | 37 | 29 | 25.733 | 28.353 | 6.806 | 24.52 | 15.47 |
| 174 | 168 | 29 | 24.783 | 26.241 | 7.491 | 25.39 | 19.08 |
| 85 | 106 | 29 | 17.75 | 19.209 | 3.659 | 15.72 | 12.47 |
| 88 | 169 | 29 | 37.717 | 41.618 | 14.544 | 43.38 | 23.56 |
| 131 | 218 | 29 | 22.8 | 22.476 | 4.726 | 18.61 | 13.18 |
| 191 | 188 | 29 | 48.067 | 47.775 | 14.486 | 46.06 | 19.09 |
| 37 | 238 | 29 | 42.1 | 45.051 | 11.209 | 39.21 | 15.8 |
| 166 | 51 | 29 | 34.1 | 37.157 | 13.721 | 41.71 | 24.01 |
| 144 | 150 | 29 | 34.883 | 34.949 | 16.272 | 46.04 | 30.31 |
| 33 | 116 | 29 | 37.367 | 38.424 | 13.277 | 41.02 | 21.92 |
| 217 | 231 | 29 | 15.583 | 18.497 | 4.259 | 35.53 | 15.54 |
| 33 | 178 | 29 | 22.633 | 23.225 | 6.777 | 23.01 | 18.55 |
| 87 | 214 | 29 | 27.2 | 29.645 | 13.604 | 39.1 | 28.74 |
| 89 | 148 | 29 | 30.133 | 31.721 | 7.616 | 27.36 | 15.52 |
| 139 | 38 | 29 | 9.4 | 10.909 | 2.591 | 10.83 | 12.92 |
| 89 | 77 | 29 | 27.15 | 29.82 | 5.181 | 21.64 | 10.74 |
| 262 | 32 | 29 | 24.3 | 29.193 | 9.804 | 31.28 | 22.48 |
| 247 | 141 | 29 | 21.667 | 23.551 | 5.361 | 20.04 | 15.56 |
| 229 | 124 | 29 | 46.983 | 49.408 | 13.351 | 44.09 | 16.96 |
| 80 | 39 | 29 | 33.25 | 33.749 | 7.541 | 27.03 | 13.8 |