TdlM / taskmaster

Menu
  • Make shortlink

task_winners

19 rows where winner = 105

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
967 Build a tower of cans in the lab 768 Sam Campbell 105
970 Cross the finish line while connected to your team 769 Sam Campbell 105 ✓
974 Heavier or lighter? 771 Sam Campbell 105 ✓
977 Make a cheeky picture using nails and wire 774 Sam Campbell 105
982 The present that raises the most questions 778 Sam Campbell 105
984 Get underneath the most unique things 780 Sam Campbell 105
985 Choose a new nickname 781 Sam Campbell 105
988 Human war boats 782 Sam Campbell 105 ✓ ✓
993 Complete all the tasks as a team 785 Sam Campbell 105 ✓
994 Recreate a well-known piece of art on 100 memo squares 786 Sam Campbell 105
996 Roll your animal die 787 Sam Campbell 105 ✓
1000 Make a cool but scary googly-eyed gang 791 Sam Campbell 105
1002 The greatest thing that makes quite a loud noise when you shake it 794 Sam Campbell 105
1006 Recreate the garage scene in the lab 796 Sam Campbell 105 ✓
1010 Present a powerful piece called "Heads, Shoulders, Knees and Toes" 797 Sam Campbell 105
1015 Place your cardboard replica within the boundary 802 Sam Campbell 105
1019 Find the secret task 806 Sam Campbell 105
1021 Convince a child that you're asleep 808 Sam Campbell 105
1036 Throw a ball into the bathtub 819 Sam Campbell 105 ✓

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