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 |
|---|---|---|---|---|---|---|---|
| 213 | 20 | 29 | 16.833 | 17.261 | 4.174 | 15.73 | 16.2 |
| 196 | 218 | 29 | 30.1 | 30.787 | 8.622 | 28.72 | 18.5 |
| 102 | 196 | 29 | 11.333 | 11.804 | 2.396 | 14.42 | 12.54 |
| 158 | 185 | 29 | 37.217 | 39.284 | 16.461 | 47.93 | 26.35 |
| 211 | 175 | 29 | 35.517 | 38.191 | 15.407 | 44.86 | 24.85 |
| 236 | 55 | 29 | 50.15 | 51.676 | 21.272 | 60.8 | 25.31 |
| 140 | 64 | 29 | 46.55 | 48.263 | 18.433 | 54.31 | 24.44 |
| 142 | 101 | 29 | 52.7 | 56.882 | 19.611 | 59.27 | 21.85 |
| 228 | 177 | 29 | 39.067 | 37.599 | 6.144 | 25.74 | 10.38 |
| 127 | 247 | 29 | 16.45 | 16.459 | 4.194 | 16.02 | 16.54 |
| 125 | 123 | 29 | 32.533 | 34.055 | 11.723 | 35.98 | 21.74 |
| 190 | 37 | 29 | 23.433 | 24.461 | 4.682 | 19.24 | 12.44 |
| 177 | 88 | 29 | 57.583 | 56.068 | 8.076 | 37.67 | 8.86 |
| 185 | 182 | 29 | 10.433 | 11.491 | 1.71 | 9.41 | 9.42 |
| 232 | 134 | 29 | 28 | 33.144 | 12.755 | 38.5 | 25.21 |
| 238 | 101 | 29 | 52.95 | 57.71 | 21.466 | 62.69 | 24.15 |
| 226 | 131 | 29 | 28.417 | 30.58 | 11.041 | 34.03 | 24.4 |
| 193 | 144 | 29 | 25.333 | 26.433 | 6.683 | 23.93 | 16.18 |
| 42 | 208 | 29 | 17.967 | 22.076 | 8.597 | 26.59 | 25.07 |
| 225 | 234 | 29 | 45.4 | 46.558 | 6.999 | 30.81 | 9.49 |
| 159 | 236 | 29 | 28.517 | 27.365 | 4.226 | 19.21 | 10.42 |
| 82 | 171 | 29 | 19.983 | 20.433 | 5.406 | 19.79 | 17.49 |
| 72 | 49 | 29 | 23.717 | 24.71 | 4.286 | 18.37 | 10.9 |
| 224 | 202 | 29 | 19.617 | 21.315 | 5.607 | 19.55 | 16.65 |
| 169 | 130 | 29 | 42.783 | 43.593 | 15.661 | 48.41 | 22.26 |