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 |
|---|---|---|---|---|---|---|---|
| 248 | 186 | 1 | 16.867 | 16.867 | 5.27 | 18.5 | 18.75 |
| 168 | 214 | 1 | 61.933 | 61.933 | 23.35 | 70 | 22.62 |
| 4 | 187 | 1 | 37.983 | 37.983 | 20.4 | 56 | 32.22 |
| 131 | 186 | 1 | 58.017 | 58.017 | 13.93 | 48 | 14.41 |
| 174 | 117 | 1 | 103.2 | 103.2 | 35.4 | 105.5 | 20.58 |
| 135 | 115 | 1 | 103.267 | 103.267 | 38.13 | 114 | 22.15 |
| 235 | 195 | 1 | 53.983 | 53.983 | 19.13 | 60 | 21.26 |
| 247 | 135 | 1 | 26.45 | 26.45 | 13.46 | 39 | 30.53 |
| 147 | 208 | 1 | 15.083 | 15.083 | 6.17 | 19 | 24.54 |
| 15 | 260 | 1 | 16.483 | 16.483 | 8.7 | 25.5 | 31.67 |
| 53 | 234 | 1 | 47.933 | 47.933 | 12.6 | 43 | 15.77 |
| 58 | 232 | 1 | 42.217 | 42.217 | 15.97 | 47 | 22.7 |
| 214 | 221 | 1 | 11.1 | 11.1 | 3.49 | 11.5 | 18.86 |
| 85 | 126 | 1 | 35.9 | 35.9 | 15.55 | 49.44 | 25.99 |
| 235 | 86 | 1 | 102 | 102 | 28.56 | 89 | 16.8 |
| 211 | 81 | 1 | 44.283 | 44.283 | 17.12 | 49.5 | 23.2 |
| 251 | 55 | 1 | 13.583 | 13.583 | 9.91 | 27.5 | 43.77 |
| 177 | 252 | 1 | 37.5 | 37.5 | 18.68 | 52 | 29.89 |
| 58 | 78 | 1 | 35.167 | 35.167 | 4.9 | 23.5 | 8.36 |
| 257 | 254 | 1 | 51.95 | 51.95 | 24.48 | 59.39 | 28.27 |
| 96 | 233 | 1 | 23.117 | 23.117 | 9 | 52 | 23.36 |
| 77 | 96 | 1 | 5.333 | 5.333 | 1.55 | 48.13 | 17.44 |
| 92 | 101 | 1 | 29.067 | 29.067 | 8.3 | 27.5 | 17.13 |
| 129 | 44 | 1 | 86.1 | 86.1 | 32.29 | 96 | 22.5 |
| 196 | 257 | 1 | 47.783 | 47.783 | 13.61 | 33.11 | 17.09 |