TdlM / taskmaster

Menu
  • Make shortlink

task_winners

15 rows where winner = 66

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
598 The best thing you can carry, but only just 490 Mike Wozniak 66
599 Do something impressive under the table while waving 491 Mike Wozniak 66
606 Have an argument 497 Mike Wozniak 66 ✓
614 Act out nursery rhymes 504 Mike Wozniak 66 ✓ ✓
632 Vandalise a wall creatively 518 Mike Wozniak 66 ✓
637 Complete the most tasks 523 Mike Wozniak 66
640 Get out of the front gate 525 Mike Wozniak 66 ✓
645 The most satisfying wobbly thing 527 Mike Wozniak 66
647 Complete various tasks while saying ‘metronome’ 528 Mike Wozniak 66
649 Draw the best picture of a British animal 529 Mike Wozniak 66 ✓
650 Perform the greatest aircraft safety demonstration 530 Mike Wozniak 66
655 Appear as different as possible in four photos 535 Mike Wozniak 66
656 Shove your fish 536 Mike Wozniak 66 ✓
657 The thing that makes you look the toughest 537 Mike Wozniak 66
661 Direct a teammate into the red circle 540 Mike Wozniak 66 ✓

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