TdlM / taskmaster

Menu
  • Make shortlink

task_winners

13 rows where winner = 78

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
741 The object you would most like to show to an alien 603 Ardal O'Hanlon 78
744 Score an exercise ball hat-trick using a buggy 606 Ardal O'Hanlon 78 ✓
754 The best night-time thing 613 Ardal O'Hanlon 78
756 Give Alex the best stag minute 615 Ardal O'Hanlon 78 ✓
760 Turn over the most beer mats 618 Ardal O'Hanlon 78
763 Raise the water level to the top of the fish tank 622 Ardal O'Hanlon 78
764 Answer Alex's phone call 623 Ardal O'Hanlon 78
766 The most calming item 625 Ardal O'Hanlon 78
772 The nicest thing to put your finger in 631 Ardal O'Hanlon 78
785 Learn Swedish 638 Ardal O'Hanlon 78
788 Write down things that fit the category 641 Ardal O'Hanlon 78 ✓ ✓
790 The best object with a handle 642 Ardal O'Hanlon 78
795 Predict how many cans you can fit in a bag 646 Ardal O'Hanlon 78 ✓

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