TdlM / taskmaster

Menu
  • Make shortlink

profanity

7 rows where task = 9

✎ 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
23 Series 1 1 The pie whisperer. 2 Identify the contents of the pies 9 Greg Davies 2 Christ Oh, Jesus Christ. ✓
24 Series 1 1 The pie whisperer. 2 Identify the contents of the pies 9 Greg Davies 2 fuck It's not the fucking X-Files. ✓
25 Series 1 1 The pie whisperer. 2 Identify the contents of the pies 9 Romesh Ranganathan 6 hell I still can't‒what the hell is that?
26 Series 1 1 The pie whisperer. 2 Identify the contents of the pies 9 Greg Davies 2 fuck We've just seen a film of you breaching the fucking pie! ✓
27 Series 1 1 The pie whisperer. 2 Identify the contents of the pies 9 Romesh Ranganathan 6 shit 'Cause it ended up being dogshit! ✓
28 Series 1 1 The pie whisperer. 2 Identify the contents of the pies 9 Romesh Ranganathan 6 shit But you would've thought that dog shit was steak, to be fair. ✓
29 Series 1 1 The pie whisperer. 2 Identify the contents of the pies 9 Romesh Ranganathan 6 shit
shit
shit
This is bullshit, man. Utter bullshit. Utter bullshit. ✓

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