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 |
|---|---|---|---|---|---|---|---|
| 88 | 36 | 233 | 29.217 | 31 | 7.125 | 26.15 | 14.54 |
| 142 | 194 | 233 | 26.633 | 28.826 | 6.946 | 28.9 | 15.26 |
| 100 | 134 | 232 | 35.742 | 39.639 | 11.824 | 39.62 | 19.83 |
| 142 | 159 | 232 | 23.925 | 26.85 | 6.618 | 23.64 | 15.94 |
| 151 | 47 | 232 | 24.158 | 25.451 | 7.456 | 25.19 | 19.16 |
| 179 | 48 | 232 | 23.408 | 25.862 | 5.103 | 21.01 | 13.02 |
| 87 | 127 | 232 | 30.6 | 33.178 | 13.925 | 40.84 | 27.39 |
| 49 | 89 | 232 | 17.867 | 20.259 | 3.856 | 16.1 | 11.99 |
| 125 | 223 | 232 | 32.567 | 34.111 | 9.775 | 32.63 | 18.62 |
| 230 | 20 | 232 | 31.883 | 33.612 | 12.246 | 37.69 | 23.37 |
| 141 | 241 | 232 | 22.592 | 25.128 | 9.593 | 29.23 | 25.12 |
| 246 | 247 | 232 | 27.717 | 30.25 | 9.207 | 30.53 | 20.1 |
| 236 | 160 | 232 | 34.042 | 36.277 | 8.337 | 30.6 | 14.96 |
| 261 | 26 | 232 | 22.842 | 25.212 | 7.321 | 24.71 | 18.89 |
| 246 | 54 | 232 | 25.25 | 27.28 | 6.806 | 24.21 | 15.99 |
| 4 | 36 | 232 | 24.55 | 26.141 | 5.772 | 22.08 | 13.82 |
| 100 | 173 | 232 | 34.142 | 35.802 | 9.226 | 32.27 | 16.49 |
| 100 | 248 | 231 | 30.95 | 32.819 | 12.113 | 37.05 | 23.68 |
| 181 | 232 | 231 | 16.3 | 17.358 | 4.017 | 15.76 | 14.53 |
| 186 | 123 | 231 | 43.217 | 45.37 | 13.731 | 43.85 | 18.84 |
| 52 | 249 | 231 | 21.983 | 22.594 | 4.552 | 18.45 | 12.78 |
| 65 | 69 | 231 | 42.267 | 44.133 | 12.676 | 40.22 | 19.62 |
| 24 | 247 | 231 | 18.933 | 19.392 | 3.721 | 15.89 | 12.12 |
| 48 | 258 | 231 | 41.4 | 44.038 | 12.074 | 40.52 | 17.53 |
| 52 | 68 | 231 | 25.967 | 27.091 | 5.858 | 22.52 | 13.7 |