TdlM / taskmaster

Menu
  • Make shortlink

task_winners

15 rows where winner = 103

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
966 The most wonderful wooden thing you’ve owned for a while 767 Julian Clary 103
968 Cross the finish line while connected to your team 769 Julian Clary 103 ✓
972 Heavier or lighter? 771 Julian Clary 103 ✓
976 Pull the sword from the stone 773 Julian Clary 103
980 Draw something you like and something you dislike 776 Julian Clary 103 ✓
983 Get the ball in the hole without touching it 779 Julian Clary 103
986 Human war boats 782 Julian Clary 103 ✓ ✓
991 Complete all the tasks as a team 785 Julian Clary 103 ✓
1001 Retrieve and sip your drink 793 Julian Clary 103 ✓
1004 Recreate the garage scene in the lab 796 Julian Clary 103 ✓
1016 Get three balls on your hat using litter-pickers 803 Julian Clary 103 ✓
1020 Complete the fortune trail 807 Julian Clary 103
1028 Feed the clown the most cards 813 Julian Clary 103
1031 The thing that, when you turn it round, gives you the biggest shock 815 Julian Clary 103
1033 Demonstrate the most effective high-intensity four-part exercise routine 817 Julian Clary 103

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.901ms