TdlM / taskmaster

Menu
  • Make shortlink

profanity

6 rows where task = 90

✎ 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
247 Series 3 3 The F.I.P. 16 Move water from one bucket to another 90 Rob Beckett 16 fuck Why the fuck peas?
248 Series 3 3 The F.I.P. 16 Move water from one bucket to another 90 Rob Beckett 16 fuck Yeah, I just lost all control. Oh, fuck me!
249 Series 3 3 The F.I.P. 16 Move water from one bucket to another 90 Rob Beckett 16 fuck Oh, for fuck's sake.
250 Series 3 3 The F.I.P. 16 Move water from one bucket to another 90 Rob Beckett 16 shit And it was so cold. I was shitting meself, I was dropping water. ✓
251 Series 3 3 The F.I.P. 16 Move water from one bucket to another 90 Greg Davies 2 fuck "Yo yo, the motherfuckin' FIP." ✓
252 Series 3 3 The F.I.P. 16 Move water from one bucket to another 90 Dave Gorman 14 hell Right, what the hell have we got here?

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