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 |
|---|---|---|---|---|---|---|---|
| 9 | 73 | 33 | 12 | 13.508 | 2.449 | 12.95 | 11.74 |
| 236 | 22 | 33 | 50.333 | 50.2 | 17.103 | 51.45 | 20.96 |
| 62 | 165 | 33 | 21.533 | 22.299 | 4.098 | 17.51 | 12.2 |
| 193 | 238 | 33 | 19.117 | 23.802 | 4.59 | 20.36 | 12.67 |
| 235 | 231 | 33 | 46.45 | 48.312 | 13.369 | 43.88 | 17.36 |
| 74 | 228 | 33 | 34.85 | 36.861 | 14.055 | 42.21 | 24.56 |
| 258 | 25 | 33 | 49.633 | 49.284 | 8.253 | 32.54 | 10.33 |
| 33 | 168 | 33 | 29.117 | 31.099 | 11.832 | 35.13 | 24.14 |
| 174 | 185 | 33 | 14.267 | 15.955 | 3.561 | 14.53 | 14.62 |
| 33 | 247 | 33 | 34.2 | 37.77 | 12.998 | 39.52 | 22.04 |
| 89 | 246 | 33 | 35.867 | 37.212 | 9.573 | 32.11 | 16.57 |
| 38 | 16 | 33 | 19.833 | 19.151 | 5.944 | 20.86 | 19 |
| 234 | 218 | 33 | 49.667 | 52.992 | 17.22 | 52.46 | 21.77 |
| 223 | 66 | 33 | 24.7 | 29.912 | 9.54 | 29.56 | 21.39 |
| 165 | 230 | 33 | 44.617 | 45.587 | 12.627 | 42.07 | 17.32 |
| 216 | 122 | 33 | 28.117 | 28.399 | 5.485 | 21.89 | 12.07 |
| 41 | 197 | 33 | 36.55 | 40.001 | 13.983 | 43.44 | 22.84 |
| 237 | 8 | 33 | 19.517 | 20.443 | 5.541 | 21.44 | 16.86 |
| 189 | 263 | 33 | 34.7 | 33.969 | 9.948 | 32.91 | 18.69 |
| 7 | 189 | 33 | 29.95 | 32.435 | 9.352 | 30.7 | 18.2 |
| 228 | 117 | 33 | 42.433 | 45.111 | 21.659 | 60.09 | 29.49 |
| 210 | 181 | 33 | 31.267 | 33.501 | 9.581 | 31.51 | 18.52 |
| 173 | 93 | 33 | 7.35 | 11.815 | 2.717 | 11.32 | 16.06 |
| 18 | 209 | 33 | 51.883 | 52.066 | 17.887 | 49.57 | 20.9 |
| 113 | 208 | 33 | 34.95 | 38.512 | 14.259 | 42.76 | 24.08 |