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 |
|---|---|---|---|---|---|---|---|
| 31 | 20 | 19 | 7.083 | 7.179 | 1.216 | 8.76 | 10.15 |
| 160 | 197 | 19 | 12.217 | 14.28 | 4.453 | 17.37 | 20.98 |
| 262 | 22 | 19 | 39.367 | 40.736 | 17.077 | 48.39 | 26.15 |
| 220 | 116 | 19 | 21.117 | 22.206 | 5.667 | 20.98 | 16.11 |
| 51 | 220 | 19 | 32.85 | 34.332 | 8.201 | 30.48 | 15.43 |
| 131 | 41 | 19 | 29.383 | 33.442 | 14.337 | 41.48 | 27.35 |
| 112 | 92 | 19 | 21.533 | 25.732 | 9.371 | 29.53 | 24.24 |
| 162 | 57 | 19 | 38.067 | 34.184 | 9.994 | 32.87 | 19.23 |
| 120 | 120 | 19 | 0.5 | 2.905 | 1.088 | 20.87 | 224.75 |
| 210 | 137 | 19 | 50.083 | 51.304 | 18.614 | 53.88 | 22.92 |
| 202 | 142 | 19 | 16.483 | 18.468 | 3.026 | 20.58 | 10.03 |
| 77 | 85 | 19 | 24.033 | 28.026 | 4.414 | 20.68 | 9.99 |
| 82 | 76 | 19 | 27.65 | 28.931 | 8.023 | 27.68 | 18.39 |
| 100 | 251 | 19 | 42.417 | 45.804 | 20.455 | 60.5 | 28.69 |
| 227 | 62 | 19 | 35.233 | 35.536 | 5.189 | 24.49 | 9.32 |
| 193 | 160 | 19 | 20.7 | 21.672 | 6.189 | 21.47 | 18.09 |
| 225 | 162 | 19 | 43.017 | 41.218 | 8.579 | 32.35 | 13.15 |
| 232 | 126 | 19 | 31.4 | 32.211 | 10.933 | 34.24 | 21.66 |
| 185 | 212 | 19 | 15.267 | 16.049 | 3.807 | 14.97 | 15.99 |
| 168 | 31 | 19 | 22.167 | 20.575 | 6.672 | 22.24 | 21.52 |
| 135 | 161 | 19 | 33.95 | 36.198 | 12.297 | 42.69 | 22.71 |
| 241 | 41 | 19 | 27.967 | 30.852 | 7.071 | 26.82 | 14.75 |
| 50 | 19 | 19 | 38.583 | 42.964 | 19.372 | 55.84 | 29.63 |
| 35 | 26 | 19 | 37.15 | 36.504 | 6.096 | 25.76 | 10.52 |
| 149 | 170 | 19 | 54.967 | 54.968 | 15.998 | 48.74 | 18.39 |