TdlM / taskmaster

Menu
  • Make shortlink

profanity

7 rows where task = 791

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, studio, roots (array)

id ▲ series episode task speaker roots quote studio
1962 Series 16 16 Skateboard Division. 143 Make a cool but scary googly-eyed gang 791 Sue Perkins 106 bollock This one has a massive eye-bollock. It's just massive.
1963 Series 16 16 Skateboard Division. 143 Make a cool but scary googly-eyed gang 791 Sue Perkins 106 bollock So if you're low-down, the beaver's eye-bollock will see you. ✓
1964 Series 16 16 Skateboard Division. 143 Make a cool but scary googly-eyed gang 791 Sue Perkins 106 bollock I've got a beaver with an eye-bollock! ✓
1965 Series 16 16 Skateboard Division. 143 Make a cool but scary googly-eyed gang 791 Lucy Beaumont 104 bollock Big Billy Big Bollocks. ✓
1966 Series 16 16 Skateboard Division. 143 Make a cool but scary googly-eyed gang 791 Greg Davies 2 bollock Big Billy Big Bollocks? ✓
1967 Series 16 16 Skateboard Division. 143 Make a cool but scary googly-eyed gang 791 Greg Davies 2 Christ Jesus Christ. ✓
1968 Series 16 16 Skateboard Division. 143 Make a cool but scary googly-eyed gang 791 Sam Campbell 105 bastard Ah, lookie here, fellas, a two-eyed 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
);
Powered by Datasette · Queries took 12.099ms