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 |
|---|---|---|---|---|---|---|---|
| 119 | 154 | 1 | 120.667 | 120.667 | 32.33 | 100.5 | 16.08 |
| 121 | 94 | 1 | 33.733 | 33.733 | 16.42 | 47 | 29.21 |
| 201 | 48 | 1 | 88.067 | 88.067 | 20.26 | 55.6 | 13.8 |
| 201 | 231 | 1 | 34.133 | 34.133 | 22.43 | 60 | 39.43 |
| 92 | 5 | 1 | 56.283 | 56.283 | 36.03 | 94 | 38.41 |
| 218 | 128 | 1 | 38.183 | 38.183 | 22.32 | 57.75 | 35.07 |
| 20 | 63 | 1 | 39.267 | 39.267 | 18.6 | 53.5 | 28.42 |
| 191 | 171 | 1 | 21.2 | 21.2 | 5.9 | 21.5 | 16.7 |
| 213 | 173 | 1 | 18.917 | 18.917 | 7.14 | 22 | 22.65 |
| 147 | 31 | 1 | 15.5 | 15.5 | 4.9 | 17 | 18.97 |
| 243 | 123 | 1 | 57.1 | 57.1 | 22.1 | 66 | 23.22 |
| 134 | 210 | 1 | 47.8 | 47.8 | 13.2 | 43 | 16.57 |
| 60 | 233 | 1 | 50.883 | 50.883 | 10.52 | 39 | 12.4 |
| 178 | 193 | 1 | 49.967 | 49.967 | 13.73 | 43.5 | 16.49 |
| 166 | 9 | 1 | 44.65 | 44.65 | 14.13 | 42.5 | 18.99 |
| 139 | 204 | 1 | 59.217 | 59.217 | 34.98 | 93.5 | 35.44 |
| 210 | 78 | 1 | 94.617 | 94.617 | 37.23 | 112.5 | 23.61 |
| 46 | 113 | 1 | 62.617 | 62.617 | 18.9 | 60.5 | 18.11 |
| 165 | 113 | 1 | 51.267 | 51.267 | 11.95 | 42.5 | 13.99 |
| 139 | 137 | 1 | 97.033 | 97.033 | 17.88 | 71 | 11.06 |
| 235 | 191 | 1 | 31.567 | 31.567 | 19.23 | 52.5 | 36.55 |
| 177 | 166 | 1 | 61.4 | 61.4 | 14.21 | 51 | 13.89 |
| 167 | 124 | 1 | 66.983 | 66.983 | 18.17 | 60 | 16.28 |
| 105 | 170 | 1 | 16.45 | 16.45 | 5.02 | 18 | 18.31 |
| 120 | 259 | 1 | 20.483 | 20.483 | 8.4 | 25 | 24.61 |