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 |
|---|---|---|---|---|---|---|---|
| 75 | 191 | 54 | 45.425 | 48.506 | 20.15 | 58.87 | 26.92 |
| 144 | 35 | 54 | 29.767 | 31.902 | 7.372 | 26.94 | 14.66 |
| 28 | 211 | 54 | 33.5 | 33.44 | 13.922 | 51.83 | 26.43 |
| 236 | 71 | 54 | 46.608 | 47.769 | 14.327 | 46.02 | 18.75 |
| 116 | 174 | 54 | 23.467 | 24.692 | 7.992 | 26.46 | 21.02 |
| 133 | 65 | 54 | 16.583 | 19.567 | 4.859 | 17.82 | 17.07 |
| 125 | 213 | 54 | 52.175 | 55.59 | 14.402 | 47.07 | 17.38 |
| 42 | 145 | 54 | 28.142 | 28.82 | 7.265 | 25.89 | 16.26 |
| 87 | 10 | 54 | 55.733 | 56.49 | 18.497 | 55.92 | 21.65 |
| 80 | 95 | 54 | 16.883 | 18.534 | 6.989 | 21.99 | 24.67 |
| 26 | 67 | 54 | 12.95 | 13.984 | 2.183 | 11.96 | 9.81 |
| 50 | 165 | 54 | 39.325 | 42.422 | 13.26 | 42.39 | 19.54 |
| 193 | 95 | 54 | 23.167 | 26.259 | 7.963 | 27.65 | 20.45 |
| 77 | 63 | 54 | 12.433 | 12.553 | 1.975 | 10.19 | 9.92 |
| 188 | 165 | 54 | 17.825 | 19.001 | 3.585 | 15.22 | 12.07 |
| 262 | 185 | 54 | 25.892 | 26.807 | 9.53 | 29.57 | 22.62 |
| 219 | 79 | 54 | 47.292 | 49.397 | 16.629 | 52.62 | 22.81 |
| 121 | 215 | 54 | 16.542 | 18.577 | 2.99 | 14.35 | 10.03 |
| 114 | 147 | 54 | 26.925 | 28.185 | 10.419 | 32.27 | 23.58 |
| 229 | 21 | 54 | 40.75 | 45.078 | 16.335 | 49.11 | 23.27 |
| 112 | 95 | 54 | 18.633 | 20.141 | 7.707 | 24.34 | 24.09 |
| 106 | 54 | 54 | 8.467 | 9.697 | 1.777 | 8.72 | 11.66 |
| 21 | 210 | 54 | 13.942 | 16.769 | 2.808 | 13.4 | 10.61 |
| 148 | 254 | 54 | 34.108 | 38.033 | 16.466 | 47.48 | 28.58 |
| 79 | 108 | 54 | 35.2 | 38.776 | 15.801 | 46.69 | 26.43 |