task_winners

10 rows where winner = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
174 The hippest headwear 151 Sally Phillips 27
183 Paint your own canvas 156 Sally Phillips 27 ✓
187 Eat one item, balance one item, throw one item 160 Sally Phillips 27
193 Do something remarkable synchronised 164 Sally Phillips 27 ✓
199 The most high-octane item 170 Sally Phillips 27
201 Create a remarkable water cooler moment 172 Sally Phillips 27
207 Record the most incredible PoV footage 178 Sally Phillips 27
210 Kick yoghurt at a target 182 Sally Phillips 27
214 Vote for who should receive five points 186 Sally Phillips 27
219 Transport a coconut as far as possible 190 Sally Phillips 27

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE task_winners (
   id     INTEGER PRIMARY KEY,
   task   INTEGER REFERENCES tasks(id),
   winner INTEGER REFERENCES people(id),
   team   INTEGER,
   live   INTEGER
);