TdlM / taskmaster

Menu
  • Make shortlink

profanity

5 rows where task = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, roots (array)

id ▲ series episode task speaker roots quote studio
34 Series 1 1 The poet and the egg. 3 The most meaningful item 12 Greg Davies 2 shit I like to give people a chance to justify their decisions, but I will say this: it's shit, go on. ✓
35 Series 1 1 The poet and the egg. 3 The most meaningful item 12 Greg Davies 2 shit Now I feel like a total shit. ✓
36 Series 1 1 The poet and the egg. 3 The most meaningful item 12 Greg Davies 2 fuck I went, "Good luck, everyone. Boop!" to Romesh and he went, "What the fuck was that?" ✓
37 Series 1 1 The poet and the egg. 3 The most meaningful item 12 Romesh Ranganathan 6 fuck But what the fuck was that, man? ✓
38 Series 1 1 The poet and the egg. 3 The most meaningful item 12 Greg Davies 2 fuck He won't speak to you 'cause you didn't read his fucking book. ✓

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