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 |
|---|---|---|---|---|---|---|---|
| 91 | 229 | 5 | 58.567 | 53.163 | 14.39 | 42.66 | 16.92 |
| 195 | 174 | 5 | 50.933 | 52.5 | 24.52 | 71.2 | 28.37 |
| 258 | 83 | 5 | 20.417 | 18.837 | 5.126 | 18 | 16.86 |
| 18 | 132 | 5 | 38.3 | 39.453 | 21.494 | 58.1 | 33.78 |
| 182 | 142 | 5 | 44.767 | 41.61 | 11.464 | 37.3 | 18.48 |
| 217 | 63 | 5 | 29.6 | 30.463 | 5.528 | 22.7 | 11.36 |
| 201 | 4 | 5 | 55.25 | 57.117 | 22.404 | 75.22 | 23.52 |
| 133 | 50 | 5 | 30.533 | 33.23 | 10.754 | 33.93 | 20.29 |
| 175 | 132 | 5 | 25.733 | 34.537 | 14.078 | 40.9 | 27.7 |
| 61 | 18 | 5 | 54.433 | 70.63 | 20.754 | 67.5 | 20.68 |
| 219 | 202 | 5 | 54.517 | 51.513 | 15.218 | 53 | 18 |
| 263 | 59 | 5 | 26.233 | 25.88 | 6.74 | 23.7 | 17.25 |
| 174 | 237 | 5 | 33.183 | 42.97 | 12.688 | 41.2 | 19.47 |
| 145 | 1 | 5 | 62.017 | 63.913 | 23.958 | 105 | 24.31 |
| 39 | 233 | 5 | 47.2 | 54.417 | 15.57 | 46.47 | 17.96 |
| 171 | 161 | 5 | 42.2 | 46.14 | 13.026 | 38.06 | 18.13 |
| 257 | 7 | 5 | 50.1 | 44.627 | 13.33 | 43.4 | 18.97 |
| 33 | 206 | 5 | 35.15 | 38.013 | 14.304 | 42.8 | 23.07 |
| 254 | 68 | 5 | 46.467 | 50.403 | 17.348 | 53.66 | 21.9 |
| 90 | 207 | 5 | 21.217 | 25.113 | 10.196 | 31.4 | 25.82 |
| 205 | 171 | 5 | 22.7 | 28.943 | 10.852 | 33.7 | 23.43 |
| 83 | 181 | 5 | 25.583 | 29.37 | 9.482 | 29.9 | 20.86 |
| 170 | 44 | 5 | 53.767 | 59.76 | 31.284 | 86.4 | 33.86 |
| 43 | 57 | 5 | 29.717 | 33.693 | 10.558 | 33.8 | 19.5 |
| 226 | 32 | 5 | 36.233 | 38.99 | 13.448 | 42.33 | 23.36 |