TdlM / taskmaster

Menu
  • Make shortlink

profanity

6 rows where task = 702

✎ 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
1756 Series 14 14 A new business end. 126 Perform a one-minute, one-person play 702 John Kearns 90 piss Mine was, do you know what? Mine's piss-easy, there's no lines.
1757 Series 14 14 A new business end. 126 Perform a one-minute, one-person play 702 Sarah Millican 92 dick Oh, you dick.
1758 Series 14 14 A new business end. 126 Perform a one-minute, one-person play 702 Fern Brady 89 ass/arse "My cat died last year, but I don't miss it because it was an arsehole."
1759 Series 14 14 A new business end. 126 Perform a one-minute, one-person play 702 Fern Brady 89 dick "But when she went into the home, she made me take it, even though he was always a dick to me."
1760 Series 14 14 A new business end. 126 Perform a one-minute, one-person play 702 Fern Brady 89 shit "I check my phone. Seven missed calls from the home. Oh, shit."
1761 Series 14 14 A new business end. 126 Perform a one-minute, one-person play 702 Dara Ó Briain 88 shit Initially when I opened it, I said, "Oh, shit, there's nothing 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 22.607ms