profanity

3 rows where task = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, roots (array)

id ▲ series episode task speaker roots quote studio
1 Series 1 1 Melon buffet. 1 The most unusual item 1 Romesh Ranganathan 6 shit I think we can all agree it's the shittest present in the history of humanity. ✓
2 Series 1 1 Melon buffet. 1 The most unusual item 1 Romesh Ranganathan 6 piss You know the granules? The snow density is piss-poor. ✓
3 Series 1 1 Melon buffet. 1 The most unusual item 1 Greg Davies 2 shit And the winner of this competition will have to take all of that shit home. ✓

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