TdlM / taskmaster

Menu
  • Make shortlink

profanity

6 rows where task = 389

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, roots (array)

id ▲ series episode task speaker roots quote studio
1000 Series 9 9 Five miles per day. 67 The weirdest wooden thing 389 Greg Davies 2 shit It's absolutely shit, well done. ✓
1001 Series 9 9 Five miles per day. 67 The weirdest wooden thing 389 Greg Davies 2 shit It's absolutely shit, Ivor! ✓
1002 Series 9 9 Five miles per day. 67 The weirdest wooden thing 389 David Baddiel 48 shit It's so shit. ✓
1003 Series 9 9 Five miles per day. 67 The weirdest wooden thing 389 Alex Horne 1 dick The stick and the dick? ✓
1004 Series 9 9 Five miles per day. 67 The weirdest wooden thing 389 Greg Davies 2 dick The stick and the dick. ✓
1005 Series 9 9 Five miles per day. 67 The weirdest wooden thing 389 Greg Davies 2 dick As so often in life I do, I'm gonna put dick in second place. ✓

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.964ms