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 |
|---|---|---|---|---|---|---|---|
| 55 | 262 | 2 | 68.658 | 68.658 | 21.86 | 67.5 | 19.84 |
| 47 | 56 | 2 | 24.75 | 24.75 | 13.845 | 38.25 | 33.58 |
| 4 | 30 | 2 | 41.242 | 41.242 | 20.425 | 57.5 | 31.23 |
| 154 | 72 | 2 | 19.992 | 19.992 | 4.7 | 18 | 13.96 |
| 58 | 237 | 2 | 56.408 | 56.408 | 10.965 | 41.75 | 11.65 |
| 133 | 183 | 2 | 30.567 | 30.567 | 22.1 | 58.5 | 44.16 |
| 23 | 70 | 2 | 74.708 | 74.708 | 27.895 | 80.75 | 22.48 |
| 189 | 81 | 2 | 56.392 | 56.392 | 23.965 | 70 | 27.88 |
| 3 | 143 | 2 | 68.167 | 68.167 | 15.02 | 55.25 | 13.23 |
| 173 | 89 | 2 | 36.833 | 36.833 | 15.88 | 45.5 | 25.87 |
| 205 | 209 | 2 | 57.283 | 57.283 | 19.295 | 57.29 | 20.26 |
| 250 | 62 | 2 | 54.292 | 54.292 | 18.245 | 56.5 | 20.21 |
| 209 | 101 | 2 | 49.208 | 49.208 | 21.985 | 61 | 27.29 |
| 172 | 6 | 2 | 9.117 | 9.117 | 2.465 | 9.75 | 17.04 |
| 81 | 97 | 2 | 64.742 | 64.742 | 22.185 | 62.08 | 23.61 |
| 91 | 93 | 2 | 41.958 | 41.958 | 16.235 | 48.5 | 23.15 |
| 73 | 166 | 2 | 57.158 | 57.158 | 14.085 | 48.75 | 14.81 |
| 129 | 108 | 2 | 36.683 | 36.683 | 18.98 | 53.25 | 30.94 |
| 72 | 218 | 2 | 28.308 | 28.308 | 9.6 | 30.16 | 20.39 |
| 184 | 90 | 2 | 30.642 | 30.642 | 9.02 | 30.75 | 15.7 |
| 85 | 198 | 2 | 36.475 | 36.475 | 6.3 | 25.5 | 10.82 |
| 153 | 10 | 2 | 79.533 | 79.533 | 21.04 | 67.75 | 16 |
| 53 | 80 | 2 | 19.525 | 19.525 | 9.165 | 26.5 | 28.17 |
| 13 | 30 | 2 | 60.958 | 60.958 | 26.19 | 73.5 | 26.25 |
| 94 | 232 | 2 | 35.033 | 35.033 | 13.26 | 39.25 | 23.08 |