TdlM / taskmaster

Menu
  • Make shortlink

task_winners

9 rows where winner = 48

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
460 Draw the second longest snake 383 David Baddiel 48 ✓
468 The weirdest wooden thing 389 David Baddiel 48
476 Bring a classic board game to life 397 David Baddiel 48 ✓
483 The best defunct thing 400 David Baddiel 48
498 The best thing taken from someone else’s house 410 David Baddiel 48
500 Build the best Mount Rushmore 412 David Baddiel 48
512 The most desirable smooth thing 420 David Baddiel 48
513 Subtly deliver a five word instruction to Alex 421 David Baddiel 48
521 Make a cup of tea 427 David Baddiel 48 ✓

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