TdlM / taskmaster

Menu
  • Make shortlink

task_winners

8 rows where winner = 81

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
747 The item that sounds funniest when you say its name over and over again 608 Judi Love 81
752 Face leg or other leg? 612 Judi Love 81 ✓ ✓
758 Make a stirring speech out of the bunting 616 Judi Love 81
769 Hold a meeting with yourselves 628 Judi Love 81
776 Deliver a cocktail to Greg 633 Judi Love 81 ✓
781 Eat your beautiful sculpture 635 Judi Love 81
792 Make the longest cup snake 644 Judi Love 81
800 Record a multi-track song about your team 650 Judi Love 81 ✓

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