TdlM / taskmaster

Menu
  • Make shortlink

task_winners

2 rows where task = 300

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ task winner team live
359 The most exciting thing beginning with 'G' 300 James Acaster 38
360 The most exciting thing beginning with 'G' 300 Rhod Gilbert 42

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