TdlM / taskmaster

Menu
  • Make shortlink

task_winners

13 rows where winner = 33

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
236 Perform the best wheelbarrow stunt 207 Alice Levine 33
238 Return to the house wearing a hat 209 Alice Levine 33
240 Spin around and kick a football at the caravan 211 Alice Levine 33
243 Keep Alex dry 214 Alice Levine 33 ✓
257 Exactly recreate your 3 minutes of fun 226 Alice Levine 33 ✓
264 Shake hands with the Taskmaster without revealing your identity 229 Alice Levine 33 ✓
267 Remove the tablecloth from underneath the eggs 232 Alice Levine 33
284 Predict how many words you can list for a category 241 Alice Levine 33 ✓
288 List and then mime obscure animals 245 Alice Levine 33 ✓
295 Put something surprising inside a chocolate egg 249 Alice Levine 33
301 Make the biggest bubble and burst it with your nose 255 Alice Levine 33
302 Perform a number from the Taskmaster musical 256 Alice Levine 33 ✓
312 Pick numbers higher and lower than the people next to you 264 Alice Levine 33 ✓

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