TdlM / taskmaster

Menu
  • Make shortlink

profanity

7 rows where speaker = 18

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▲ series episode task speaker roots quote studio
274 Series 4 4 Look at me. 18 Get the flour onto the target 102 Hugh Dennis 18 fuck What fucking nonsense.
279 Series 4 4 Hollowing out a baguette. 19 The best subscription 105 Hugh Dennis 18 shit I have [heard of the sky], but in Britain the sky is generally really shit. ✓
281 Series 4 4 Hollowing out a baguette. 19 Camouflage yourself 106 Hugh Dennis 18 fuck There are no clouds and that is the whole fucking point! ✓
292 Series 4 4 Hollowing out a baguette. 19 Transfer water from one fishbowl to another 109 Hugh Dennis 18 shit Can I say that's a really shit idea? ✓
296 Series 4 4 Friendship is truth. 20 The most surprising picture of yourself 112 Hugh Dennis 18 fuck Because why the fuck would Hugh Dennis be wearing... ✓
338 Series 4 4 No stars for naughty boys. 23 Make the biggest and best banana 138 Hugh Dennis 18 fuck It's just a big fucking banana. ✓
341 Series 4 4 Tony Three Pies. 24 Eat your exotic sandwich 142 Hugh Dennis 18 fuck What fucking Marks & Spencers do you go to? ✓

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