TdlM / taskmaster

Menu
  • Make shortlink

team_tasks

7 rows where team = 11

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: win

id ▲ task team win
33 Keep Alex dry 214 Alice and Russell 11 ✓
35 Have the most fun in 3 minutes 225 Alice and Russell 11
37 Exactly recreate your 3 minutes of fun 226 Alice and Russell 11 ✓
39 Identify the link and do it 100 times 233 Alice and Russell 11
41 Knock over the ducks without leaving the carpet 238 Alice and Russell 11
43 List and then mime obscure animals 245 Alice and Russell 11 ✓
45 Perform a number from the Taskmaster musical 256 Alice and Russell 11 ✓

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE team_tasks (
   id   INTEGER PRIMARY KEY,
   task INTEGER REFERENCES tasks(id),
   team INTEGER REFERENCES teams(id),
   win  INTEGER
);
Powered by Datasette · Queries took 5.25ms