TdlM / taskmaster

Menu
  • Make shortlink

profanity

4 rows where task = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, roots (array)

id ▲ series episode task speaker roots quote studio
16 Series 1 1 The pie whisperer. 2 The most impressive item 7 Romesh Ranganathan 6 shit The category is not "shit that would be great at a party". ✓
17 Series 1 1 The pie whisperer. 2 The most impressive item 7 Romesh Ranganathan 6 piss Old pisshead here's just got a massive bottle of champagne. ✓
18 Series 1 1 The pie whisperer. 2 The most impressive item 7 Roisin Conaty 5 piss I'm not a pisshead! ✓
19 Series 1 1 The pie whisperer. 2 The most impressive item 7 Romesh Ranganathan 6 shit This is bullshit, man. ✓

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