TdlM / taskmaster

Menu
  • Make shortlink

profanity

2 rows where task = 196

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: roots (array)

id ▲ series episode task speaker roots quote studio
487 CoC -1 Wiley giraffe blower. 33 Throw an exercise ball into a bath or put the coconuts in a trolley 196 Rob Beckett 32 shit Bit of a shithole, West London, innit?
488 CoC -1 Wiley giraffe blower. 33 Throw an exercise ball into a bath or put the coconuts in a trolley 196 Greg Davies 2 shit Thank God some other people stepped up and did a really shit job of it. ✓

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