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 |
|---|---|---|---|---|---|---|---|
| 50 | 65 | 425 | 29.183 | 29.91 | 6.753 | 25.17 | 14.23 |
| 246 | 220 | 425 | 23.617 | 25.403 | 11.226 | 33.13 | 28.27 |
| 125 | 24 | 424 | 23.633 | 25.128 | 6.617 | 23.53 | 16.65 |
| 113 | 152 | 424 | 27.642 | 30.129 | 7.899 | 27.79 | 16.81 |
| 249 | 227 | 424 | 25.55 | 27.428 | 8.718 | 28.18 | 20.27 |
| 79 | 173 | 424 | 27.692 | 30.071 | 9.802 | 31.81 | 21.33 |
| 209 | 80 | 423 | 19.117 | 20.484 | 5.093 | 18.88 | 16.08 |
| 232 | 65 | 423 | 12.917 | 14.313 | 3.181 | 13.05 | 14.49 |
| 256 | 33 | 423 | 14.85 | 16.477 | 3.866 | 15.01 | 15.65 |
| 230 | 119 | 423 | 25.783 | 28.853 | 8.864 | 29.3 | 20.59 |
| 75 | 212 | 423 | 18.017 | 20.826 | 6.118 | 20.9 | 19.83 |
| 100 | 133 | 422 | 31.733 | 33.982 | 10.803 | 34.59 | 20.34 |
| 93 | 238 | 422 | 27.625 | 29.489 | 12.095 | 50.6 | 26.17 |
| 25 | 132 | 421 | 43.017 | 44.594 | 16.184 | 50.34 | 23.91 |
| 143 | 33 | 421 | 34.517 | 35.44 | 8.141 | 29.39 | 14.42 |
| 33 | 100 | 421 | 25.8 | 27.236 | 6.026 | 22.91 | 14.32 |
| 140 | 189 | 421 | 32.35 | 33.876 | 9.349 | 31.62 | 17.66 |
| 140 | 26 | 421 | 40.483 | 41.33 | 13.312 | 41.84 | 20.76 |
| 145 | 90 | 421 | 18.483 | 20.816 | 3.921 | 41.55 | 12.35 |
| 125 | 74 | 421 | 29.883 | 32.312 | 8.301 | 28.89 | 16.65 |
| 229 | 61 | 421 | 35.817 | 37.546 | 9.498 | 32.78 | 16.25 |
| 10 | 107 | 421 | 37.333 | 39.244 | 14.471 | 52.1 | 24.49 |
| 107 | 54 | 420 | 24.317 | 25.298 | 6.162 | 22.15 | 15.36 |
| 234 | 220 | 419 | 32.017 | 34.946 | 12.582 | 38.87 | 23.01 |
| 161 | 133 | 419 | 34.617 | 36.752 | 11.825 | 37.45 | 20.64 |