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 | 89 | 20 | 49.933 | 52.588 | 15.061 | 47.6 | 18.31 |
| 263 | 19 | 20 | 36.667 | 37.531 | 19.215 | 56.25 | 31.4 |
| 197 | 237 | 20 | 36.625 | 39.689 | 14.6 | 44.23 | 22.79 |
| 70 | 157 | 20 | 21.317 | 25.652 | 6.217 | 23.04 | 17.35 |
| 216 | 93 | 20 | 17.617 | 21.531 | 8.543 | 25.66 | 24.53 |
| 141 | 205 | 20 | 53.217 | 56.815 | 17.799 | 54.49 | 21.3 |
| 88 | 117 | 20 | 50.35 | 56.57 | 25.671 | 72.02 | 28.94 |
| 64 | 152 | 20 | 52.275 | 51.37 | 17.207 | 51.93 | 20.79 |
| 94 | 159 | 20 | 20.017 | 20.607 | 3.662 | 15.53 | 10.88 |
| 186 | 111 | 20 | 31.392 | 32.367 | 8.799 | 29.75 | 16.65 |
| 122 | 179 | 20 | 34.45 | 33.492 | 12.675 | 35.84 | 23.69 |
| 182 | 230 | 20 | 29.8 | 34.102 | 12.391 | 38.58 | 23.41 |
| 215 | 9 | 20 | 17.35 | 19.058 | 5.52 | 19.77 | 17.67 |
| 4 | 85 | 20 | 34.817 | 35.043 | 8.971 | 31.12 | 16.6 |
| 153 | 162 | 20 | 33.608 | 34.886 | 11.494 | 34.62 | 20.77 |
| 95 | 252 | 20 | 21.325 | 18.658 | 6.589 | 21.3 | 22.53 |
| 230 | 96 | 20 | 36.308 | 41.14 | 12.177 | 40.14 | 19.35 |
| 257 | 40 | 20 | 11.325 | 13.847 | 3.21 | 13 | 16.45 |
| 68 | 101 | 20 | 44.833 | 50.103 | 18.184 | 54.75 | 23.54 |
| 80 | 183 | 20 | 22.1 | 23.802 | 14.554 | 39.8 | 37.51 |
| 35 | 189 | 20 | 24.558 | 27.595 | 4.273 | 18.73 | 9.8 |
| 20 | 136 | 20 | 14.242 | 14.68 | 1.997 | 11.03 | 8.42 |
| 33 | 179 | 20 | 27.108 | 28.603 | 9.999 | 31.57 | 22.41 |
| 21 | 178 | 20 | 9.133 | 9.182 | 1.399 | 8.18 | 9.99 |
| 197 | 254 | 20 | 42.367 | 48.028 | 16.589 | 49.65 | 21.58 |