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 | 231 | 38 | 37.65 | 39.122 | 13.381 | 41.86 | 21.3 |
| 249 | 78 | 38 | 38.117 | 37.782 | 13.747 | 41.74 | 22.61 |
| 195 | 61 | 38 | 23.45 | 26.088 | 4.853 | 20.11 | 11.88 |
| 193 | 88 | 38 | 27.283 | 26.525 | 8.346 | 27.82 | 21.22 |
| 60 | 159 | 38 | 14.383 | 15.8 | 2.408 | 12.13 | 9.67 |
| 20 | 78 | 38 | 7.067 | 8.321 | 1.295 | 7.62 | 9.8 |
| 146 | 14 | 38 | 34.458 | 35.786 | 14.151 | 41.7 | 25.2 |
| 227 | 89 | 38 | 22.2 | 22.794 | 4.187 | 17.92 | 12.18 |
| 133 | 71 | 38 | 18.125 | 18.558 | 2.741 | 14.07 | 9.25 |
| 78 | 174 | 38 | 18.075 | 19.037 | 3.535 | 15.65 | 12.17 |
| 80 | 244 | 38 | 35.058 | 36.857 | 13.848 | 42.01 | 23.8 |
| 61 | 10 | 38 | 29.067 | 31.803 | 10.097 | 32.32 | 20.33 |
| 10 | 28 | 38 | 15.075 | 17.914 | 4.804 | 17.81 | 16.65 |
| 232 | 22 | 38 | 32.092 | 32.993 | 11.605 | 35.34 | 22.38 |
| 148 | 10 | 38 | 36.217 | 41.978 | 16.009 | 48.22 | 25.86 |
| 122 | 130 | 38 | 12.683 | 12.825 | 2.059 | 10.63 | 11.4 |
| 243 | 141 | 38 | 28.342 | 29.33 | 7.527 | 26.22 | 17.18 |
| 140 | 219 | 38 | 44.792 | 49.369 | 19.838 | 56.87 | 26.63 |
| 167 | 60 | 38 | 8.308 | 9.194 | 1.319 | 7.89 | 9.82 |
| 238 | 183 | 38 | 31.992 | 35.151 | 13.181 | 39.11 | 24.38 |
| 93 | 152 | 38 | 25.075 | 26.701 | 11.048 | 52.34 | 26.32 |
| 230 | 58 | 38 | 32.183 | 35.115 | 14.66 | 43.17 | 27.31 |
| 233 | 35 | 38 | 46.925 | 46.448 | 11.971 | 40.35 | 16.81 |
| 112 | 50 | 38 | 29.967 | 31.06 | 6.166 | 24.61 | 12.62 |
| 36 | 7 | 38 | 21.742 | 24.224 | 6.942 | 23.55 | 18.1 |