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 |
|---|---|---|---|---|---|---|---|
| 117 | 65 | 5 | 63.8 | 63.977 | 22.892 | 68.75 | 21.55 |
| 211 | 3 | 5 | 50.35 | 50.037 | 18.946 | 56.3 | 22.91 |
| 86 | 191 | 5 | 41.833 | 41.337 | 9.708 | 35.3 | 14.09 |
| 171 | 166 | 5 | 33.383 | 35.093 | 10.588 | 35.71 | 18.79 |
| 94 | 39 | 5 | 78.733 | 82.4 | 23.244 | 71.02 | 17.04 |
| 239 | 245 | 5 | 48.067 | 50.14 | 20.61 | 60.5 | 24.94 |
| 38 | 163 | 5 | 74.417 | 69.927 | 21.548 | 68.6 | 19.9 |
| 21 | 261 | 5 | 26.417 | 23.15 | 11.348 | 42.52 | 32.42 |
| 179 | 220 | 5 | 20.3 | 21.873 | 11.306 | 32.6 | 33.45 |
| 56 | 57 | 5 | 4.767 | 5.23 | 0.98 | 5.7 | 11.69 |
| 97 | 19 | 5 | 29.517 | 33.493 | 18.53 | 50.6 | 34.73 |
| 85 | 79 | 5 | 33.35 | 33.797 | 8.572 | 29.23 | 15.68 |
| 167 | 45 | 5 | 58.65 | 53.263 | 12.298 | 43.2 | 15.2 |
| 222 | 198 | 5 | 36.95 | 39.113 | 6.824 | 29.5 | 10.58 |
| 177 | 227 | 5 | 43.367 | 40.66 | 6.736 | 26.48 | 10.26 |
| 197 | 249 | 5 | 31.567 | 35.813 | 14.946 | 47.7 | 25.81 |
| 146 | 26 | 5 | 36.217 | 37.31 | 14.46 | 43.2 | 24.18 |
| 196 | 64 | 5 | 24.4 | 23.533 | 8.364 | 27.72 | 22.67 |
| 208 | 147 | 5 | 21.883 | 20.433 | 5.596 | 19.7 | 17.27 |
| 220 | 90 | 5 | 35.467 | 33.353 | 12.64 | 38.5 | 22.99 |
| 12 | 92 | 5 | 37.883 | 46.557 | 16.662 | 49.6 | 23.29 |
| 10 | 241 | 5 | 32.55 | 33.903 | 20.088 | 53.9 | 36.3 |
| 225 | 254 | 5 | 52.917 | 47.103 | 21.596 | 61.52 | 29.1 |
| 159 | 223 | 5 | 26.733 | 25.25 | 6.202 | 22.6 | 17.96 |
| 153 | 168 | 5 | 22.367 | 30.34 | 8.604 | 29.2 | 17.04 |