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 |
|---|---|---|---|---|---|---|---|
| 240 | 18 | 5 | 10.2 | 10.943 | 1.66 | 9.1 | 9.75 |
| 95 | 38 | 5 | 28.55 | 30.23 | 8.814 | 29.3 | 18.53 |
| 252 | 238 | 5 | 35.033 | 38.513 | 12.546 | 42.46 | 22.3 |
| 61 | 235 | 5 | 55.283 | 55.06 | 19.96 | 61.2 | 22.52 |
| 43 | 11 | 5 | 64.45 | 62.16 | 18.516 | 58.2 | 18.06 |
| 224 | 248 | 5 | 24.55 | 32.577 | 13.036 | 38.4 | 24.59 |
| 39 | 178 | 5 | 26.117 | 29.513 | 6.254 | 24.4 | 13.65 |
| 169 | 185 | 5 | 23.667 | 35.673 | 6.022 | 26.9 | 11.85 |
| 56 | 236 | 5 | 23.983 | 22.303 | 7.516 | 38.3 | 18.76 |
| 36 | 149 | 5 | 30.55 | 39.003 | 10.138 | 33.74 | 16.67 |
| 134 | 83 | 5 | 17.883 | 18.97 | 7.144 | 22.8 | 24.65 |
| 37 | 60 | 5 | 37.233 | 40.307 | 17.098 | 51.1 | 25.84 |
| 191 | 258 | 5 | 32.167 | 29.503 | 9.888 | 32.25 | 20.66 |
| 149 | 244 | 5 | 64.533 | 64.143 | 21.904 | 65.04 | 20.96 |
| 14 | 226 | 5 | 53.2 | 45.137 | 13.294 | 42.2 | 19.95 |
| 98 | 10 | 5 | 24.95 | 25.673 | 5.134 | 20.2 | 12.12 |
| 139 | 222 | 5 | 20.667 | 25.08 | 8.594 | 27.08 | 23.55 |
| 260 | 78 | 5 | 24.867 | 26.527 | 11.268 | 34.1 | 25.26 |
| 185 | 141 | 5 | 45.85 | 43.75 | 10.866 | 36.9 | 17.65 |
| 56 | 36 | 5 | 21.967 | 23.04 | 7.75 | 24.3 | 20.36 |
| 167 | 114 | 5 | 44.95 | 45.43 | 11.716 | 38.6 | 16.48 |
| 195 | 149 | 5 | 26.783 | 31.947 | 10.05 | 32.1 | 19.4 |
| 247 | 184 | 5 | 16.667 | 20.723 | 9.956 | 29.4 | 31.6 |
| 214 | 23 | 5 | 27.333 | 24.947 | 5.416 | 20.1 | 12.69 |
| 14 | 115 | 5 | 11.267 | 16.66 | 5.928 | 19.9 | 25.17 |