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 |
|---|---|---|---|---|---|---|---|
| 236 | 59 | 5 | 43.35 | 41.197 | 7.614 | 29.8 | 12.2 |
| 29 | 257 | 5 | 26 | 25.36 | 4.808 | 20.1 | 11.56 |
| 165 | 148 | 5 | 46.533 | 39.983 | 9.53 | 33.24 | 15.65 |
| 194 | 182 | 5 | 29.633 | 28.393 | 7.01 | 24.4 | 15.04 |
| 178 | 155 | 5 | 25.883 | 27.047 | 5.216 | 21.2 | 12.18 |
| 122 | 62 | 5 | 31.783 | 31.33 | 12.956 | 37.02 | 25 |
| 80 | 11 | 5 | 24.633 | 23.693 | 14.624 | 40.5 | 37.4 |
| 28 | 175 | 5 | 18.883 | 18.047 | 5.52 | 17.39 | 20.78 |
| 3 | 94 | 5 | 22.783 | 27.663 | 3.434 | 19.5 | 8.91 |
| 126 | 43 | 5 | 32.3 | 32.867 | 5.744 | 24 | 10.91 |
| 192 | 252 | 5 | 20.35 | 23.667 | 5.15 | 21.4 | 14.93 |
| 74 | 21 | 5 | 61.083 | 77.457 | 24.46 | 76.5 | 22.66 |
| 76 | 4 | 5 | 54.483 | 58.307 | 10.644 | 43.61 | 10.98 |
| 123 | 233 | 5 | 41.85 | 45.347 | 14.002 | 41.56 | 19.51 |
| 255 | 221 | 5 | 27.567 | 27.253 | 14.744 | 41.1 | 32.78 |
| 72 | 114 | 5 | 48.417 | 49.727 | 7.882 | 35.4 | 10.96 |
| 33 | 154 | 5 | 41.833 | 45.75 | 20.698 | 52.1 | 33.64 |
| 256 | 123 | 5 | 36.583 | 42.603 | 10.85 | 37.1 | 17.4 |
| 89 | 243 | 5 | 57.65 | 62.443 | 20.826 | 60.3 | 20.9 |
| 185 | 58 | 5 | 20.083 | 20.44 | 4.776 | 18.3 | 13.95 |
| 52 | 21 | 5 | 24.133 | 23.947 | 10.112 | 30.4 | 26.16 |
| 29 | 232 | 5 | 52.367 | 50.013 | 15.49 | 45.59 | 18.8 |
| 117 | 42 | 5 | 64.283 | 70.39 | 26.188 | 75.08 | 22.85 |
| 16 | 173 | 5 | 24.45 | 27.32 | 8.55 | 28.47 | 20.03 |
| 12 | 127 | 5 | 32.233 | 40.787 | 14.974 | 45.4 | 26.5 |