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 |
|---|---|---|---|---|---|---|---|
| 255 | 161 | 234 | 28.383 | 29.915 | 6.024 | 23.86 | 12.96 |
| 55 | 55 | 234 | 6.725 | 8.198 | 1.447 | 9.18 | 21.39 |
| 25 | 229 | 234 | 20.292 | 21.259 | 7.038 | 22.85 | 20.98 |
| 231 | 173 | 234 | 31.275 | 33.339 | 11.336 | 35.9 | 21.75 |
| 170 | 28 | 234 | 29.775 | 33.804 | 11.787 | 37.61 | 24.01 |
| 151 | 209 | 234 | 33.217 | 33.674 | 8.776 | 30.51 | 16.37 |
| 90 | 18 | 234 | 34.175 | 37.874 | 13.425 | 41.42 | 22.93 |
| 152 | 79 | 234 | 27.917 | 29.819 | 8.166 | 28.12 | 17.44 |
| 80 | 144 | 234 | 15.142 | 16.323 | 3.797 | 23.95 | 15.05 |
| 152 | 234 | 234 | 26.817 | 28.466 | 7.071 | 25.97 | 16.07 |
| 152 | 220 | 234 | 12.908 | 14.232 | 5.75 | 18.47 | 27.77 |
| 40 | 125 | 234 | 19.875 | 20.964 | 4.351 | 17.8 | 13.25 |
| 137 | 62 | 234 | 36.3 | 38.493 | 8.762 | 31.82 | 14.85 |
| 166 | 129 | 234 | 30.567 | 32.352 | 7.948 | 28.95 | 15.72 |
| 100 | 76 | 234 | 51.333 | 54.203 | 14.721 | 48.79 | 17.73 |
| 177 | 177 | 234 | 4.808 | 6.291 | 1.23 | 8.93 | 33.21 |
| 181 | 246 | 233 | 30.1 | 31.033 | 6.881 | 25.99 | 13.91 |
| 52 | 114 | 233 | 19.683 | 20.962 | 4.134 | 17.3 | 12.49 |
| 61 | 189 | 233 | 7.05 | 8.19 | 1.428 | 7.64 | 10.89 |
| 231 | 247 | 233 | 37.917 | 41.13 | 12.22 | 39.31 | 20.35 |
| 74 | 242 | 233 | 23.717 | 25.617 | 7.633 | 25.59 | 19.2 |
| 48 | 93 | 233 | 42.3 | 43.973 | 12.743 | 42.6 | 18.8 |
| 209 | 36 | 233 | 26.417 | 27.675 | 6.303 | 23.35 | 14.39 |
| 48 | 76 | 233 | 53.967 | 57.801 | 15.588 | 51.74 | 17.52 |
| 125 | 226 | 233 | 28.85 | 30.062 | 6.988 | 25.88 | 14.89 |