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 |
|---|---|---|---|---|---|---|---|
| 96 | 143 | 1 | 64.017 | 64.017 | 11.52 | 52 | 10.8 |
| 223 | 44 | 1 | 58.383 | 58.383 | 36.39 | 96 | 37.4 |
| 166 | 5 | 1 | 103.25 | 103.25 | 30.75 | 102.5 | 17.87 |
| 22 | 195 | 1 | 18.133 | 18.133 | 9.75 | 44.3 | 32.26 |
| 51 | 158 | 1 | 43.617 | 43.617 | 18.65 | 54.5 | 25.66 |
| 131 | 259 | 1 | 42.55 | 42.55 | 14.85 | 46.5 | 20.94 |
| 72 | 179 | 1 | 80.967 | 80.967 | 20.14 | 67.5 | 14.92 |
| 91 | 220 | 1 | 83.383 | 83.383 | 24.18 | 78 | 17.4 |
| 173 | 114 | 1 | 55.567 | 55.567 | 8.6 | 36.5 | 9.29 |
| 257 | 214 | 1 | 26.517 | 26.517 | 11.34 | 33 | 25.66 |
| 198 | 261 | 1 | 46.017 | 46.017 | 8.71 | 33.5 | 11.36 |
| 127 | 85 | 1 | 74.95 | 74.95 | 19.19 | 63.5 | 15.36 |
| 247 | 36 | 1 | 29.183 | 29.183 | 11.42 | 34.5 | 23.48 |
| 118 | 50 | 1 | 94.583 | 94.583 | 30.67 | 93.5 | 19.46 |
| 52 | 172 | 1 | 54.983 | 54.983 | 18.43 | 55.5 | 20.11 |
| 8 | 28 | 1 | 11.567 | 11.567 | 6.79 | 20.5 | 35.22 |
| 14 | 12 | 1 | 17.883 | 17.883 | 6.78 | 20.5 | 22.75 |
| 222 | 183 | 1 | 61.083 | 61.083 | 25.17 | 71 | 24.72 |
| 200 | 10 | 1 | 48.35 | 48.35 | 24.12 | 66.5 | 29.93 |
| 258 | 116 | 1 | 55.167 | 55.167 | 20.59 | 59 | 22.39 |
| 19 | 253 | 1 | 11.283 | 11.283 | 9.52 | 26 | 50.62 |
| 118 | 35 | 1 | 58.717 | 58.717 | 25.5 | 72 | 26.06 |
| 26 | 38 | 1 | 38.55 | 38.55 | 23.77 | 65 | 37 |
| 27 | 170 | 1 | 69.067 | 69.067 | 28.54 | 62.96 | 24.79 |
| 37 | 122 | 1 | 24.483 | 24.483 | 14.55 | 40 | 35.66 |