TdlM / taskmaster

Menu
  • Make shortlink

task_winners

3 rows where winner = 73

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task winner team live
732 Daringly put the egg in the eggcup 594 Adrian Chiles 73
733 Drink all the vinegar 595 Adrian Chiles 73
734 Navigate the course with the pole 596 Adrian Chiles 73

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