TdlM / taskmaster

Menu
  • Make shortlink

profanity

3 rows where speaker = 73

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: roots (array)

id ▲ series episode task speaker roots quote studio
1513 NYT 2022 -3 Basic recipe 28. 106 Turn a ball into a competitor's head 597 Adrian Chiles 73 dick Ooh, "Basic recipe 28, plain pudding mixture." That's what you like, no dicking around.
1515 NYT 2022 -3 Basic recipe 28. 106 Turn a ball into a competitor's head 597 Adrian Chiles 73 bastard I've just drunk all the bastard vinegar.
1517 NYT 2022 -3 Basic recipe 28. 106 Turn a ball into a competitor's head 597 Adrian Chiles 73 hell Ooh, bloody hell.

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