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 |
|---|---|---|---|---|---|---|---|
| 40 | 142 | 60 | 37.925 | 38.947 | 8.792 | 32.38 | 14.44 |
| 224 | 12 | 60 | 10.708 | 11.389 | 4.048 | 14.12 | 22.47 |
| 161 | 201 | 60 | 54.025 | 57.266 | 25.522 | 72.55 | 28.15 |
| 17 | 66 | 60 | 13.708 | 14.225 | 2.643 | 11.88 | 11.82 |
| 25 | 165 | 60 | 25.267 | 27.5 | 6.168 | 23.45 | 14.62 |
| 169 | 244 | 60 | 19.017 | 18.429 | 2.992 | 15.16 | 11.88 |
| 219 | 87 | 60 | 50.242 | 51.859 | 20.208 | 52.82 | 25.46 |
| 80 | 42 | 60 | 28.283 | 30.093 | 11.188 | 34.48 | 23.91 |
| 43 | 147 | 60 | 22.65 | 26.039 | 6.255 | 22.72 | 15.35 |
| 7 | 158 | 60 | 33.983 | 38.602 | 8.415 | 31.17 | 14.19 |
| 189 | 14 | 60 | 23.017 | 24.526 | 6.529 | 23.47 | 16.79 |
| 248 | 231 | 60 | 41.992 | 43.69 | 14.91 | 45.67 | 21.18 |
| 225 | 72 | 60 | 17.467 | 19.12 | 3.224 | 14.76 | 10.67 |
| 127 | 18 | 60 | 14.258 | 15.183 | 2.449 | 12.06 | 10.04 |
| 52 | 43 | 60 | 28.958 | 30.902 | 9.089 | 29.8 | 18.82 |
| 223 | 126 | 60 | 15.833 | 17.536 | 6.849 | 22.03 | 24.27 |
| 179 | 42 | 60 | 22.775 | 25.206 | 6.053 | 22.61 | 16.45 |
| 229 | 20 | 60 | 24.7 | 29.199 | 11.131 | 33.98 | 24.97 |
| 37 | 66 | 60 | 23.325 | 25.692 | 4.063 | 18.22 | 10.56 |
| 219 | 142 | 60 | 53.567 | 55.669 | 17.744 | 52.65 | 21.01 |
| 79 | 155 | 60 | 41.125 | 44.871 | 15.572 | 47.71 | 21.4 |
| 87 | 254 | 60 | 53.3 | 54.6 | 18.401 | 55.1 | 22.56 |
| 226 | 243 | 60 | 28.508 | 32.992 | 10.637 | 34.57 | 21.62 |
| 249 | 210 | 60 | 38 | 40.994 | 17.142 | 49.76 | 26.66 |
| 188 | 257 | 60 | 11.817 | 12.212 | 1.876 | 9.98 | 10.26 |