profanity

3 rows where task = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, roots (array)

id ▲ series episode task speaker roots quote studio
4 Series 1 1 Melon buffet. 1 Eat as much watermelon as possible 2 Romesh Ranganathan 6 shit And then when I threw it I was like, "Holy shit, that has..." ✓
5 Series 1 1 Melon buffet. 1 Eat as much watermelon as possible 2 Greg Davies 2 shit I've got an image of you at an all-you-can-eat buffet just kicking the shit out of everything. ✓
6 Series 1 1 Melon buffet. 1 Eat as much watermelon as possible 2 Romesh Ranganathan 6 bitch Son of a bitch! ✓

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
);