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 |
|---|---|---|---|---|---|---|---|
| 209 | 150 | 14 | 34.992 | 36.87 | 15.242 | 44.62 | 26.55 |
| 51 | 166 | 14 | 39.983 | 40.84 | 12.86 | 40.13 | 21.09 |
| 239 | 175 | 14 | 46.608 | 47.893 | 18.787 | 55.33 | 25.12 |
| 63 | 17 | 14 | 23.55 | 26.58 | 5.213 | 20.76 | 11.88 |
| 202 | 18 | 14 | 36.617 | 47.304 | 13.049 | 43.5 | 18.38 |
| 254 | 167 | 14 | 31.892 | 34.48 | 6.522 | 25.9 | 12.75 |
| 40 | 71 | 14 | 26.242 | 27.129 | 4.864 | 20.68 | 11.29 |
| 78 | 183 | 14 | 18.15 | 18.365 | 4.662 | 17.73 | 15.59 |
| 24 | 228 | 14 | 40.725 | 43.401 | 13.776 | 43.36 | 19.99 |
| 41 | 134 | 14 | 42.008 | 41.852 | 13.565 | 45.71 | 21.1 |
| 87 | 84 | 14 | 44.742 | 44.6 | 22.853 | 63 | 31.78 |
| 229 | 81 | 14 | 36.217 | 38.774 | 14.29 | 42.86 | 24.41 |
| 203 | 86 | 14 | 19.508 | 20.521 | 4.895 | 18.61 | 14.9 |
| 216 | 198 | 14 | 23.442 | 27.365 | 7.88 | 26.29 | 17.73 |
| 178 | 210 | 14 | 17.417 | 18.787 | 3.176 | 14.68 | 10.4 |
| 130 | 80 | 14 | 28.067 | 31.846 | 11.711 | 40.3 | 24.7 |
| 20 | 74 | 14 | 22.425 | 25.402 | 6.963 | 24.07 | 17.56 |
| 243 | 114 | 14 | 33.558 | 35.521 | 11.19 | 35.56 | 19.77 |
| 212 | 137 | 14 | 25.775 | 32.152 | 10.974 | 32.89 | 23.37 |
| 203 | 97 | 14 | 58.008 | 60.438 | 14.066 | 48.36 | 14.53 |
| 55 | 26 | 14 | 29.217 | 30.995 | 7.178 | 25.99 | 14.31 |
| 18 | 166 | 14 | 29.4 | 32.08 | 8.263 | 28.86 | 16.58 |
| 174 | 208 | 14 | 21.233 | 22.782 | 7.763 | 25.06 | 22.36 |
| 263 | 124 | 14 | 46.9 | 49.87 | 18.395 | 52.36 | 23.44 |
| 188 | 13 | 14 | 32.867 | 33.708 | 6.513 | 29.64 | 11.87 |