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 |
|---|---|---|---|---|---|---|---|
| 75 | 106 | 43 | 34.367 | 35.026 | 11.597 | 36.13 | 21.22 |
| 123 | 155 | 43 | 18.817 | 20.513 | 3.555 | 15.82 | 10.37 |
| 238 | 131 | 43 | 38.417 | 40.872 | 16.816 | 48.8 | 26.44 |
| 125 | 83 | 43 | 24.233 | 29.597 | 8.48 | 29.8 | 20.6 |
| 87 | 248 | 43 | 36.017 | 39.508 | 14.34 | 42.76 | 24.13 |
| 234 | 120 | 43 | 25.25 | 29.336 | 9.916 | 31.45 | 22.95 |
| 53 | 142 | 43 | 39.817 | 40.454 | 15.296 | 42.43 | 22.89 |
| 69 | 137 | 43 | 36.383 | 36.63 | 8.502 | 29.3 | 14.95 |
| 198 | 25 | 43 | 41.4 | 41.533 | 5.729 | 27.42 | 8.63 |
| 162 | 96 | 43 | 31.433 | 33.177 | 10.705 | 34.6 | 20.09 |
| 127 | 143 | 43 | 17.45 | 19.216 | 8.053 | 25.06 | 27.39 |
| 191 | 19 | 43 | 7.767 | 9.128 | 2.274 | 10.16 | 14.89 |
| 10 | 97 | 43 | 58.917 | 58.387 | 13.277 | 44.33 | 15.52 |
| 39 | 209 | 43 | 46.533 | 47.442 | 12.849 | 42.52 | 16.96 |
| 80 | 195 | 43 | 16.383 | 18.497 | 6.065 | 20.01 | 22.7 |
| 170 | 6 | 43 | 34.883 | 38.222 | 16.593 | 49.58 | 27.25 |
| 235 | 94 | 43 | 10.333 | 11.616 | 1.578 | 9.21 | 8.72 |
| 223 | 144 | 43 | 34.2 | 36.032 | 10.193 | 35.28 | 18.58 |
| 40 | 36 | 43 | 24.1 | 24.519 | 6.524 | 22.66 | 16.66 |
| 195 | 89 | 43 | 19.85 | 20.379 | 4.959 | 18.61 | 15.53 |
| 42 | 112 | 43 | 34.633 | 37.1 | 10.063 | 34.06 | 17.29 |
| 209 | 147 | 43 | 44.2 | 44.419 | 12.041 | 39.48 | 18.2 |
| 158 | 178 | 43 | 28.5 | 31.121 | 10.278 | 32.33 | 20.34 |
| 158 | 155 | 43 | 40.833 | 43.018 | 15.894 | 47.58 | 23.2 |
| 92 | 132 | 43 | 24.217 | 26.311 | 10.839 | 33.57 | 27.68 |