TdlM / taskmaster

Menu
  • Make shortlink

profanity

5 rows where task = 35

✎ 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
95 Series 1 1 The last supper. 6 Stage a realistic home movie blooper 35 Roisin Conaty 5 ass/arse Hit his arse.
96 Series 1 1 The last supper. 6 Stage a realistic home movie blooper 35 Roisin Conaty 5 ass/arse Hit his arse!
97 Series 1 1 The last supper. 6 Stage a realistic home movie blooper 35 Romesh Ranganathan 6 shit "Oh, shit! Paddling pool, out of nowhere!" ✓
98 Series 1 1 The last supper. 6 Stage a realistic home movie blooper 35 Romesh Ranganathan 6 shit It is a lot shitter than I thought it was gonna look. ✓
99 Series 1 1 The last supper. 6 Stage a realistic home movie blooper 35 Romesh Ranganathan 6 shit And then I waited for the reveal and then there was none and then we had to defend that dogshit. ✓

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