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 |
|---|---|---|---|---|---|---|---|
| 143 | 235 | 99 | 22.4 | 24.298 | 8.185 | 26.29 | 22.65 |
| 239 | 225 | 99 | 46.9 | 48.25 | 10.607 | 38.78 | 13.77 |
| 140 | 130 | 99 | 42.433 | 44.868 | 14.377 | 45.24 | 21.3 |
| 140 | 192 | 99 | 29.35 | 31.277 | 12.066 | 36.65 | 24.86 |
| 186 | 124 | 99 | 46.35 | 49.772 | 15.832 | 50.17 | 20.58 |
| 195 | 75 | 99 | 36.767 | 38.027 | 13.218 | 39.98 | 21.61 |
| 97 | 130 | 99 | 32.967 | 36.58 | 13.759 | 41.35 | 24.63 |
| 24 | 129 | 99 | 29.267 | 30.913 | 7.986 | 28.18 | 16.33 |
| 231 | 167 | 99 | 40.033 | 44.232 | 12.697 | 40.74 | 19.58 |
| 139 | 205 | 99 | 9.367 | 10.1 | 1.684 | 8.93 | 10.76 |
| 68 | 72 | 99 | 46.833 | 49.686 | 10.977 | 39.43 | 14.05 |
| 141 | 121 | 99 | 31.383 | 34.143 | 13.108 | 39.08 | 24.66 |
| 157 | 260 | 99 | 8.183 | 9.092 | 1.781 | 13.18 | 19.01 |
| 25 | 143 | 99 | 34.283 | 36.104 | 8.167 | 30.24 | 14.14 |
| 112 | 186 | 99 | 25.567 | 28.174 | 5.2 | 21.82 | 12.24 |
| 236 | 31 | 99 | 27.467 | 29.054 | 9.51 | 30.36 | 20.88 |
| 48 | 63 | 99 | 48.8 | 51.311 | 13.268 | 44.44 | 17.02 |
| 161 | 35 | 99 | 46.45 | 50.655 | 13.178 | 43.55 | 16.9 |
| 61 | 77 | 98 | 16.975 | 18.087 | 3.327 | 14.5 | 11.73 |
| 164 | 34 | 98 | 29.05 | 30.674 | 6.553 | 25.2 | 13.76 |
| 142 | 167 | 98 | 26.858 | 28.658 | 8.957 | 29.14 | 20.19 |
| 215 | 262 | 98 | 31.908 | 33.615 | 14.706 | 51.68 | 29.16 |
| 142 | 135 | 98 | 40.2 | 41.982 | 12.998 | 41.67 | 19.86 |
| 225 | 33 | 98 | 30.575 | 29.417 | 4.172 | 20.04 | 9.14 |
| 145 | 181 | 98 | 29.317 | 31.229 | 8.114 | 28.24 | 16.94 |