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 |
|---|---|---|---|---|---|---|---|
| 87 | 221 | 20 | 24.692 | 29.567 | 13.054 | 37.58 | 28.35 |
| 10 | 25 | 20 | 65.783 | 60.314 | 14.725 | 51.28 | 16.51 |
| 36 | 260 | 20 | 13.65 | 15.231 | 4.027 | 14.78 | 16.38 |
| 119 | 174 | 20 | 19.475 | 22.177 | 6.748 | 23 | 20.32 |
| 69 | 200 | 20 | 24.675 | 25.94 | 7.564 | 26.21 | 18.09 |
| 216 | 177 | 20 | 27.233 | 28.777 | 7.582 | 26.18 | 16.65 |
| 134 | 247 | 20 | 37.55 | 39.149 | 13.799 | 40.9 | 21.89 |
| 11 | 162 | 20 | 79 | 77.128 | 27.511 | 83.44 | 22.26 |
| 4 | 72 | 20 | 44.817 | 47.013 | 9.566 | 36.48 | 12.54 |
| 131 | 132 | 20 | 19.892 | 20.594 | 8.364 | 25.8 | 24.73 |
| 242 | 31 | 20 | 13.533 | 14.915 | 2.74 | 12.7 | 11.53 |
| 41 | 91 | 20 | 52.292 | 59.497 | 21.241 | 63.39 | 22.75 |
| 142 | 59 | 20 | 38.5 | 38.247 | 10.022 | 33.81 | 17.47 |
| 219 | 244 | 20 | 45.217 | 51.606 | 18.742 | 53 | 25.29 |
| 189 | 262 | 20 | 28.417 | 31.962 | 9.751 | 32.3 | 19.96 |
| 15 | 9 | 20 | 11.558 | 12.395 | 2.469 | 11.45 | 12.79 |
| 123 | 71 | 20 | 23.683 | 24.887 | 4.307 | 18.72 | 10.56 |
| 164 | 206 | 20 | 50.242 | 51.274 | 18.987 | 56.52 | 23.45 |
| 92 | 230 | 20 | 38.158 | 42.972 | 11.479 | 40.15 | 17.81 |
| 67 | 68 | 20 | 39.508 | 37.328 | 10.774 | 34.89 | 17.87 |
| 254 | 195 | 20 | 57.35 | 60.053 | 22.738 | 66.7 | 23.39 |
| 28 | 24 | 20 | 29.575 | 32.667 | 13.995 | 52.02 | 26.9 |
| 233 | 215 | 20 | 48.692 | 46.998 | 14.479 | 45.09 | 21.23 |
| 212 | 42 | 20 | 27.742 | 27.003 | 5.226 | 20.76 | 12.44 |
| 4 | 200 | 20 | 32.292 | 41.205 | 16.083 | 48.39 | 28.87 |