profanity

4 rows where speaker = 47

✎ 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
880 Series 8 8 Hello. 55 Sneak up on Alex 326 Sian Gibson 47 shit Oh, I am shit at this!
881 Series 8 8 Hello. 55 Sneak up on Alex 326 Sian Gibson 47 shit Down, up... Oh, shit.
885 Series 8 8 A novel about Russian Gulags. 56 Transfer the rice to the bottle 331 Sian Gibson 47 shit Ah, shit.
915 Series 8 8 Rock 'n' roll umlaut. 60 Recall the order of the deck of cards 355 Sian Gibson 47 piss Piece of piss. ✓

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