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 |
|---|---|---|---|---|---|---|---|
| 158 | 10 | 28 | 45.392 | 47.081 | 17.523 | 52.14 | 23.24 |
| 162 | 38 | 28 | 51.792 | 54.613 | 18.871 | 56.46 | 22.61 |
| 12 | 55 | 28 | 37.792 | 39.103 | 14.117 | 42.42 | 22.88 |
| 222 | 77 | 28 | 11.225 | 12.643 | 1.865 | 10.3 | 10.14 |
| 39 | 186 | 28 | 42.567 | 45.828 | 14.031 | 40.82 | 18.82 |
| 246 | 172 | 28 | 42.433 | 44.104 | 18.094 | 52.66 | 25.13 |
| 226 | 51 | 28 | 40.092 | 41.376 | 15.074 | 45.18 | 23.11 |
| 36 | 75 | 28 | 31.458 | 33.539 | 10.876 | 34.37 | 20.17 |
| 69 | 185 | 28 | 28.542 | 30.355 | 6.522 | 24.91 | 14.11 |
| 257 | 106 | 28 | 9.633 | 10.418 | 1.891 | 9.55 | 11.78 |
| 260 | 192 | 28 | 16.867 | 18.717 | 7.243 | 22.67 | 24.63 |
| 243 | 20 | 28 | 19.342 | 21.205 | 4.111 | 17.63 | 12.66 |
| 8 | 140 | 28 | 18.842 | 18.727 | 5.277 | 38.29 | 22.29 |
| 10 | 223 | 28 | 30.65 | 33.624 | 12.183 | 36.62 | 24.8 |
| 196 | 50 | 28 | 30.925 | 32.644 | 9.251 | 47.66 | 18.55 |
| 32 | 186 | 28 | 71.333 | 69.393 | 15.661 | 55.77 | 14.46 |
| 135 | 48 | 28 | 32.717 | 35.967 | 12.481 | 42.02 | 21.88 |
| 232 | 135 | 28 | 31.933 | 32.249 | 11.774 | 35.49 | 23.98 |
| 202 | 137 | 28 | 23.767 | 23.261 | 4.778 | 18.78 | 12.79 |
| 81 | 42 | 28 | 30.883 | 31.537 | 10.9 | 33.81 | 22.84 |
| 152 | 248 | 28 | 20.25 | 23.073 | 7.368 | 23.93 | 22.41 |
| 61 | 113 | 28 | 35.133 | 37.276 | 6.413 | 26.98 | 11.34 |
| 238 | 56 | 28 | 33.483 | 34.966 | 11.683 | 36.86 | 21.2 |
| 77 | 37 | 28 | 17.892 | 19.459 | 3.074 | 14.21 | 10.22 |
| 161 | 96 | 28 | 34.25 | 40.285 | 11.683 | 38.51 | 19.72 |