TdlM / taskmaster

Menu
  • Make shortlink

profanity

3 rows where task = 771

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: roots, roots (array)

id ▲ series episode task speaker roots quote studio
1914 Series 16 16 The natural friends. 139 Heavier or lighter? 771 Sue Perkins 106 shit Oh, it's very... you utter shit! ✓
1915 Series 16 16 The natural friends. 139 Heavier or lighter? 771 Susan Wokoma 107 shit Shit. ✓
1916 Series 16 16 The natural friends. 139 Heavier or lighter? 771 Lucy Beaumont 104 bastard Oh, sh‒no, you can see it's not. Oh, 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 17.467ms