TdlM / taskmaster

Menu
  • Make shortlink

task_winners

17 rows where winner = 36

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
237 Make the tallest lemon tower 208 Russell Howard 36
244 Keep Alex dry 214 Russell Howard 36 ✓
251 Catch the most socks 222 Russell Howard 36 ✓
252 The most thought-provoking thing 223 Russell Howard 36
260 Exactly recreate your 3 minutes of fun 226 Russell Howard 36 ✓
263 Remove the banknote from under the glass 228 Russell Howard 36
270 Remove the tablecloth from underneath the eggs 232 Russell Howard 36
278 Make the best snow globe 237 Russell Howard 36
285 The scariest thing from the kitchen 242 Russell Howard 36
286 Knock the bails off the stumps 243 Russell Howard 36
289 List and then mime obscure animals 245 Russell Howard 36 ✓
291 Make and eat a pancake with objects tucked into your sweatband 246 Russell Howard 36
298 Stick plasters to the correct body parts 252 Russell Howard 36 ✓
299 Quickly receive a text message 253 Russell Howard 36
303 Perform a number from the Taskmaster musical 256 Russell Howard 36 ✓
306 Hold the most points above the ground 259 Russell Howard 36 ✓
308 Knock over the fewest bowling pins 261 Russell Howard 36

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