TdlM / taskmaster

Menu
  • Make shortlink

task_winners

10 rows where winner = 20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
120 Put an egg in an egg cup without touching either 103 Lolly Adefope 20
130 The most surprising picture of yourself 112 Lolly Adefope 20
139 The cutest thing 118 Lolly Adefope 20
141 Don the diving gear while maintaining eye contact and small talk 120 Lolly Adefope 20
147 The best sheep-related item 125 Lolly Adefope 20
151 Identify the contents of the sleeping bag 131 Lolly Adefope 20
156 Hide from Alex 135 Lolly Adefope 20
158 Wheelie bin obstacle course 136 Lolly Adefope 20 ✓
161 Make the biggest and best banana 138 Lolly Adefope 20 ✓
163 The most cash 140 Lolly Adefope 20

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