TdlM / taskmaster

Menu
  • Make shortlink

profanity

7 rows where task = 393

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▲ series episode task speaker roots quote studio
1013 Series 9 9 Five miles per day. 67 Break something and put it back together 393 Katy Wix 51 fuck Fuck. How'd that go?
1014 Series 9 9 Five miles per day. 67 Break something and put it back together 393 Ed Gamble 49 ass/arse Why have you done it like this, Ed, you absolute arsehole.
1015 Series 9 9 Five miles per day. 67 Break something and put it back together 393 Greg Davies 2 fuck Okay, I don't know where to fucking start here. ✓
1016 Series 9 9 Five miles per day. 67 Break something and put it back together 393 Jo Brand 50 fuck
fuck
Yeah, and didn't fucking eat it. Just got on with it, like a quiet, nerdy fuckwit. ✓
1017 Series 9 9 Five miles per day. 67 Break something and put it back together 393 Greg Davies 2 Christ Jesus Christ. ✓
1018 Series 9 9 Five miles per day. 67 Break something and put it back together 393 David Baddiel 48 ass/arse
ass/arse
It just says Broad Arse now. Do you want a Broad Arse Award?
1019 Series 9 9 Five miles per day. 67 Break something and put it back together 393 Rose Matafeo 52 shit What do you mean? Oh, shit.

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