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 |
|---|---|---|---|---|---|---|---|
| 229 | 94 | 48 | 28.833 | 31.629 | 9.666 | 31.6 | 20.4 |
| 177 | 181 | 48 | 24.858 | 26.347 | 4.428 | 19.98 | 10.51 |
| 141 | 227 | 48 | 33.925 | 35.467 | 12.919 | 39.18 | 23.44 |
| 170 | 222 | 48 | 55.508 | 58.6 | 15.658 | 50.97 | 17.44 |
| 38 | 205 | 48 | 10.808 | 11.02 | 2.051 | 9.99 | 12.22 |
| 197 | 215 | 48 | 14.017 | 14.123 | 2.58 | 11.88 | 11.59 |
| 83 | 146 | 48 | 15.142 | 15.794 | 2.876 | 13.2 | 11.95 |
| 13 | 178 | 48 | 26.292 | 26.388 | 7.902 | 26.02 | 18.7 |
| 113 | 29 | 48 | 42.392 | 44.403 | 16.366 | 48.46 | 23.25 |
| 55 | 25 | 48 | 42.958 | 42.208 | 12.324 | 40 | 19.23 |
| 50 | 149 | 48 | 43.708 | 46.832 | 15.082 | 47.56 | 20.21 |
| 89 | 22 | 48 | 18.208 | 19.804 | 3.592 | 15.41 | 11.18 |
| 93 | 129 | 48 | 12.983 | 13.947 | 4.11 | 14.95 | 18.19 |
| 228 | 21 | 48 | 21.383 | 22.333 | 6.188 | 21.77 | 17.48 |
| 87 | 108 | 48 | 33.892 | 35.15 | 13.67 | 41.1 | 24.59 |
| 3 | 242 | 48 | 10.692 | 13.261 | 2.17 | 11.1 | 10.84 |
| 196 | 138 | 48 | 12.908 | 13.693 | 4.91 | 16.25 | 23.28 |
| 108 | 108 | 48 | 4.758 | 5.744 | 0.814 | 6.3 | 10.03 |
| 235 | 137 | 48 | 38.475 | 40.113 | 10.713 | 35.78 | 18.07 |
| 125 | 135 | 48 | 46.183 | 46.776 | 13.439 | 42.28 | 18.16 |
| 80 | 257 | 48 | 17.825 | 19.532 | 7.769 | 23.95 | 26.23 |
| 114 | 197 | 48 | 38.075 | 41 | 13.777 | 44.42 | 22.04 |
| 238 | 26 | 48 | 47.85 | 51.088 | 14.371 | 46.91 | 17.46 |
| 231 | 222 | 48 | 50.425 | 52.583 | 15.057 | 49.47 | 18.28 |
| 219 | 140 | 48 | 47.117 | 49.231 | 17.857 | 54.44 | 24.71 |