TdlM / taskmaster

Menu
  • Make shortlink

task_winners

5 rows where winner = 15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team

id ▲ task winner team live
90 Fill an eggcup with sweat 78 Paul Chowdhry 15
91 Make the best domino rally 79 Paul Chowdhry 15
95 The shiniest thing 83 Paul Chowdhry 15
100 Create an impressive special effect 86 Paul Chowdhry 15 ✓
106 Play charades across a river 91 Paul Chowdhry 15 ✓

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