TdlM / taskmaster

Menu
  • Make shortlink

task_winners

12 rows where winner = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
8 High-five a 55-year-old 8 Josh Widdicombe 4
15 Draw an image using a GPS device 14 Josh Widdicombe 4
16 Buy a gift for the Taskmaster 15 Josh Widdicombe 4
17 Get an egg as high as possible 16 Josh Widdicombe 4
18 Stand up after 100 seconds 17 Josh Widdicombe 4 ✓
19 Guess Frank’s age in minutes 18 Josh Widdicombe 4 ✓
21 Make a block of ice disappear 20 Josh Widdicombe 4
22 Score 11 points 23 Josh Widdicombe 4 ✓
27 Memorise an Australian Rules Football team 26 Josh Widdicombe 4 ✓
31 The most valuable item 27 Josh Widdicombe 4
32 Move the boulder as far as possible 28 Josh Widdicombe 4
33 Grow the longest nail 29 Josh Widdicombe 4

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