TdlM / taskmaster

Menu
  • Make shortlink

task_winners

12 rows where winner = 39

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
323 Predict what another contestant will do with an object 273 Jessica Knappett 39
328 Raise Alex’s heart rate 278 Jessica Knappett 39
331 Silently mouth a ten word fact to Greg 281 Jessica Knappett 39 ✓
332 The most confusing thing 282 Jessica Knappett 39
338 The worst gift from a relative 288 Jessica Knappett 39
341 Make the most white circles on the target 290 Jessica Knappett 39
345 Cheer up the traffic warden 291 Jessica Knappett 39
349 Place objects on the hanger without it falling 293 Jessica Knappett 39 ✓ ✓
363 Build an extension to the Taskmaster house 303 Jessica Knappett 39 ✓
371 Compose a 30 second piece of music 309 Jessica Knappett 39
375 Take a photo of yourself in a fez / Improve your hula-hooping 313 Jessica Knappett 39
378 Complete a 24-shot rally 315 Jessica Knappett 39 ✓

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