profanity

3 rows where episode = 12 and roots contains "bastard"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, studio, roots (array)

id ▲ series episode task speaker roots quote studio
210 Series 3 3 A pea in a haystack. 12 Make the best snowman 69 Paul Chowdhry 15 bastard Bastard's crying, innit?
211 Series 3 3 A pea in a haystack. 12 Make the best snowman 69 Greg Davies 2 bastard Right at the end, just as the final image of a snowman was in place, he said, "The bastard's crying, innit?" ✓
212 Series 3 3 A pea in a haystack. 12 Make the best snowman 69 Greg Davies 2 bastard Let's have a look at the bastard. ✓

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