TdlM / taskmaster

Menu
  • Make shortlink

task_winners

11 rows where winner = 18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
113 Fell all the ducks 97 Hugh Dennis 18
116 Keep the basketball on the treadmill 100 Hugh Dennis 18
118 Get the flour onto the target 102 Hugh Dennis 18 ✓
124 Make a Taskmaster movie trailer 107 Hugh Dennis 18 ✓
135 Do something incredible with a pommel horse 116 Hugh Dennis 18
137 Make the tallest tube tower 117 Hugh Dennis 18 ✓
142 Do incompatible things with the bathtub 121 Hugh Dennis 18 ✓
146 Eat as many peas as possible 124 Hugh Dennis 18
149 Score a goal with a shopping bag 127 Hugh Dennis 18
154 The best chair 133 Hugh Dennis 18
165 Eat your exotic sandwich 142 Hugh Dennis 18

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