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 |
|---|---|---|---|---|---|---|---|
| 101 | 10 | 5 | 25 | 25.737 | 11.188 | 33.26 | 26.83 |
| 223 | 254 | 5 | 27.233 | 27.973 | 11.04 | 32.5 | 26.13 |
| 41 | 187 | 5 | 51.5 | 52.88 | 26.972 | 74.8 | 30.76 |
| 137 | 57 | 5 | 38.533 | 39.98 | 8.956 | 33.2 | 15.85 |
| 241 | 185 | 5 | 18.867 | 18.737 | 3.588 | 15.4 | 11.51 |
| 108 | 196 | 5 | 42.917 | 42.1 | 17.068 | 47.14 | 25.23 |
| 85 | 227 | 5 | 21.85 | 22.99 | 4.018 | 17.7 | 10.66 |
| 166 | 98 | 5 | 45.2 | 42.99 | 15.058 | 47.06 | 21.15 |
| 153 | 247 | 5 | 17.367 | 19.217 | 4.688 | 17.6 | 15.16 |
| 158 | 98 | 5 | 30.583 | 31.787 | 15.676 | 45.1 | 30.23 |
| 66 | 197 | 5 | 46.317 | 43.343 | 12.048 | 40.3 | 17.68 |
| 211 | 64 | 5 | 40.433 | 39.673 | 18.66 | 53.4 | 28.88 |
| 174 | 205 | 5 | 47.1 | 49.38 | 18.79 | 54.29 | 24.83 |
| 146 | 253 | 5 | 16.417 | 16.233 | 6.42 | 20.4 | 24.58 |
| 134 | 181 | 5 | 46.217 | 44.673 | 12.08 | 40.1 | 16.23 |
| 65 | 200 | 5 | 38.85 | 40.053 | 17.19 | 49.3 | 26.43 |
| 124 | 136 | 5 | 37.217 | 48.7 | 22.85 | 63.54 | 31.15 |
| 225 | 250 | 5 | 31.5 | 40.073 | 16.032 | 47.04 | 27.62 |
| 39 | 198 | 5 | 32.267 | 34.06 | 6.228 | 26.34 | 11.04 |
| 126 | 107 | 5 | 45.9 | 54.94 | 10.258 | 41.3 | 13.93 |
| 231 | 96 | 5 | 40.683 | 38.167 | 11.472 | 37.2 | 20.81 |
| 218 | 167 | 5 | 43.817 | 45.297 | 20.016 | 57.5 | 27.74 |
| 18 | 3 | 5 | 17.017 | 20.753 | 3.142 | 16 | 10.81 |
| 35 | 51 | 5 | 39.583 | 38.497 | 19.996 | 54.66 | 31.94 |
| 10 | 62 | 5 | 43.75 | 41.393 | 10.864 | 37.2 | 16.12 |