TdlM / taskmaster

Menu
  • Make shortlink

profanity

6 rows where speaker = 30

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▲ series episode task speaker roots quote studio
489 CoC -1 Wiley giraffe blower. 33 Blow something substantial off a table 197 Katherine Ryan 30 shit Shit! This won't blow!
490 CoC -1 Wiley giraffe blower. 33 Blow something substantial off a table 197 Katherine Ryan 30 shit OK. Oh, shit!
495 CoC -1 I've sinned again. 34 Find out what’s in the briefcase 202 Katherine Ryan 30 fuck Oh, my fucking god!
506 CoC -1 I've sinned again. 34 Make a mess and then clean it up 204 Katherine Ryan 30 fuck Fucking... God!
507 CoC -1 I've sinned again. 34 Make a mess and then clean it up 204 Katherine Ryan 30 damn One minute, 45 seconds? This is no good for a mess. Damn it!
508 CoC -1 I've sinned again. 34 Make a mess and then clean it up 204 Katherine Ryan 30 shit Shit! Is Alan there?

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