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 |
|---|---|---|---|---|---|---|---|
| 148 | 153 | 17 | 33.867 | 36.065 | 14.014 | 41.85 | 25.75 |
| 150 | 155 | 17 | 17.967 | 20.138 | 5.354 | 18.97 | 17.65 |
| 85 | 229 | 17 | 39.617 | 41.931 | 11.649 | 37.94 | 17.83 |
| 213 | 132 | 17 | 30.383 | 32.236 | 15.806 | 46.99 | 32.76 |
| 227 | 257 | 17 | 12.317 | 13.297 | 2.325 | 13.08 | 11.44 |
| 144 | 167 | 17 | 35.267 | 37.807 | 11.115 | 36.38 | 18.52 |
| 21 | 29 | 17 | 13.25 | 12.612 | 2.967 | 12.15 | 15.39 |
| 42 | 10 | 17 | 34.117 | 36.202 | 15.605 | 44.89 | 27.22 |
| 106 | 45 | 17 | 15.45 | 16.33 | 3.786 | 15 | 14.15 |
| 26 | 195 | 17 | 22.317 | 23.096 | 4.795 | 19.65 | 14.39 |
| 220 | 169 | 17 | 17.267 | 19.681 | 4.171 | 16.88 | 14.89 |
| 70 | 236 | 17 | 26.2 | 25.936 | 8.742 | 27.82 | 21.1 |
| 72 | 42 | 17 | 51.35 | 57.948 | 19.941 | 54.79 | 22.2 |
| 37 | 158 | 17 | 34.067 | 34.126 | 6.339 | 26.06 | 11.71 |
| 228 | 190 | 17 | 15.617 | 17.018 | 3.052 | 13.91 | 12.06 |
| 55 | 226 | 17 | 44.05 | 47.322 | 21.074 | 60.41 | 27.4 |
| 190 | 36 | 17 | 24.633 | 25.786 | 5.259 | 20.65 | 12.79 |
| 54 | 140 | 17 | 25.533 | 27.233 | 8.269 | 26.17 | 18.79 |
| 77 | 14 | 17 | 34.467 | 37.892 | 16.191 | 47.49 | 26.68 |
| 20 | 3 | 17 | 13.367 | 14.633 | 2.786 | 12.65 | 12.63 |
| 226 | 8 | 17 | 15.567 | 15.487 | 3.133 | 13.29 | 12.63 |
| 246 | 214 | 17 | 35.75 | 37.778 | 16.408 | 47 | 26.82 |
| 190 | 230 | 17 | 46.883 | 45.034 | 8.604 | 34.02 | 12.08 |
| 163 | 109 | 17 | 64.6 | 65.198 | 23.912 | 70.71 | 22.04 |
| 219 | 138 | 17 | 29.15 | 27.868 | 10.624 | 33.06 | 25.35 |