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 |
|---|---|---|---|---|---|---|---|
| 4 | 152 | 75 | 26.35 | 27.292 | 8.917 | 28.86 | 21.06 |
| 254 | 81 | 75 | 8.033 | 8.406 | 1.459 | 8.63 | 11.06 |
| 261 | 193 | 75 | 33.283 | 34.432 | 8.713 | 30.37 | 16.27 |
| 148 | 147 | 75 | 26.367 | 28.194 | 10.496 | 32.29 | 23.78 |
| 246 | 169 | 75 | 26.783 | 29.708 | 10.111 | 31.78 | 23.16 |
| 137 | 185 | 75 | 34.567 | 36.801 | 12.655 | 38.47 | 22.55 |
| 100 | 124 | 75 | 50.8 | 52.407 | 14.038 | 46.15 | 17.19 |
| 89 | 132 | 75 | 35.383 | 38.221 | 15.598 | 46.52 | 26.1 |
| 152 | 147 | 75 | 22.667 | 24.265 | 4.74 | 19.53 | 12.01 |
| 50 | 35 | 75 | 49.383 | 49.787 | 12.763 | 43.72 | 17.67 |
| 213 | 168 | 75 | 16.25 | 17.464 | 4.686 | 17.03 | 17.62 |
| 32 | 254 | 75 | 9.083 | 11.149 | 1.788 | 9.69 | 9.95 |
| 56 | 226 | 75 | 18.017 | 19.631 | 5.461 | 24.29 | 18.88 |
| 113 | 212 | 75 | 28.55 | 30.83 | 11.95 | 35.95 | 24.42 |
| 72 | 90 | 75 | 59.067 | 60.865 | 10.227 | 42.29 | 10.42 |
| 106 | 66 | 75 | 17.733 | 18.975 | 2.74 | 13.87 | 9.2 |
| 237 | 29 | 75 | 48.033 | 51.137 | 19.861 | 58.51 | 25.07 |
| 190 | 65 | 75 | 16.083 | 17.765 | 2.76 | 13.81 | 9.76 |
| 168 | 174 | 75 | 25.183 | 26.447 | 8.075 | 26.67 | 19.9 |
| 65 | 77 | 75 | 38.567 | 40.74 | 6.359 | 28.31 | 10.07 |
| 130 | 95 | 75 | 16.683 | 17.382 | 3.755 | 15.23 | 13.68 |
| 140 | 121 | 75 | 35.567 | 38.341 | 13.24 | 40.54 | 22.39 |
| 140 | 191 | 75 | 57.333 | 58.761 | 18.422 | 55.59 | 20.54 |
| 56 | 137 | 75 | 18.05 | 20.467 | 8.034 | 46.09 | 26.97 |
| 129 | 80 | 75 | 14.833 | 16.208 | 4.994 | 17.26 | 20.17 |