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 |
|---|---|---|---|---|---|---|---|
| 91 | 181 | 66 | 31.975 | 32.53 | 5.929 | 24.31 | 11.51 |
| 50 | 21 | 66 | 34.808 | 38.1 | 13.955 | 42.48 | 22.73 |
| 39 | 33 | 65 | 47.8 | 49.751 | 9.736 | 35.2 | 12.33 |
| 129 | 148 | 65 | 19.083 | 22.591 | 7.663 | 25.05 | 23.52 |
| 157 | 249 | 65 | 23.967 | 26.397 | 7.318 | 48.33 | 18.34 |
| 163 | 51 | 65 | 35.967 | 38.441 | 15.147 | 45.08 | 25.54 |
| 170 | 201 | 65 | 50.317 | 52.478 | 23.713 | 67.14 | 28.09 |
| 72 | 177 | 65 | 12.233 | 12.769 | 2.066 | 10.52 | 10.28 |
| 193 | 50 | 65 | 22.717 | 25.018 | 4.262 | 19.01 | 11.23 |
| 158 | 70 | 65 | 41.617 | 43.608 | 12.704 | 41.96 | 19.6 |
| 90 | 130 | 65 | 41.067 | 44.478 | 14.023 | 44.34 | 20.84 |
| 43 | 213 | 65 | 27.4 | 30.86 | 8.957 | 29.69 | 18.96 |
| 144 | 76 | 65 | 41.25 | 43.599 | 10.803 | 36.51 | 16.14 |
| 231 | 174 | 65 | 46.733 | 47.864 | 17.652 | 53.11 | 23.02 |
| 17 | 170 | 65 | 33.1 | 32.92 | 7.685 | 28.18 | 15.05 |
| 148 | 259 | 65 | 31.95 | 33.332 | 16.962 | 47.63 | 31.88 |
| 216 | 218 | 65 | 14.933 | 15.933 | 3.711 | 14.77 | 14.76 |
| 167 | 147 | 65 | 6.75 | 8.28 | 1.096 | 7.24 | 8.93 |
| 112 | 75 | 65 | 22.133 | 24.496 | 6.746 | 23.18 | 17.67 |
| 196 | 186 | 65 | 28.617 | 29.012 | 7.997 | 45.35 | 18.74 |
| 129 | 246 | 65 | 26.183 | 29.475 | 7.886 | 27.02 | 16.74 |
| 198 | 95 | 65 | 19.233 | 19.658 | 4.039 | 16.36 | 12.86 |
| 166 | 20 | 65 | 27.633 | 27.229 | 8.066 | 26.78 | 18.71 |
| 61 | 88 | 65 | 26.167 | 28.782 | 5.984 | 24.13 | 13.17 |
| 88 | 21 | 65 | 28.933 | 29.711 | 10.212 | 31.62 | 21.44 |