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 |
|---|---|---|---|---|---|---|---|
| 131 | 97 | 2 | 48.008 | 48.008 | 14.28 | 44.33 | 18.26 |
| 11 | 222 | 2 | 32.183 | 32.183 | 11.945 | 36.52 | 22.38 |
| 180 | 72 | 2 | 22.425 | 22.425 | 7.9 | 25.13 | 21.16 |
| 131 | 65 | 2 | 61.383 | 61.383 | 18.775 | 57 | 18.37 |
| 167 | 55 | 2 | 61.55 | 61.55 | 26.99 | 75.75 | 27.48 |
| 197 | 14 | 2 | 62.567 | 62.567 | 22.875 | 64.75 | 22.95 |
| 191 | 73 | 2 | 20 | 20 | 8.695 | 26.5 | 26.12 |
| 203 | 243 | 2 | 29.067 | 29.067 | 20.765 | 52 | 43.19 |
| 192 | 100 | 2 | 47.133 | 47.133 | 10.715 | 39.25 | 13.65 |
| 194 | 28 | 2 | 53.833 | 53.833 | 16.855 | 46.5 | 20.36 |
| 225 | 56 | 2 | 30.208 | 30.208 | 6.85 | 24.59 | 13.57 |
| 218 | 68 | 2 | 37.608 | 37.608 | 16.99 | 50.34 | 27.14 |
| 54 | 244 | 2 | 49.85 | 49.85 | 15 | 44.25 | 23.3 |
| 15 | 143 | 2 | 32.35 | 32.35 | 17.85 | 49.5 | 33.16 |
| 37 | 182 | 2 | 42.55 | 42.55 | 17.185 | 50.5 | 26.93 |
| 238 | 253 | 2 | 34.575 | 34.575 | 13.11 | 39.5 | 23.27 |
| 93 | 19 | 2 | 19.442 | 19.442 | 8.535 | 41.25 | 26.13 |
| 45 | 251 | 2 | 29.808 | 29.808 | 15.11 | 43.5 | 32.97 |
| 188 | 122 | 2 | 41.367 | 41.367 | 15.07 | 46 | 21.9 |
| 70 | 224 | 2 | 34.133 | 34.133 | 10.315 | 33.25 | 18.18 |
| 185 | 209 | 2 | 45.258 | 45.258 | 16.05 | 50.09 | 21.86 |
| 202 | 40 | 2 | 31.467 | 31.467 | 10.25 | 30.75 | 20.29 |
| 244 | 109 | 2 | 106.05 | 106.05 | 34.005 | 100.95 | 19.87 |
| 4 | 84 | 2 | 41.033 | 41.033 | 25.535 | 68.25 | 37.66 |
| 212 | 223 | 2 | 34.033 | 34.033 | 7.68 | 30.25 | 21.49 |