TdlM / taskmaster

Menu
  • Make shortlink

team_tasks

6 rows where team = 13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: win

id ▲ task team win
47 Paint a blindfolded still life 272 Jessica and Kerry 13
49 Make yourselves appear as large or small as possible 292 Jessica and Kerry 13
51 Place objects on the hanger without it falling 293 Jessica and Kerry 13 ✓
53 Make a soap opera cliffhanger 297 Jessica and Kerry 13
55 Build an extension to the Taskmaster house 303 Jessica and Kerry 13 ✓
57 Complete a 24-shot rally 315 Jessica and Kerry 13 ✓

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