profanity

8 rows where speaker = 57

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: episode, task, roots, studio, roots (array)

id ▲ series episode task speaker roots quote studio
1169 Series 10 10 Point of swivel. 77 Put the most spaghetti in a grapefruit 444 Richard Herring 57 bollock Ah, bollocks.
1177 Series 10 10 Toshwash. 78 Make the phone ring 448 Richard Herring 57 cock That's the scary thing! Three cocks.
1195 Series 10 10 I hate your trainers. 79 Do something out of character with £20 455 Richard Herring 57 shit Because I don't believe in any of that bullshit. ✓
1217 Series 10 10 Hippopotamus. 80 Draw animals using straight lines 462 Richard Herring 57 fuck It's a fucking thing. ✓
1234 Series 10 10 Moments of silence. 82 Learn your lines and perform a scene 471 Richard Herring 57 fuck Oh, fuck.
1236 Series 10 10 Moments of silence. 82 Learn your lines and perform a scene 471 Richard Herring 57 damn Aye, but it's damn rude!
1243 Series 10 10 Air Horn Andy. 83 Make the largest beer mat house while ringing the doorbell with increasing frequency 475 Richard Herring 57 shit Oh, shit. Forgot about the doorbell.
1244 Series 10 10 Air Horn Andy. 83 Complete the most tasks behind the five motorised doors 476 Richard Herring 57 fuck Oh, for fuck's sake.

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