TdlM / taskmaster

Menu
  • Make shortlink

profanity

3 rows where task = 78

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: studio, roots (array)

id ▲ series episode task speaker roots quote studio
232 Series 3 3 Little polythene grief cave. 14 Fill an eggcup with sweat 78 Greg Davies 2 ass/arse From his arse? ✓
233 Series 3 3 Little polythene grief cave. 14 Fill an eggcup with sweat 78 Paul Chowdhry 15 bastard Al Murray's gonna win this, that fat bastard.
234 Series 3 3 Little polythene grief cave. 14 Fill an eggcup with sweat 78 Al Murray 13 damn Oh, damn it! ✓

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