TdlM / taskmaster

Menu
  • Make shortlink

task_winners

17 rows where winner = 79

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
736 The most exciting thing to be found in a skip 598 Bridget Christie 79
743 Recreate the coolest photo from your phone 605 Bridget Christie 79
746 Draw and describe the object under your table 607 Bridget Christie 79 ✓
748 Recreate a historical moment using traffic cones 609 Bridget Christie 79
750 Enable Alex to bite his duck 611 Bridget Christie 79
751 Face leg or other leg? 612 Bridget Christie 79 ✓ ✓
759 Knock over your opponents' dolls with a tyre 617 Bridget Christie 79 ✓
761 The most surprising thing from your wardrobe 619 Bridget Christie 79
765 Pop balls out of your hole 624 Bridget Christie 79 ✓
768 Record a high number on a pedometer 627 Bridget Christie 79
775 Deliver a cocktail to Greg 633 Bridget Christie 79 ✓
778 Create an edible sculpture 634 Bridget Christie 79
783 The loveliest thing to hold above your head 637 Bridget Christie 79
787 Walk through the door wearing the longest shoes and biggest hat 640 Bridget Christie 79
796 The finest family heirloom 647 Bridget Christie 79
799 Record a multi-track song about your team 650 Bridget Christie 79 ✓
802 Draw a life-size self portrait with your nose in the canvas 651 Bridget Christie 79 ✓

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