TdlM / taskmaster

Menu
  • Make shortlink

profanity

5 rows where task = 50

✎ 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
138 Series 2 2 A pistachio eclair. 9 Impress the Mayor 50 Joe Wilkinson 9 shit Shit.
139 Series 2 2 A pistachio eclair. 9 Impress the Mayor 50 Richard Osman 12 fuck Of Amersham, we don't give two fucks.
140 Series 2 2 A pistachio eclair. 9 Impress the Mayor 50 Greg Davies 2 fuck Jugglers, we don't give a fuck about you. ✓
141 Series 2 2 A pistachio eclair. 9 Impress the Mayor 50 Jon Richardson 10 shit Holy shit.
142 Series 2 2 A pistachio eclair. 9 Impress the Mayor 50 Jon Richardson 10 fuck Still less impressed than the fucking photo of an éclair.

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