TdlM / taskmaster

Menu
  • Make shortlink

task_winners

9 rows where winner = 13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
79 Propel a pea along a red carpet 68 Al Murray 13
81 Balance swedes on a Swede 70 Al Murray 13 ✓
86 An upside-down condiment self-portrait 74 Al Murray 13
88 Unravel the tape 76 Al Murray 13 ✓
96 Spread your clothes far and wide 84 Al Murray 13
97 Find out the lying old man’s occupation 85 Al Murray 13
98 Create an impressive special effect 86 Al Murray 13 ✓
103 Move water from one bucket to another 90 Al Murray 13
104 Play charades across a river 91 Al Murray 13 ✓

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