TdlM / taskmaster

Menu
  • Make shortlink

profanity

3 rows where task = 14

✎ 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
41 Series 1 1 The poet and the egg. 3 Draw an image using a GPS device 14 Josh Widdicombe 4 fuck Come on, colour in, you fucker.
42 Series 1 1 The poet and the egg. 3 Draw an image using a GPS device 14 Greg Davies 2 hell He seemed to cover a hell of a distance, didn't he? ✓
43 Series 1 1 The poet and the egg. 3 Draw an image using a GPS device 14 Greg Davies 2 fuck It's a really good painting, but why on earth do I want a picture of you? It's absolutely fucking preposterous. ✓

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