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 |
|---|---|---|---|---|---|---|---|
| 62 | 37 | 59 | 19.65 | 20.221 | 3.588 | 15.73 | 11.25 |
| 244 | 224 | 59 | 31.2 | 33.105 | 9.983 | 32.73 | 20.37 |
| 168 | 132 | 59 | 35.017 | 43.127 | 18.622 | 56.03 | 31.62 |
| 193 | 173 | 59 | 24.467 | 26.649 | 5.719 | 22.3 | 13.67 |
| 53 | 53 | 59 | 3.167 | 8.633 | 2.303 | 9.24 | 32.12 |
| 22 | 227 | 59 | 14.767 | 16.316 | 2.708 | 12.93 | 10.4 |
| 26 | 62 | 59 | 30.2 | 32.288 | 4.385 | 21.82 | 8.68 |
| 130 | 56 | 59 | 17.983 | 19.233 | 5.763 | 20.59 | 19.29 |
| 220 | 128 | 59 | 2.517 | 5.392 | 1.078 | 6.21 | 24.36 |
| 140 | 178 | 59 | 42.633 | 43.678 | 14.172 | 44.45 | 20.97 |
| 179 | 198 | 59 | 27.35 | 30.07 | 7.096 | 25.85 | 15.48 |
| 12 | 75 | 59 | 26.783 | 28.832 | 8.782 | 28.47 | 19.28 |
| 158 | 71 | 59 | 38.983 | 41.865 | 9.475 | 34.71 | 14.32 |
| 226 | 205 | 59 | 54.5 | 52.423 | 13.147 | 43.69 | 16.78 |
| 74 | 240 | 59 | 19.35 | 20.675 | 8.918 | 26.97 | 27.79 |
| 161 | 240 | 59 | 26.917 | 29.071 | 13.315 | 39.98 | 29.14 |
| 113 | 93 | 59 | 36.567 | 40.949 | 12.649 | 39.9 | 21.06 |
| 228 | 22 | 59 | 17.917 | 19.873 | 4.201 | 17.18 | 13.62 |
| 92 | 56 | 59 | 11.167 | 13.694 | 3.347 | 13.27 | 16.28 |
| 209 | 91 | 59 | 45.45 | 48.033 | 11.221 | 38.91 | 14.87 |
| 76 | 75 | 59 | 54.033 | 54.64 | 19.023 | 56.72 | 22.24 |
| 219 | 203 | 59 | 9.8 | 10.269 | 2.577 | 11.15 | 17.88 |
| 4 | 190 | 59 | 24.717 | 26.609 | 6.633 | 23.76 | 15.77 |
| 151 | 71 | 59 | 61.3 | 64.13 | 15.365 | 53.62 | 15.01 |
| 243 | 186 | 59 | 25.383 | 30.682 | 9.449 | 31.53 | 20.1 |