TdlM / taskmaster

Menu
  • Make shortlink

task_winners

15 rows where winner = 56

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
527 Make a large object vanish 433 Mawaan Rizwan 56
529 The best thing with loads of holes in it 436 Mawaan Rizwan 56
531 Find the treasure / Make different, increasingly loud noises 437 Mawaan Rizwan 56 ✓
543 The cheekiest food 447 Mawaan Rizwan 56
556 Do something out of character with £20 455 Mawaan Rizwan 56
560 The most narcissistic thing 458 Mawaan Rizwan 56
561 Quietly make a cocktail 459 Mawaan Rizwan 56
563 Transfer the water from one barrel to another 461 Mawaan Rizwan 56
566 Draw animals using straight lines 462 Mawaan Rizwan 56 ✓ ✓
567 The best thing that’s bigger at the top than the bottom 463 Mawaan Rizwan 56
568 Move two chickens around a course using a remote-control car and a mobility scooter 464 Mawaan Rizwan 56
571 Communicate the safe contents via reversed audio 465 Mawaan Rizwan 56 ✓
579 Do not blink while staring at your opponent with a selected expression 473 Mawaan Rizwan 56 ✓ ✓
582 Make the largest beer mat house while ringing the doorbell with increasing frequency 475 Mawaan Rizwan 56
586 The greatest collection 479 Mawaan Rizwan 56

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