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 |
|---|---|---|---|---|---|---|---|
| 179 | 57 | 8 | 17.167 | 19.913 | 5.499 | 19.44 | 18.42 |
| 77 | 258 | 8 | 17.717 | 21.048 | 4.775 | 18.75 | 14.15 |
| 205 | 48 | 8 | 58.533 | 58.452 | 17.769 | 56.12 | 18.95 |
| 183 | 75 | 8 | 36.258 | 40.41 | 11.181 | 33.39 | 17.02 |
| 18 | 56 | 8 | 27.467 | 29.996 | 12.895 | 38.23 | 26.99 |
| 181 | 119 | 8 | 39.033 | 44.775 | 16.082 | 47.68 | 23.84 |
| 77 | 45 | 8 | 34.825 | 41.894 | 8.616 | 31.84 | 13.58 |
| 70 | 249 | 8 | 41.142 | 40.756 | 11.866 | 37.63 | 17.95 |
| 216 | 4 | 8 | 41.017 | 43.848 | 16.662 | 49.56 | 24.23 |
| 79 | 27 | 8 | 48.542 | 46.55 | 24.51 | 67.88 | 31.87 |
| 83 | 238 | 8 | 35.083 | 34.452 | 7.806 | 28.88 | 14.09 |
| 28 | 139 | 8 | 19.742 | 20.935 | 7.556 | 23.88 | 22.03 |
| 208 | 241 | 8 | 18.117 | 24.258 | 7.275 | 24.61 | 20.75 |
| 171 | 43 | 8 | 45.725 | 44.356 | 12.069 | 40 | 17.65 |
| 16 | 14 | 8 | 62.208 | 64.41 | 26.65 | 76.5 | 25.61 |
| 54 | 13 | 8 | 16.142 | 16.442 | 3.897 | 15.06 | 14.85 |
| 61 | 218 | 8 | 34.233 | 37.323 | 11.367 | 35.45 | 18.56 |
| 220 | 212 | 8 | 24.658 | 25.371 | 8.155 | 26.19 | 21.85 |
| 87 | 86 | 8 | 70.25 | 68.59 | 27.81 | 80.31 | 25.4 |
| 194 | 224 | 8 | 19.358 | 24.079 | 7.181 | 30.06 | 19.66 |
| 250 | 141 | 8 | 34.2 | 35.817 | 9.171 | 29.07 | 16.06 |
| 77 | 136 | 8 | 36.533 | 38.665 | 22.09 | 57.95 | 35.13 |
| 77 | 226 | 8 | 32.342 | 34.492 | 11.751 | 39.03 | 20.83 |
| 28 | 177 | 8 | 25.75 | 28.4 | 8.559 | 30.35 | 18.6 |
| 10 | 69 | 8 | 36.533 | 35.86 | 16.42 | 45.09 | 29.7 |