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 |
|---|---|---|---|---|---|---|---|
| 50 | 73 | 23 | 37.433 | 38.976 | 14.295 | 43.59 | 23.14 |
| 167 | 182 | 23 | 18.1 | 19.454 | 3.576 | 15.42 | 11.16 |
| 215 | 196 | 23 | 22.7 | 26.429 | 6.524 | 21.92 | 15.99 |
| 195 | 239 | 23 | 35.667 | 39.043 | 9.788 | 34.28 | 15.97 |
| 218 | 75 | 23 | 54.8 | 54.299 | 18.856 | 55.25 | 22.05 |
| 56 | 9 | 23 | 12.467 | 13.659 | 4.887 | 15.77 | 22.66 |
| 190 | 107 | 23 | 27.4 | 27.959 | 6.543 | 22.9 | 14.44 |
| 149 | 226 | 23 | 41.917 | 42.207 | 13.519 | 39.45 | 19.29 |
| 179 | 216 | 23 | 30.3 | 36.762 | 13.902 | 42.3 | 25.5 |
| 182 | 69 | 23 | 24.4 | 25.507 | 5.008 | 20.15 | 13.43 |
| 247 | 79 | 23 | 30.467 | 32.652 | 9.908 | 32.13 | 19.44 |
| 126 | 41 | 23 | 22.8 | 24.088 | 4.163 | 18.61 | 11.26 |
| 13 | 102 | 23 | 39.383 | 42.744 | 13.333 | 42.3 | 19.62 |
| 142 | 77 | 23 | 53.2 | 54.875 | 17.01 | 54.09 | 19.36 |
| 70 | 9 | 23 | 16.817 | 17.167 | 6.181 | 20.23 | 23.32 |
| 137 | 122 | 23 | 40.9 | 44.554 | 15.114 | 45.53 | 22.9 |
| 219 | 145 | 23 | 35.067 | 37.513 | 14.439 | 51.2 | 24.43 |
| 262 | 16 | 23 | 32.65 | 38.439 | 16.092 | 47.02 | 27.82 |
| 83 | 258 | 23 | 20.583 | 22.23 | 5.913 | 21.06 | 16.51 |
| 244 | 65 | 23 | 37.633 | 40.686 | 14.136 | 43.41 | 22.25 |
| 47 | 32 | 23 | 20.983 | 21.931 | 4.31 | 18.13 | 13.07 |
| 180 | 258 | 23 | 6.9 | 7.904 | 1.641 | 11.91 | 12.06 |
| 101 | 43 | 23 | 28.7 | 31.449 | 17.34 | 45.86 | 34.26 |
| 163 | 117 | 23 | 64.5 | 69.069 | 20.959 | 65.59 | 19.21 |
| 219 | 242 | 23 | 44.317 | 45.099 | 19.761 | 54.91 | 27.24 |