task_winners

14 rows where winner = 100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
899 Throw your items into your bucket 720 Jenny Eclair 100 ✓
902 Compose and perform a musical solo 722 Jenny Eclair 100
907 Create a picture of an animal on the back of your T-shirt 725 Jenny Eclair 100 ✓
908 The most heroic thing 726 Jenny Eclair 100
917 Task bingo 734 Jenny Eclair 100
922 Salvage the most spoons 739 Jenny Eclair 100 ✓
925 Stuff your team-mate's waders 740 Jenny Eclair 100 ✓ ✓
935 Free yourselves and have a team hug 748 Jenny Eclair 100 ✓
942 The thing you take everywhere with you, but struggle to fit in your bag 751 Jenny Eclair 100
946 Use the scratching post to remove balls from your suit 755 Jenny Eclair 100 ✓ ✓
952 Make these things the same colour 757 Jenny Eclair 100 ✓
961 Perform a lullaby for a profession 764 Jenny Eclair 100 ✓
964 Standing in ice, or not standing in ice? 765 Jenny Eclair 100 ✓
965 Scream with your mouth closed 766 Jenny Eclair 100

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