TdlM / taskmaster

Menu
  • Make shortlink

task_winners

20 rows where winner = 102

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
894 The most dependable thing that weighs about 1kg 716 Mae Martin 102
896 Put a ball of string on the cushion 718 Mae Martin 102
897 Get all the rubber rings on your bargepole 719 Mae Martin 102
906 Achieve an impressive effect with a single breath 724 Mae Martin 102
910 Catch the potatoes in the potato hat 728 Mae Martin 102
915 Strike the most drums with a bouncy ball 732 Mae Martin 102
921 Musical Simon Says 738 Mae Martin 102
924 Salvage the most spoons 739 Mae Martin 102 ✓
927 Stuff your team-mate's waders 740 Mae Martin 102 ✓ ✓
930 Efficiently shell an egg 743 Mae Martin 102
931 Bash the big bell with the bowling ball 744 Mae Martin 102
932 Story-time chairs 745 Mae Martin 102 ✓
937 Free yourselves and have a team hug 748 Mae Martin 102 ✓
941 Imitate accents/walks 750 Mae Martin 102 ✓
943 Pile the pineapples on the path 752 Mae Martin 102
948 Use the scratching post to remove balls from your suit 755 Mae Martin 102 ✓ ✓
954 Make these things the same colour 757 Mae Martin 102 ✓
958 The best Greg Davies merchandise 761 Mae Martin 102
959 Fill the glass up to the line 762 Mae Martin 102
963 Perform a lullaby for a profession 764 Mae Martin 102 ✓

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
);
Powered by Datasette · Queries took 10.606ms