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 |
|---|---|---|---|---|---|---|---|
| 116 | 93 | 26 | 25.85 | 26.157 | 11.776 | 34.85 | 28.28 |
| 203 | 61 | 26 | 50.608 | 51.758 | 12.787 | 35.48 | 15.22 |
| 70 | 39 | 26 | 40.9 | 39.582 | 14.732 | 43.95 | 23.54 |
| 216 | 188 | 26 | 35.3 | 33.855 | 9.418 | 31.26 | 17.13 |
| 26 | 39 | 26 | 36.375 | 38.547 | 8.596 | 31.24 | 13.4 |
| 133 | 40 | 26 | 9.425 | 13.976 | 3.297 | 13.08 | 18.97 |
| 77 | 140 | 26 | 62.725 | 62.343 | 16.398 | 52.09 | 17.27 |
| 71 | 90 | 26 | 45.758 | 46.978 | 10.26 | 37.07 | 13.82 |
| 106 | 68 | 26 | 27.025 | 30.033 | 6.624 | 25.08 | 14.58 |
| 233 | 63 | 26 | 32.492 | 38.144 | 11.743 | 37.85 | 20.67 |
| 180 | 149 | 26 | 24.3 | 25.589 | 10.357 | 30.76 | 24.95 |
| 49 | 133 | 26 | 19.05 | 19.388 | 4.98 | 18.08 | 15.6 |
| 42 | 92 | 26 | 28.725 | 28.375 | 11.076 | 33.84 | 24.16 |
| 42 | 56 | 26 | 25.533 | 28.04 | 10.921 | 32.91 | 24.68 |
| 114 | 10 | 26 | 33.142 | 39.089 | 16.849 | 49.54 | 27.51 |
| 236 | 21 | 26 | 50.317 | 53.663 | 17.535 | 54.01 | 20.73 |
| 37 | 14 | 26 | 38.842 | 39.283 | 11.743 | 38.51 | 20.42 |
| 71 | 165 | 26 | 19.717 | 19.558 | 2.895 | 14.41 | 9.25 |
| 182 | 71 | 26 | 59.367 | 64.622 | 19.59 | 63.74 | 19.25 |
| 95 | 146 | 26 | 22.85 | 24.399 | 7.675 | 26.16 | 20.12 |
| 159 | 136 | 26 | 21.583 | 22.926 | 4.745 | 19.31 | 13.81 |
| 127 | 69 | 26 | 18.892 | 20.223 | 4.258 | 17.44 | 13.6 |
| 76 | 234 | 26 | 53.117 | 51.481 | 14.289 | 46.65 | 17.19 |
| 143 | 240 | 26 | 22.625 | 24.292 | 11.924 | 34.16 | 31.55 |
| 148 | 9 | 26 | 26.4 | 28.227 | 13.727 | 39.88 | 30.99 |