TdlM / taskmaster

Menu
  • Make shortlink

task_winners

9 rows where winner = 55

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
530 Find the treasure / Make different, increasingly loud noises 437 Katherine Parkinson 55 ✓
536 Select a wind-up dinosaur 441 Katherine Parkinson 55
549 Drop a water balloon as far as possible without it bursting 450 Katherine Parkinson 55
552 Bag the heaviest thing from the greatest distance 453 Katherine Parkinson 55
565 Draw animals using straight lines 462 Katherine Parkinson 55 ✓ ✓
570 Communicate the safe contents via reversed audio 465 Katherine Parkinson 55 ✓
572 Make the best and longest-lasting marble run 466 Katherine Parkinson 55
577 Extract water from a coconut 472 Katherine Parkinson 55
590 Neatly hang all the clothes on a rail without stepping over the line 482 Katherine Parkinson 55

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