TdlM / taskmaster

Menu
  • Make shortlink

profanity

3 rows where speaker = 28

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: roots, studio, roots (array)

id ▲ series episode task speaker roots quote studio
494 CoC -1 I've sinned again. 34 Find out what’s in the briefcase 202 Bob Mortimer 28 fuck 200,000 divided by forty equals... well, I don't fucking know.
505 CoC -1 I've sinned again. 34 Make a mess and then clean it up 204 Bob Mortimer 28 bastard I'm sprinkling unsalted peanuts. Messy bastards.
511 CoC -1 I've sinned again. 34 Record the most steps on your pedometers 205 Bob Mortimer 28 fuck Where is the fucker? ✓

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