TdlM / taskmaster

Menu
  • Make shortlink

profanity

4 rows where task = 174

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, studio, roots (array)

id ▲ series episode task speaker roots quote studio
424 Series 5 5 A wind-dried puffin. 29 Build a can tower & greet Alex from different countries 174 Aisling Bea 23 fuck We kept going for so fucking long! ✓
425 Series 5 5 A wind-dried puffin. 29 Build a can tower & greet Alex from different countries 174 Nish Kumar 26 piss
shit
Piss and shit!
426 Series 5 5 A wind-dried puffin. 29 Build a can tower & greet Alex from different countries 174 Nish Kumar 26 fuck The fuck?! ✓
427 Series 5 5 A wind-dried puffin. 29 Build a can tower & greet Alex from different countries 174 Sally Phillips 27 bugger Oh, you... buggers.

Advanced export

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

CSV options:

CREATE TABLE profanity (
   id      INTEGER PRIMARY KEY,
   series  INTEGER REFERENCES series(id),
   episode INTEGER REFERENCES episodes(id),
   task    INTEGER REFERENCES tasks(id),
   speaker INTEGER REFERENCES people(id),
   roots   TEXT,
   quote   TEXT,
   studio  INTEGER
);
Powered by Datasette · Queries took 18.734ms