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 |
|---|---|---|---|---|---|---|---|
| 168 | 148 | 12 | 28.167 | 32.76 | 9.306 | 30.79 | 19.62 |
| 120 | 132 | 12 | 35.708 | 41.508 | 20.255 | 52 | 32.82 |
| 72 | 164 | 12 | 54.1 | 54.136 | 11.158 | 37.36 | 12.62 |
| 130 | 160 | 12 | 19.542 | 21.851 | 6.802 | 25.38 | 20.23 |
| 222 | 216 | 12 | 17.825 | 20.124 | 5.885 | 20.12 | 19.13 |
| 152 | 65 | 12 | 36.808 | 41.712 | 11.876 | 39.38 | 18.08 |
| 260 | 252 | 12 | 16.4 | 17.069 | 7.822 | 23.83 | 28.22 |
| 43 | 124 | 12 | 55.375 | 60.322 | 16.423 | 53.75 | 18.03 |
| 102 | 140 | 12 | 47.167 | 47.257 | 12.284 | 39.68 | 15.65 |
| 174 | 166 | 12 | 24.283 | 31.299 | 10.353 | 32.96 | 23.17 |
| 216 | 101 | 12 | 26.817 | 28.337 | 12.118 | 38.44 | 27.25 |
| 75 | 46 | 12 | 31.683 | 37.576 | 12.884 | 39.71 | 23.41 |
| 255 | 197 | 12 | 24.625 | 26.049 | 11.162 | 32.96 | 25.89 |
| 232 | 47 | 12 | 34.242 | 42.069 | 13.633 | 39.6 | 23.09 |
| 18 | 168 | 12 | 26.875 | 23.349 | 5.333 | 20.49 | 13.78 |
| 190 | 233 | 12 | 31.775 | 31.472 | 8.794 | 29.46 | 17.16 |
| 66 | 77 | 12 | 34.117 | 38.96 | 7.651 | 30.04 | 13.34 |
| 228 | 233 | 12 | 31.133 | 35.178 | 8.928 | 31.33 | 16.12 |
| 185 | 168 | 12 | 25.4 | 26.411 | 7.263 | 24.79 | 17.07 |
| 51 | 119 | 12 | 30.7 | 29.307 | 10.406 | 31.83 | 22.33 |
| 53 | 226 | 12 | 28.633 | 28.736 | 9.052 | 29.11 | 20.02 |
| 69 | 43 | 12 | 31.892 | 38.407 | 5.043 | 24.65 | 8.78 |
| 229 | 122 | 12 | 37.592 | 41.463 | 13.764 | 43.12 | 21.2 |
| 62 | 161 | 12 | 60.1 | 60.169 | 10.49 | 42.53 | 10.97 |
| 43 | 153 | 12 | 25.65 | 32.876 | 9.872 | 32.71 | 20.27 |