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 |
|---|---|---|---|---|---|---|---|
| 137 | 225 | 677 | 32.783 | 33.835 | 7.127 | 27.24 | 13.4 |
| 228 | 228 | 677 | 5.2 | 7.862 | 1.457 | 9.12 | 17.2 |
| 125 | 166 | 677 | 25.083 | 27.496 | 7.225 | 25.65 | 16.86 |
| 166 | 13 | 676 | 28.308 | 29.987 | 8.046 | 27.93 | 16.99 |
| 141 | 80 | 676 | 23.05 | 24.425 | 5.923 | 21.78 | 15.25 |
| 186 | 69 | 676 | 31.517 | 34.107 | 9.373 | 31.81 | 17.91 |
| 151 | 168 | 675 | 19.717 | 20.658 | 3.951 | 16.61 | 12.04 |
| 243 | 127 | 675 | 8 | 8.598 | 1.662 | 8.3 | 12.15 |
| 138 | 253 | 675 | 9.583 | 11.376 | 3.664 | 13.31 | 21.37 |
| 132 | 20 | 674 | 42.483 | 45.767 | 21.29 | 59.81 | 30.58 |
| 263 | 65 | 673 | 23.85 | 24.887 | 8.69 | 27.19 | 22.18 |
| 232 | 237 | 673 | 19.583 | 21.093 | 4.89 | 18.66 | 15.34 |
| 246 | 14 | 673 | 30.617 | 32.813 | 11.479 | 35.57 | 22.05 |
| 137 | 40 | 672 | 21.908 | 23.07 | 6.794 | 22.49 | 18.93 |
| 255 | 198 | 672 | 17.117 | 17.764 | 3.602 | 14.57 | 12.65 |
| 186 | 82 | 671 | 32.167 | 33.838 | 7.956 | 29.12 | 15.25 |
| 100 | 189 | 671 | 33.033 | 35.305 | 7.801 | 28.9 | 14.16 |
| 249 | 95 | 671 | 33.083 | 35.09 | 11.066 | 35.65 | 20.21 |
| 113 | 12 | 671 | 14.417 | 15.199 | 2.77 | 12.53 | 12.18 |
| 197 | 197 | 670 | 1.175 | 4.315 | 0.972 | 16.69 | 61.66 |
| 158 | 243 | 670 | 25.55 | 27.694 | 10.181 | 31.74 | 23.32 |
| 140 | 217 | 669 | 27.05 | 28.092 | 6.962 | 25.91 | 15.78 |
| 188 | 61 | 668 | 10.625 | 11.564 | 1.873 | 9.67 | 10.43 |
| 263 | 181 | 668 | 32.325 | 33.608 | 10.854 | 34.25 | 20.46 |
| 74 | 232 | 668 | 18.283 | 20.412 | 7.365 | 23.06 | 23.91 |