TdlM / taskmaster

Menu
  • Make shortlink

task_winners

11 rows where winner = 104

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
969 Cross the finish line while connected to your team 769 Lucy Beaumont 104 ✓
973 Heavier or lighter? 771 Lucy Beaumont 104 ✓
987 Human war boats 782 Lucy Beaumont 104 ✓ ✓
989 The best thing for a grown-up that is meant for a child 783 Lucy Beaumont 104
992 Complete all the tasks as a team 785 Lucy Beaumont 104 ✓
1003 Avoid the rubbish robots 795 Lucy Beaumont 104
1005 Recreate the garage scene in the lab 796 Lucy Beaumont 104 ✓
1009 Present a powerful piece called "Heads, Shoulders, Knees and Toes" 797 Lucy Beaumont 104
1013 Play with these switches / Balance the most golf tees 800 Lucy Beaumont 104
1017 Pop your party popper the furthest 804 Lucy Beaumont 104 ✓
1032 Do something shocking but family-friendly with this doughnut 816 Lucy Beaumont 104

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