TdlM / taskmaster

Menu
  • Make shortlink

profanity

5 rows where task = 300

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, roots (array)

id ▲ series episode task speaker roots quote studio
804 Series 7 7 The perfect stuff. 51 The most exciting thing beginning with 'G' 300 Kerry Godliman 40 shit Okay, I see where you're coming from. That it's shit. ✓
805 Series 7 7 The perfect stuff. 51 The most exciting thing beginning with 'G' 300 Greg Davies 2 fuck The glove puppets were my sister's, so fuck you. ✓
806 Series 7 7 The perfect stuff. 51 The most exciting thing beginning with 'G' 300 Rhod Gilbert 42 fuck Well, I think that "fuck you" should be directed at your mother, because she said you'd say that. ✓
807 Series 7 7 The perfect stuff. 51 The most exciting thing beginning with 'G' 300 Greg Davies 2 shit It seems they're just an old pair of glasses and a lot of bullshit. ✓
808 Series 7 7 The perfect stuff. 51 The most exciting thing beginning with 'G' 300 Greg Davies 2 shit These three, absolutely shit. ✓

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