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 |
|---|---|---|---|---|---|---|---|
| 113 | 127 | 404 | 30.925 | 33.831 | 11.855 | 36.95 | 22.47 |
| 143 | 200 | 404 | 18.8 | 21.138 | 9.969 | 29.19 | 30.47 |
| 79 | 193 | 404 | 17.975 | 20.154 | 5.2 | 18.53 | 17.31 |
| 249 | 190 | 403 | 25.583 | 27.109 | 6.073 | 22.88 | 14.16 |
| 162 | 134 | 403 | 32.85 | 35.486 | 11.603 | 37.58 | 21.42 |
| 233 | 61 | 403 | 35.233 | 37.426 | 8.944 | 31.58 | 15.23 |
| 75 | 126 | 403 | 16.533 | 18.206 | 4.692 | 17.02 | 16.66 |
| 93 | 68 | 403 | 29.217 | 30.929 | 10.49 | 51.69 | 22.08 |
| 33 | 158 | 402 | 20.642 | 21.371 | 4.367 | 17.85 | 12.76 |
| 12 | 249 | 402 | 14.658 | 15.92 | 2.737 | 12.88 | 10.97 |
| 10 | 239 | 402 | 45.983 | 49.355 | 17.439 | 52.02 | 22.95 |
| 40 | 97 | 402 | 12.042 | 13 | 1.934 | 10.24 | 9.45 |
| 112 | 198 | 402 | 17.45 | 18.366 | 3.871 | 15.37 | 13.16 |
| 113 | 260 | 402 | 25.658 | 27.631 | 7.248 | 25.38 | 17.29 |
| 186 | 177 | 402 | 42.733 | 45.13 | 9.637 | 35.56 | 13.76 |
| 7 | 234 | 402 | 24.108 | 26.51 | 5.323 | 21.01 | 13.1 |
| 239 | 95 | 401 | 37.633 | 39.413 | 11.92 | 38.67 | 19.11 |
| 263 | 66 | 401 | 25.5 | 27.305 | 8.494 | 27.36 | 20.13 |
| 65 | 236 | 401 | 27.117 | 28.546 | 8.432 | 27.69 | 19.01 |
| 170 | 193 | 400 | 17.217 | 18.979 | 3.841 | 15.84 | 13.11 |
| 25 | 107 | 400 | 18.958 | 20.296 | 5.013 | 18.72 | 15.56 |
| 211 | 24 | 400 | 25.9 | 28.231 | 6.933 | 25.14 | 15.54 |
| 132 | 58 | 400 | 32.525 | 34.292 | 17.893 | 49.08 | 33.1 |
| 40 | 261 | 400 | 10.117 | 11.499 | 3.039 | 13.32 | 18.02 |
| 25 | 137 | 400 | 18.3 | 19.765 | 5.746 | 19.89 | 18.77 |