TdlM / taskmaster

Menu
  • Make shortlink

profanity

8 rows where speaker = 21

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▲ series episode task speaker roots quote studio
273 Series 4 4 Look at me. 18 Get the flour onto the target 102 Mel Giedroyc 21 hell Bloody hell, this is tricky, isn't it?
275 Series 4 4 Look at me. 18 Get the flour onto the target 102 Mel Giedroyc 21 bollock Then it would've‒aw, bollocks!
322 Series 4 4 Spatchcock it. 22 Hide the giant beach ball 128 Mel Giedroyc 21 bollock Oh, bollocks.
323 Series 4 4 Spatchcock it. 22 Hide the giant beach ball 128 Mel Giedroyc 21 bollock Oh, bollocks!
324 Series 4 4 Spatchcock it. 22 Hide the giant beach ball 128 Mel Giedroyc 21 bollock Oh, bollocks!
325 Series 4 4 Spatchcock it. 22 Hide the giant beach ball 128 Mel Giedroyc 21 bollock Bollocks. This is horrendous!
337 Series 4 4 No stars for naughty boys. 23 Make the biggest and best banana 138 Mel Giedroyc 21 bollock Bollocks. ✓
349 Series 4 4 Tony Three Pies. 24 Draw the median duck 145 Mel Giedroyc 21 fuck But I don't know what fucking size everyone else is gonna draw! ✓

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