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 |
|---|---|---|---|---|---|---|---|
| 130 | 170 | 399 | 25.533 | 27.835 | 12.129 | 51.61 | 28.75 |
| 262 | 146 | 399 | 15.1 | 16.554 | 3.824 | 15.02 | 14.7 |
| 230 | 1 | 399 | 36.367 | 40.689 | 18.126 | 83.77 | 29.26 |
| 90 | 220 | 399 | 30.567 | 32.759 | 12.202 | 37.51 | 23.74 |
| 233 | 168 | 398 | 15.25 | 17.471 | 5.822 | 19.09 | 22.4 |
| 137 | 160 | 398 | 18.392 | 21.926 | 6.792 | 22.58 | 20.64 |
| 146 | 262 | 398 | 11.875 | 13.468 | 2.931 | 12.1 | 14.84 |
| 237 | 198 | 398 | 31.975 | 33.222 | 7.38 | 27.29 | 13.95 |
| 43 | 168 | 397 | 17.967 | 20.218 | 4.078 | 16.7 | 12.93 |
| 193 | 237 | 397 | 11.633 | 13.183 | 2.523 | 12.8 | 13.33 |
| 75 | 209 | 397 | 24 | 25.611 | 8.058 | 26.31 | 21.12 |
| 188 | 71 | 397 | 8.817 | 10.014 | 1.452 | 8.47 | 9.25 |
| 45 | 225 | 397 | 25.7 | 27.127 | 5.337 | 21.37 | 12.55 |
| 137 | 198 | 397 | 26.4 | 29.341 | 7.274 | 25.81 | 16.25 |
| 79 | 177 | 397 | 31 | 32.847 | 6.964 | 26.4 | 13.28 |
| 13 | 129 | 397 | 27.917 | 31.424 | 11.305 | 35.14 | 22.92 |
| 100 | 92 | 397 | 37.917 | 39.594 | 12.254 | 39.69 | 20.08 |
| 164 | 92 | 397 | 30.55 | 33.164 | 11.834 | 36.62 | 23.25 |
| 42 | 167 | 396 | 15.317 | 16.301 | 2.897 | 13.28 | 11.42 |
| 145 | 95 | 396 | 20.833 | 23.276 | 6.802 | 23.14 | 19.76 |
| 143 | 247 | 396 | 20.792 | 22.051 | 7.473 | 24.41 | 22.6 |
| 112 | 79 | 396 | 16.675 | 17.907 | 4.202 | 16.42 | 15.39 |
| 162 | 157 | 396 | 21.075 | 23.379 | 6.224 | 22.77 | 17.22 |
| 236 | 40 | 396 | 32.425 | 34.642 | 10.195 | 32.77 | 18.86 |
| 260 | 140 | 395 | 18.25 | 19.894 | 4.266 | 17.9 | 14.18 |