TdlM / taskmaster

Menu
  • Make shortlink

profanity

7 rows where speaker = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: episode, task, roots, studio, roots (array)

id ▲ series episode task speaker roots quote studio
18 Series 1 1 The pie whisperer. 2 The most impressive item 7 Roisin Conaty 5 piss I'm not a pisshead! ✓
20 Series 1 1 The pie whisperer. 2 High-five a 55-year-old 8 Roisin Conaty 5 shit Feels like being Bond, but sort of shittier.
93 Series 1 1 The last supper. 6 Play mini golf with eggs 34 Roisin Conaty 5 shit I think you're all shit at golf. ✓
95 Series 1 1 The last supper. 6 Stage a realistic home movie blooper 35 Roisin Conaty 5 ass/arse Hit his arse.
96 Series 1 1 The last supper. 6 Stage a realistic home movie blooper 35 Roisin Conaty 5 ass/arse Hit his arse!
100 Series 1 1 The last supper. 6 Make an alphabet meal 36 Roisin Conaty 5 shit Shit the bed!
103 Series 1 1 The last supper. 6 Separate the blue sweets 37 Roisin Conaty 5 fuck Can the floor get fucked up? ✓

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