TdlM / taskmaster

Menu
  • Make shortlink

profanity

4 rows where speaker = 63

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: episode, task, roots, studio, roots (array)

id ▲ series episode task speaker roots quote studio
1321 Series 11 11 Slap and tong. 90 Sort the objects with your face 513 Charlotte Ritchie 63 hell What the hell's that?
1322 Series 11 11 Slap and tong. 90 Sort the objects with your face 513 Charlotte Ritchie 63 fuck Oh, fuck. There's that egg. OK.
1327 Series 11 11 Slap and tong. 90 Slap and tong 514 Charlotte Ritchie 63 damn Oh, I'm gonna get you... Damn! ✓
1388 Series 11 11 Activate Jamali. 95 Direct a teammate into the red circle 540 Charlotte Ritchie 63 hell This is hell!

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