TdlM / taskmaster

Menu
  • Make shortlink

task_winners

19 rows where winner = 92

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
813 Create the best picture of a bird 661 Sarah Millican 92 ✓
828 Put the most sand in the shopping trolley 670 Sarah Millican 92 ✓
831 Play your sounds right 673 Sarah Millican 92 ✓
832 The greatest addition to a garden 674 Sarah Millican 92
833 Turn on the bubble machine 675 Sarah Millican 92
834 Get the tarpaulin into one of the containers 676 Sarah Millican 92
835 Write a classic song incorporating five wonderful words 677 Sarah Millican 92
847 Communicate animals by saying letters and doing impressions 683 Sarah Millican 92 ✓ ✓
848 The best thing you've ever received in the post 684 Sarah Millican 92
849 Hold the milk bottles above the microwaves 685 Sarah Millican 92
850 Reach the end of two lanes in the same amount of time 686 Sarah Millican 92
852 The thing you'd most like to have on a car journey 689 Sarah Millican 92
861 Blow an item onto The Knappett 693 Sarah Millican 92 ✓
864 Communicate an instruction in a secret language 695 Sarah Millican 92 ✓
867 Find the back of your hand 697 Sarah Millican 92
869 Guess the length of the extendible item 698 Sarah Millican 92 ✓ ✓
872 The most underestimated item 699 Sarah Millican 92
876 Write a one-minute, one-person play 701 Sarah Millican 92
884 Sculpt your team 708 Sarah Millican 92 ✓

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