TdlM / taskmaster

Menu
  • Make shortlink

profanity

7 rows where task = 41

✎ 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
118 Series 2 2 Fear of failure. 7 Find out about the Swedish person 41 Joe Wilkinson 9 shit Nej? Shit!
119 Series 2 2 Fear of failure. 7 Find out about the Swedish person 41 Joe Wilkinson 9 ass/arse It sounded like arse-licking.
120 Series 2 2 Fear of failure. 7 Find out about the Swedish person 41 Joe Wilkinson 9 ass/arse Yeah. Arse-licking...
121 Series 2 2 Fear of failure. 7 Find out about the Swedish person 41 Greg Davies 2 ass/arse The only thing you managed to establish was that he didn't have an opinion on arse-licking. ✓
122 Series 2 2 Fear of failure. 7 Find out about the Swedish person 41 Doc Brown 8 fuck Croupier! Fucking idiot.
123 Series 2 2 Fear of failure. 7 Find out about the Swedish person 41 Jon Richardson 10 shit Shit. Is he unemployed?
124 Series 2 2 Fear of failure. 7 Find out about the Swedish person 41 Jon Richardson 10 fuck Motherfucker!

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