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 |
|---|---|---|---|---|---|---|---|
| 224 | 42 | 231 | 19.483 | 21.106 | 7.48 | 23.69 | 23.42 |
| 255 | 142 | 231 | 31.317 | 33.326 | 7.213 | 27 | 13.67 |
| 229 | 257 | 231 | 31.567 | 32.879 | 11.001 | 34.15 | 21.21 |
| 89 | 165 | 231 | 9.583 | 10.398 | 1.725 | 9.16 | 10.89 |
| 141 | 216 | 231 | 39.033 | 43.066 | 14.769 | 46.74 | 22.75 |
| 10 | 90 | 231 | 45.133 | 45.404 | 15.178 | 52.01 | 21.73 |
| 211 | 82 | 231 | 26.617 | 28.19 | 8.763 | 29.37 | 20.07 |
| 42 | 107 | 231 | 29.683 | 31.433 | 7.651 | 26.93 | 16.65 |
| 232 | 189 | 231 | 20.833 | 21.719 | 4.704 | 18.47 | 13.59 |
| 188 | 25 | 231 | 18.383 | 19.703 | 3.291 | 15.36 | 10.97 |
| 77 | 76 | 231 | 9.783 | 10.013 | 1.53 | 8.96 | 9.51 |
| 244 | 128 | 230 | 13.742 | 14.477 | 3.509 | 13.97 | 15.5 |
| 48 | 128 | 230 | 19.25 | 20.508 | 9.323 | 27.91 | 28.62 |
| 79 | 216 | 230 | 38.008 | 43.279 | 15.451 | 48.55 | 24.33 |
| 230 | 248 | 230 | 26.3 | 28.132 | 11.044 | 33.45 | 25.24 |
| 45 | 14 | 230 | 22.008 | 23.679 | 9.042 | 27.73 | 24.64 |
| 229 | 173 | 230 | 27.95 | 29.597 | 7.517 | 26.59 | 15.94 |
| 234 | 159 | 230 | 27.108 | 31.015 | 8.387 | 28.74 | 18.18 |
| 79 | 35 | 230 | 30.867 | 34.078 | 8.228 | 28.96 | 15.14 |
| 129 | 48 | 230 | 25.533 | 30.013 | 7.005 | 25.95 | 14.98 |
| 45 | 228 | 230 | 20.642 | 22.172 | 6.237 | 21.45 | 18.33 |
| 138 | 153 | 230 | 27.225 | 31.244 | 11.809 | 36.19 | 25.22 |
| 234 | 134 | 229 | 30.567 | 33.994 | 11.886 | 37.72 | 23.11 |
| 138 | 108 | 229 | 48.45 | 51.763 | 22.188 | 62.69 | 28.24 |
| 188 | 35 | 229 | 16.067 | 16.418 | 2.437 | 12.6 | 9.23 |