task_winners
3 rows where winner = 73
This data as json, CSV (advanced)
id ▲ | task | winner | team | live |
---|---|---|---|---|
732 | Daringly put the egg in the eggcup 594 | Adrian Chiles 73 | ||
733 | Drink all the vinegar 595 | Adrian Chiles 73 | ||
734 | Navigate the course with the pole 596 | Adrian Chiles 73 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE task_winners ( id INTEGER PRIMARY KEY, task INTEGER REFERENCES tasks(id), winner INTEGER REFERENCES people(id), team INTEGER, live INTEGER );