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 |
|---|---|---|---|---|---|---|---|
| 162 | 155 | 150 | 52.217 | 54.861 | 18.546 | 56.18 | 21.07 |
| 164 | 185 | 150 | 31.1 | 33.733 | 13.2 | 39.58 | 24.7 |
| 63 | 63 | 150 | 1.075 | 5.983 | 1.33 | 7.71 | 39.09 |
| 79 | 119 | 150 | 23.575 | 26.633 | 9.955 | 30.45 | 24.96 |
| 231 | 130 | 149 | 49.1 | 49.501 | 16.018 | 49.43 | 21.06 |
| 95 | 226 | 149 | 20.05 | 19.983 | 5.237 | 19.12 | 16.32 |
| 75 | 17 | 149 | 39.317 | 40.053 | 10.429 | 36.06 | 17.12 |
| 116 | 233 | 149 | 32.183 | 34.117 | 7.204 | 27.19 | 14.37 |
| 181 | 158 | 149 | 24.4 | 25.997 | 5.52 | 21.64 | 13.13 |
| 148 | 165 | 149 | 28.583 | 30.367 | 9.973 | 31.83 | 20.91 |
| 56 | 129 | 149 | 13.033 | 13.712 | 2.568 | 11.93 | 11.31 |
| 141 | 93 | 149 | 29.8 | 32.653 | 11.25 | 35.17 | 22.37 |
| 52 | 257 | 149 | 14.283 | 14.83 | 3.592 | 14.06 | 15.75 |
| 255 | 106 | 149 | 20.767 | 21.633 | 5.625 | 20.33 | 17.11 |
| 125 | 133 | 149 | 21.933 | 24.702 | 7.783 | 25.54 | 20.64 |
| 181 | 229 | 149 | 26.467 | 29.482 | 8.156 | 27.92 | 18.13 |
| 145 | 211 | 149 | 24.317 | 24.855 | 4.861 | 42.44 | 12.64 |
| 137 | 200 | 149 | 41.333 | 45.124 | 13.758 | 43.66 | 21.43 |
| 39 | 35 | 149 | 14.833 | 15.531 | 2.649 | 12.4 | 10.63 |
| 152 | 158 | 149 | 23.133 | 24.009 | 7.001 | 24.13 | 18.64 |
| 193 | 225 | 149 | 27.3 | 28.169 | 5.821 | 22.62 | 12.68 |
| 161 | 258 | 149 | 37.533 | 40.24 | 11.261 | 37.53 | 17.5 |
| 89 | 26 | 149 | 14.567 | 15.934 | 2.121 | 11.94 | 8.44 |
| 10 | 232 | 149 | 42.183 | 43.277 | 15.505 | 51.85 | 23.74 |
| 41 | 220 | 149 | 21.017 | 22.488 | 7.122 | 23.85 | 20.25 |