TdlM / taskmaster

Menu
  • Make shortlink

profanity

4 rows where task = 394

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, roots (array)

id ▲ series episode task speaker roots quote studio
1020 Series 9 9 Five miles per day. 67 Fill a glass with water 394 David Baddiel 48 piss Can I piss in it? ✓
1021 Series 9 9 Five miles per day. 67 Fill a glass with water 394 Greg Davies 2 piss That wouldn't be water, David, would it? It would be piss. ✓
1022 Series 9 9 Five miles per day. 67 Fill a glass with water 394 David Baddiel 48 shit Shit! ✓
1023 Series 9 9 Five miles per day. 67 Fill a glass with water 394 Rose Matafeo 52 fuck Whaaa! That was fucking sand! ✓

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 11.529ms