profanity

4 rows where task = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, roots (array)

id ▲ series episode task speaker roots quote studio
78 Series 1 1 Little denim shorts. 5 The most valuable item 27 Greg Davies 2 hell £600 is a hell of a start though, isn't it? ✓
79 Series 1 1 Little denim shorts. 5 The most valuable item 27 Greg Davies 2 hell Nearly four grand. It's a hell of an opener. ✓
80 Series 1 1 Little denim shorts. 5 The most valuable item 27 Greg Davies 2 fuck Well, that's you well and truly fucked then, isn't it? ✓
81 Series 1 1 Little denim shorts. 5 The most valuable item 27 Romesh Ranganathan 6 bitch Well, deal with it, 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
);