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 | 175 | 70 | 32.925 | 37.653 | 14.698 | 43.54 | 25.38 |
| 70 | 37 | 70 | 27.717 | 28.164 | 8.126 | 26.86 | 18.42 |
| 35 | 37 | 70 | 17.892 | 19.733 | 2.96 | 14.46 | 9.37 |
| 168 | 138 | 70 | 15.658 | 17.901 | 6.973 | 21.91 | 26 |
| 233 | 94 | 70 | 28.033 | 30.406 | 10.052 | 31.69 | 21.19 |
| 48 | 124 | 70 | 48.467 | 51.728 | 15.389 | 49.61 | 19.35 |
| 143 | 108 | 70 | 45.008 | 47.681 | 18.749 | 55.81 | 24.06 |
| 114 | 72 | 70 | 36.167 | 38.252 | 8.445 | 31.07 | 14.03 |
| 237 | 183 | 70 | 27.85 | 30.053 | 11.632 | 35.1 | 24.45 |
| 164 | 205 | 70 | 54.4 | 54.291 | 15.874 | 50.05 | 19.68 |
| 238 | 106 | 70 | 40.017 | 40.369 | 11.15 | 37.16 | 17.46 |
| 80 | 233 | 70 | 19.858 | 21.314 | 5.827 | 21.21 | 17.43 |
| 92 | 82 | 70 | 16.567 | 18.731 | 4.433 | 17.22 | 15.59 |
| 236 | 171 | 70 | 30.417 | 31.831 | 12.139 | 36.39 | 23.87 |
| 114 | 26 | 70 | 29.583 | 30.456 | 9.42 | 30.61 | 19.66 |
| 87 | 173 | 70 | 35.008 | 35.735 | 12.182 | 38.04 | 22.16 |
| 249 | 197 | 70 | 41.883 | 45.148 | 14.12 | 45.04 | 20.86 |
| 42 | 81 | 70 | 27.008 | 30.211 | 10.784 | 33.81 | 23.63 |
| 42 | 261 | 70 | 36.392 | 38.147 | 10.765 | 35.73 | 18.87 |
| 48 | 218 | 70 | 48.808 | 53.222 | 17.374 | 53.15 | 21.66 |
| 43 | 235 | 70 | 23.133 | 26.276 | 7.4 | 25.25 | 18.74 |
| 53 | 92 | 70 | 11.375 | 11.882 | 2.055 | 10.31 | 11.64 |
| 148 | 11 | 70 | 27.15 | 28.137 | 12.158 | 35.86 | 26.77 |
| 226 | 16 | 70 | 27.642 | 30.315 | 11.928 | 35.4 | 25.97 |
| 88 | 155 | 70 | 37.817 | 44.985 | 15.652 | 47.67 | 22.7 |