task_winners

13 rows where winner = 90

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
815 Don't pop the balloon 662 John Kearns 90 ✓
824 Make the Taskmaster say your words 668 John Kearns 90 ✓ ✓
825 The thing you most want on a Sunday morning 669 John Kearns 90
826 Put the most sand in the shopping trolley 670 John Kearns 90 ✓
837 The most useless thing that cost over £20 679 John Kearns 90
841 Perform the best routine to this music 681 John Kearns 90 ✓
842 Luggage trolley bowling 682 John Kearns 90
845 Communicate animals by saying letters and doing impressions 683 John Kearns 90 ✓ ✓
853 Pop 99 red balloons 690 John Kearns 90
856 Get this feather into the bath 691 John Kearns 90 ✓
857 Hit Bernard with an exercise ball 692 John Kearns 90
875 Write a one-minute, one-person play 701 John Kearns 90
881 The thing the Taskmaster would most like to own 705 John Kearns 90

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