TdlM / taskmaster

Menu
  • Make shortlink

task_winners

16 rows where winner = 101

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
895 Have the best first wedding dance with Alex 717 Kiell Smith-Bynoe 101
900 The object which makes you feel weirdest when you look at it 721 Kiell Smith-Bynoe 101
903 Compose and perform a musical solo 722 Kiell Smith-Bynoe 101
916 Make the fastest egg boat 733 Kiell Smith-Bynoe 101
918 The luckiest thing 736 Kiell Smith-Bynoe 101
923 Salvage the most spoons 739 Kiell Smith-Bynoe 101 ✓
926 Stuff your team-mate's waders 740 Kiell Smith-Bynoe 101 ✓ ✓
936 Free yourselves and have a team hug 748 Kiell Smith-Bynoe 101 ✓
938 Set the parameters for your own task 749 Kiell Smith-Bynoe 101
940 Imitate accents/walks 750 Kiell Smith-Bynoe 101 ✓
944 Repurpose an umbrella 753 Kiell Smith-Bynoe 101
947 Use the scratching post to remove balls from your suit 755 Kiell Smith-Bynoe 101 ✓ ✓
949 The sneakiest thing 756 Kiell Smith-Bynoe 101
953 Make these things the same colour 757 Kiell Smith-Bynoe 101 ✓
957 Estimate the heights of things 760 Kiell Smith-Bynoe 101 ✓
962 Perform a lullaby for a profession 764 Kiell Smith-Bynoe 101 ✓

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 8.504ms