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 |
|---|---|---|---|---|---|---|---|
| 127 | 92 | 4 | 28.033 | 29.708 | 14.385 | 41.5 | 29.56 |
| 209 | 9 | 4 | 39.333 | 39.533 | 15.343 | 43.62 | 23.7 |
| 129 | 182 | 4 | 22.417 | 20.587 | 10.21 | 29.75 | 30.85 |
| 119 | 193 | 4 | 25.042 | 24.321 | 9.28 | 26.26 | 23.14 |
| 22 | 215 | 4 | 64.833 | 64.517 | 19.073 | 55.72 | 17.83 |
| 7 | 128 | 4 | 32.333 | 36.675 | 9.765 | 33.88 | 17.05 |
| 175 | 38 | 4 | 18.642 | 19.412 | 7.01 | 22.12 | 21.52 |
| 108 | 56 | 4 | 47.8 | 47.712 | 17.508 | 48.12 | 22.04 |
| 17 | 173 | 4 | 22.025 | 33.433 | 10.232 | 33.5 | 22.03 |
| 215 | 175 | 4 | 25.808 | 26.329 | 7.143 | 25.46 | 16.24 |
| 122 | 136 | 4 | 57.908 | 55.775 | 18.365 | 56.25 | 21.18 |
| 213 | 13 | 4 | 50.383 | 45.733 | 17.142 | 48.14 | 23.67 |
| 247 | 228 | 4 | 78.208 | 82.112 | 16.5 | 59.62 | 12.18 |
| 71 | 108 | 4 | 34.108 | 35.079 | 8.277 | 28.09 | 14.55 |
| 180 | 17 | 4 | 38.467 | 39.746 | 14.545 | 44.38 | 21.73 |
| 96 | 138 | 4 | 22.075 | 21.608 | 9.353 | 26.88 | 26.69 |
| 14 | 251 | 4 | 17.058 | 15.629 | 7.243 | 22.25 | 29.67 |
| 94 | 261 | 4 | 46.283 | 53.683 | 16.575 | 52.5 | 19.74 |
| 78 | 237 | 4 | 39.883 | 40.9 | 9.045 | 32.25 | 13.96 |
| 55 | 124 | 4 | 28.158 | 37.679 | 11.762 | 37 | 24.07 |
| 149 | 214 | 4 | 33.733 | 32.812 | 11.66 | 37.23 | 21.41 |
| 225 | 151 | 4 | 41.342 | 41.8 | 11.38 | 38 | 17.23 |
| 219 | 248 | 4 | 57.892 | 51.096 | 19.3 | 58.75 | 27.53 |
| 244 | 184 | 4 | 31.433 | 29.242 | 9.595 | 30.75 | 21.63 |
| 94 | 142 | 4 | 39.183 | 41.475 | 9.52 | 34.97 | 16.3 |