task_winners

11 rows where winner = 25

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
169 The most excellent noise 146 Mark Watson 25
173 Get some fruit into the bowl 150 Mark Watson 25 ✓
178 Create the greatest splat 155 Mark Watson 25 ✓
181 Paint your own canvas 156 Mark Watson 25 ✓
194 Blow up a balloon to the size of a cucumber 165 Mark Watson 25
198 Backthrow a picture of a Swede into a bin 169 Mark Watson 25
203 Build a can tower & greet Alex from different countries 174 Mark Watson 25
204 Identify the Finns 175 Mark Watson 25 ✓
211 The most surprisingly expensive item 183 Mark Watson 25
218 The most awkward item to take home 189 Mark Watson 25
221 Write and perform a song about a stranger 193 Mark Watson 25 ✓

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
);