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 |
|---|---|---|---|---|---|---|---|
| 77 | 115 | 6 | 48.058 | 48.178 | 19.725 | 59 | 26.69 |
| 9 | 17 | 6 | 21.367 | 25.169 | 12.673 | 36.83 | 31.75 |
| 83 | 166 | 6 | 41.708 | 41.031 | 8.98 | 32.13 | 13.81 |
| 178 | 234 | 6 | 48.592 | 54.642 | 12.02 | 41.17 | 13.83 |
| 174 | 243 | 6 | 25.425 | 26.333 | 5.88 | 21.25 | 14.65 |
| 153 | 76 | 6 | 41.233 | 42.017 | 23.395 | 61.75 | 33.58 |
| 136 | 48 | 6 | 37.625 | 39.817 | 11.3 | 37.06 | 17.62 |
| 242 | 65 | 6 | 41.558 | 52.758 | 17.773 | 54.92 | 22.52 |
| 3 | 69 | 6 | 29.008 | 31.475 | 8.043 | 28.17 | 16.25 |
| 249 | 203 | 6 | 36.933 | 41.969 | 21.185 | 58.67 | 32.5 |
| 81 | 230 | 6 | 48.342 | 51.344 | 16.273 | 51.92 | 21.06 |
| 98 | 93 | 5 | 6.883 | 6.527 | 3.228 | 10.8 | 31.97 |
| 123 | 77 | 5 | 34.283 | 33.203 | 7.544 | 29.65 | 13.87 |
| 254 | 49 | 5 | 54 | 58.407 | 22.228 | 64.5 | 24.8 |
| 219 | 195 | 5 | 47.067 | 47.06 | 21.074 | 58.35 | 28.77 |
| 67 | 261 | 5 | 36.283 | 35.813 | 9.07 | 38.3 | 19.6 |
| 124 | 211 | 5 | 47.333 | 43.87 | 14.532 | 52 | 20.89 |
| 80 | 218 | 5 | 36.217 | 46.1 | 16.462 | 51.5 | 25.96 |
| 203 | 88 | 5 | 58.517 | 60.903 | 23.54 | 72.28 | 23.77 |
| 222 | 164 | 5 | 55.217 | 56.187 | 16.668 | 53.76 | 19.62 |
| 248 | 235 | 5 | 20.083 | 21.923 | 3.43 | 15.9 | 9.9 |
| 92 | 232 | 5 | 35.05 | 39.337 | 14.624 | 43.7 | 24.33 |
| 219 | 65 | 5 | 70.55 | 56.993 | 15.322 | 55.2 | 21.21 |
| 171 | 70 | 5 | 11.117 | 11.213 | 3.052 | 11.9 | 16.84 |
| 123 | 74 | 5 | 76.633 | 80.653 | 18.79 | 66 | 14.44 |