profanity
3 rows where task = 69
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
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 );