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 |
|---|---|---|---|---|---|---|---|
| 100 | 196 | 730 | 24.525 | 27.231 | 8.237 | 27.61 | 19.77 |
| 146 | 132 | 729 | 40.3 | 42.476 | 15.532 | 48.15 | 24.41 |
| 164 | 168 | 729 | 21.05 | 22.857 | 6.826 | 23.14 | 19.21 |
| 162 | 168 | 729 | 17.733 | 19.894 | 5.769 | 19.83 | 19.28 |
| 112 | 226 | 728 | 8.792 | 9.345 | 2.042 | 9.14 | 13.99 |
| 166 | 137 | 728 | 30.392 | 31.374 | 6.518 | 25.17 | 13.22 |
| 170 | 188 | 728 | 36.483 | 37.689 | 9.283 | 32.55 | 15.55 |
| 45 | 50 | 727 | 25.05 | 26.043 | 4.686 | 20.27 | 11.98 |
| 138 | 169 | 727 | 26.667 | 29.427 | 9.831 | 31.2 | 22.09 |
| 65 | 225 | 727 | 18.033 | 19.264 | 3.55 | 15.29 | 11.64 |
| 88 | 80 | 727 | 21.067 | 22.246 | 5.699 | 20.6 | 16.44 |
| 74 | 126 | 727 | 13.933 | 15.198 | 3.8 | 14.47 | 16.1 |
| 88 | 151 | 727 | 27.733 | 30.258 | 8.476 | 28.9 | 18.15 |
| 158 | 14 | 726 | 25.092 | 26.898 | 10.492 | 31.69 | 24.32 |
| 152 | 143 | 725 | 14.55 | 14.992 | 3.852 | 14.81 | 16.69 |
| 229 | 52 | 725 | 27.7 | 28.801 | 7.515 | 25.55 | 16.97 |
| 170 | 257 | 724 | 30.017 | 31.993 | 10.313 | 32.64 | 20.61 |
| 40 | 106 | 722 | 6.033 | 6.468 | 1.077 | 6.41 | 10.64 |
| 127 | 244 | 722 | 10.7 | 11.746 | 2.41 | 11.04 | 13.44 |
| 237 | 17 | 722 | 35.975 | 37.632 | 8.384 | 31.3 | 14.06 |
| 158 | 61 | 722 | 30.967 | 32.288 | 7.072 | 26.32 | 13.57 |
| 140 | 97 | 722 | 27.717 | 29.17 | 8.332 | 28 | 18.39 |
| 7 | 83 | 721 | 11.733 | 12.684 | 2.762 | 11.68 | 13.93 |
| 142 | 12 | 720 | 26.292 | 26.941 | 6.007 | 22.81 | 14.22 |
| 25 | 89 | 719 | 18.6 | 20.808 | 4.366 | 17.65 | 13.76 |