TdlM / taskmaster

Menu
  • Make shortlink

profanity

4 rows where task = 127

✎ 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
318 Series 4 4 Spatchcock it. 22 Score a goal with a shopping bag 127 Noel Fielding 22 bastard Bastard. This is the tricky bit.
319 Series 4 4 Spatchcock it. 22 Score a goal with a shopping bag 127 Noel Fielding 22 fuck This bag's fucking hopeless.
320 Series 4 4 Spatchcock it. 22 Score a goal with a shopping bag 127 Greg Davies 2 cunt And of course that's Mel's equivalent of... megacunt. ✓
321 Series 4 4 Spatchcock it. 22 Score a goal with a shopping bag 127 Alex Horne 1 cunt Megacunt. ✓

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