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 |
|---|---|---|---|---|---|---|---|
| 247 | 119 | 303 | 5.8 | 7.498 | 1.263 | 7.12 | 11.63 |
| 66 | 163 | 303 | 28.917 | 30.73 | 7.405 | 26.85 | 15.48 |
| 25 | 133 | 303 | 14.4 | 15.955 | 4.48 | 16.2 | 18.11 |
| 68 | 119 | 303 | 25.233 | 28.554 | 9.717 | 30.91 | 22.34 |
| 40 | 186 | 302 | 23.425 | 26.613 | 6.29 | 22.94 | 15.28 |
| 244 | 262 | 302 | 24.725 | 25.4 | 6.227 | 22.8 | 16.4 |
| 164 | 62 | 302 | 34.008 | 36.172 | 8.593 | 30.63 | 14.97 |
| 66 | 61 | 302 | 20.708 | 21.979 | 3.987 | 17.19 | 11.35 |
| 263 | 196 | 302 | 26.933 | 28.309 | 9.021 | 29.25 | 20.06 |
| 79 | 160 | 302 | 23.667 | 25.588 | 8.393 | 27.3 | 21.54 |
| 161 | 135 | 302 | 32.358 | 35.108 | 11.491 | 36.51 | 21.34 |
| 238 | 25 | 302 | 35.9 | 37.586 | 10.39 | 34.64 | 17.54 |
| 74 | 114 | 301 | 22.45 | 24.74 | 7.656 | 25.16 | 20.19 |
| 186 | 167 | 301 | 35.133 | 38.006 | 10.028 | 34.15 | 17.13 |
| 4 | 49 | 301 | 22.267 | 23.246 | 5.286 | 20.05 | 14.21 |
| 230 | 169 | 301 | 25.867 | 28.505 | 9.91 | 31.17 | 23.12 |
| 230 | 197 | 301 | 41.6 | 45.591 | 13.016 | 43.1 | 19 |
| 41 | 232 | 301 | 27.267 | 28.658 | 8.461 | 28.08 | 19.52 |
| 12 | 229 | 301 | 18.8 | 21.004 | 5.957 | 20.79 | 18.7 |
| 140 | 62 | 300 | 41.875 | 43.006 | 10.752 | 36.54 | 16.31 |
| 226 | 113 | 300 | 22.733 | 24.258 | 5.254 | 31.87 | 14.36 |
| 10 | 262 | 300 | 33.867 | 35.627 | 15.786 | 52.01 | 28.96 |
| 209 | 225 | 300 | 26.875 | 28.613 | 5.621 | 22.1 | 12.67 |
| 10 | 87 | 300 | 45.167 | 47.79 | 17.738 | 51.99 | 24.54 |
| 230 | 182 | 300 | 32.042 | 35.263 | 12.202 | 37.99 | 22.56 |