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 |
|---|---|---|---|---|---|---|---|
| 140 | 66 | 770 | 22.35 | 23.957 | 7.491 | 24.69 | 20.45 |
| 14 | 14 | 770 | 5.708 | 7.289 | 1.43 | 8.52 | 24.94 |
| 255 | 61 | 769 | 18.75 | 19.831 | 3.903 | 15.96 | 12.35 |
| 87 | 41 | 769 | 29.183 | 31.132 | 9.832 | 31.56 | 20.3 |
| 65 | 80 | 769 | 11.783 | 13.185 | 3.526 | 13.49 | 18.02 |
| 70 | 70 | 768 | 3.767 | 5.791 | 1.265 | 11.86 | 31.61 |
| 90 | 12 | 767 | 17.267 | 17.976 | 3.611 | 15.25 | 12.85 |
| 239 | 255 | 767 | 34.867 | 36.077 | 7.904 | 29.46 | 13.59 |
| 244 | 163 | 766 | 22.683 | 23.406 | 6.815 | 23.75 | 19.49 |
| 33 | 13 | 765 | 15.967 | 16.685 | 3.312 | 14.65 | 12.48 |
| 12 | 100 | 765 | 27.3 | 28.415 | 5.192 | 22.22 | 11.72 |
| 113 | 14 | 764 | 29.992 | 31.616 | 10.719 | 33.46 | 21.42 |
| 82 | 56 | 764 | 9.158 | 9.674 | 1.67 | 8.51 | 10.73 |
| 233 | 40 | 764 | 24.5 | 25.27 | 7.426 | 24.41 | 18.8 |
| 45 | 224 | 764 | 13.108 | 13.939 | 2.496 | 11.68 | 11.92 |
| 233 | 116 | 763 | 24.45 | 26.747 | 7.25 | 25.04 | 17.73 |
| 43 | 255 | 763 | 30.9 | 32.521 | 6.884 | 26.44 | 13.15 |
| 107 | 82 | 762 | 23.567 | 25.563 | 7.668 | 25.73 | 20.23 |
| 161 | 160 | 761 | 25.233 | 27.337 | 7.636 | 26.37 | 17.9 |
| 125 | 41 | 760 | 27.283 | 29.008 | 7.592 | 26.5 | 16.49 |
| 229 | 40 | 760 | 26.225 | 27.238 | 8.134 | 26.38 | 19 |
| 65 | 189 | 760 | 12.925 | 13.991 | 2.134 | 11.04 | 9.72 |
| 12 | 170 | 759 | 20.1 | 21.953 | 5.497 | 20.42 | 16.48 |
| 13 | 42 | 759 | 28.65 | 31.313 | 10.803 | 33.7 | 22.57 |
| 141 | 65 | 759 | 22.383 | 23.974 | 7.639 | 25.17 | 20.43 |