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 |
|---|---|---|---|---|---|---|---|
| 153 | 24 | 1 | 22.4 | 22.4 | 7.21 | 23 | 19.31 |
| 15 | 61 | 1 | 31.183 | 31.183 | 15.16 | 43 | 29.17 |
| 56 | 247 | 1 | 29 | 29 | 10.94 | 33.5 | 22.63 |
| 126 | 256 | 1 | 29.817 | 29.817 | 13.12 | 38.5 | 26.4 |
| 19 | 117 | 1 | 28.533 | 28.533 | 17.48 | 48.5 | 36.76 |
| 175 | 42 | 1 | 23.833 | 23.833 | 14.32 | 37.26 | 36.05 |
| 223 | 150 | 1 | 52 | 52 | 23.3 | 64 | 26.88 |
| 96 | 248 | 1 | 27.217 | 27.217 | 19 | 51 | 41.89 |
| 125 | 176 | 1 | 35.833 | 35.833 | 20.16 | 55 | 33.76 |
| 224 | 203 | 1 | 27.017 | 27.017 | 19.58 | 52.5 | 43.48 |
| 252 | 201 | 1 | 48.983 | 48.983 | 29.21 | 77.47 | 35.78 |
| 135 | 108 | 1 | 71.633 | 71.633 | 21.91 | 66 | 18.35 |
| 55 | 157 | 1 | 21.867 | 21.867 | 17.59 | 46.5 | 48.27 |
| 21 | 206 | 1 | 27.367 | 27.367 | 10.44 | 31.5 | 22.89 |
| 167 | 220 | 1 | 32.883 | 32.883 | 6.81 | 27 | 12.43 |
| 83 | 139 | 1 | 29.583 | 29.583 | 13.03 | 37 | 26.43 |
| 227 | 139 | 1 | 54.333 | 54.333 | 27.47 | 74.5 | 30.33 |
| 147 | 80 | 1 | 30.5 | 30.5 | 10.78 | 32.5 | 21.21 |
| 124 | 246 | 1 | 56.767 | 56.767 | 29 | 77.5 | 30.65 |
| 92 | 24 | 1 | 31.567 | 31.567 | 10.87 | 36.58 | 20.66 |
| 119 | 210 | 1 | 76.417 | 76.417 | 30.82 | 87 | 24.2 |
| 215 | 212 | 1 | 23.233 | 23.233 | 12.5 | 34.5 | 32.28 |
| 185 | 179 | 1 | 19.55 | 19.55 | 9.18 | 28 | 28.17 |
| 212 | 98 | 1 | 32.667 | 32.667 | 12.83 | 39.5 | 23.57 |
| 194 | 167 | 1 | 21.05 | 21.05 | 3.7 | 16 | 10.55 |