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 |
|---|---|---|---|---|---|---|---|
| 70 | 219 | 39 | 17.55 | 20.256 | 10.748 | 31.44 | 36.58 |
| 234 | 64 | 39 | 35.633 | 39.267 | 17.197 | 49.96 | 28.18 |
| 168 | 137 | 39 | 24.033 | 26.474 | 6.712 | 24.33 | 18.38 |
| 260 | 209 | 39 | 23.967 | 25.948 | 8.284 | 39.2 | 20.85 |
| 70 | 42 | 39 | 23.4 | 26.01 | 7.685 | 25.91 | 19.71 |
| 216 | 232 | 39 | 47.85 | 49.78 | 16.131 | 49.82 | 20.98 |
| 262 | 130 | 39 | 34.317 | 37.55 | 15.632 | 45.45 | 55.37 |
| 243 | 113 | 39 | 40.617 | 42.45 | 10.81 | 36.15 | 16.55 |
| 189 | 165 | 39 | 18.75 | 19.216 | 4.479 | 16.95 | 15.45 |
| 144 | 197 | 39 | 32.633 | 38.082 | 13.392 | 41.64 | 23.23 |
| 219 | 216 | 39 | 10.833 | 11.039 | 3.185 | 15.55 | 19.43 |
| 126 | 168 | 39 | 12.433 | 13.054 | 2.475 | 11.74 | 13.82 |
| 18 | 20 | 39 | 7.8 | 8.796 | 1.249 | 7.88 | 9.2 |
| 50 | 130 | 39 | 40.733 | 45.316 | 15.549 | 48.46 | 22.59 |
| 82 | 53 | 39 | 18.867 | 19.122 | 6.298 | 20.9 | 20.66 |
| 39 | 45 | 39 | 54.867 | 54.76 | 8.815 | 34.26 | 9.7 |
| 185 | 20 | 39 | 13.067 | 13.554 | 1.964 | 10.79 | 11.08 |
| 216 | 209 | 39 | 48.45 | 50.347 | 16.086 | 51.73 | 20.01 |
| 163 | 11 | 39 | 45.533 | 47.174 | 16.586 | 50.47 | 21.91 |
| 66 | 166 | 39 | 34.767 | 35.944 | 10.753 | 34.88 | 18.84 |
| 229 | 178 | 39 | 38.9 | 41.019 | 13.505 | 42.11 | 21.47 |
| 79 | 128 | 39 | 32.383 | 33.859 | 12.075 | 37.44 | 23.3 |
| 165 | 22 | 39 | 15.633 | 16.111 | 2.605 | 12.74 | 10.33 |
| 234 | 73 | 39 | 30.233 | 32.707 | 12.704 | 38.22 | 24.39 |
| 141 | 178 | 39 | 39.917 | 43.526 | 14.615 | 45.29 | 21.92 |