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 |
|---|---|---|---|---|---|---|---|
| 70 | 92 | 139 | 11.3 | 12.502 | 3.322 | 13.05 | 18.1 |
| 217 | 37 | 139 | 11.333 | 12.294 | 1.851 | 10 | 9.65 |
| 190 | 190 | 139 | 4.75 | 6.976 | 1.497 | 7.54 | 48.51 |
| 87 | 28 | 139 | 37.083 | 42.169 | 15.049 | 45.13 | 24.13 |
| 166 | 47 | 139 | 22.617 | 23.917 | 5.553 | 20.69 | 15.17 |
| 7 | 160 | 139 | 20.483 | 21.395 | 6.54 | 22.13 | 19.43 |
| 102 | 102 | 139 | 4.9 | 7.032 | 1.259 | 7.92 | 15.28 |
| 82 | 148 | 139 | 19.817 | 21.614 | 8.073 | 47.15 | 25.03 |
| 236 | 248 | 139 | 21.283 | 23.22 | 7.41 | 24.18 | 20.94 |
| 75 | 177 | 139 | 51.733 | 53.647 | 16.886 | 53.55 | 20.48 |
| 28 | 100 | 139 | 33.467 | 34.432 | 12.09 | 51.29 | 22.63 |
| 162 | 167 | 139 | 28.35 | 29.769 | 7.537 | 26.59 | 16.61 |
| 163 | 190 | 139 | 43.2 | 44.089 | 10.097 | 36.66 | 14.63 |
| 261 | 190 | 139 | 22.817 | 24.594 | 5.683 | 21.36 | 15.11 |
| 52 | 100 | 139 | 33 | 32.719 | 6.677 | 25.92 | 12.81 |
| 162 | 252 | 139 | 33 | 35.999 | 13.487 | 40.6 | 24.12 |
| 22 | 14 | 139 | 14.617 | 15.209 | 2.979 | 13.22 | 12.32 |
| 242 | 185 | 139 | 8.55 | 10.149 | 1.542 | 8.62 | 9.83 |
| 50 | 202 | 139 | 23.6 | 26.053 | 5.492 | 21.13 | 13.63 |
| 66 | 142 | 139 | 30.817 | 31.971 | 8.008 | 28.32 | 15.88 |
| 170 | 194 | 139 | 20.5 | 23.601 | 6.925 | 23.12 | 20.08 |
| 161 | 182 | 139 | 31.067 | 34.016 | 11.31 | 35.9 | 21.41 |
| 87 | 190 | 139 | 24.45 | 25.227 | 5.282 | 20.58 | 13.36 |
| 195 | 230 | 139 | 38.317 | 40.741 | 9.366 | 34.56 | 14.68 |
| 137 | 149 | 139 | 44.117 | 47.334 | 14.502 | 46.28 | 19.86 |