TdlM / taskmaster

Menu
  • Make shortlink

profanity

4 rows where task = 28

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, roots (array)

id ▲ series episode task speaker roots quote studio
82 Series 1 1 Little denim shorts. 5 Move the boulder as far as possible 28 Romesh Ranganathan 6 shit When he turned up he said, "You'll never guess, some crazy shithead wanted me to go to Camber Sands." ✓
83 Series 1 1 Little denim shorts. 5 Move the boulder as far as possible 28 Romesh Ranganathan 6 prick Do you understand why I can't deal with Mo? Mo is a prick! ✓
84 Series 1 1 Little denim shorts. 5 Move the boulder as far as possible 28 Greg Davies 2 piss How long did you piss around with those balloons? ✓
85 Series 1 1 Little denim shorts. 5 Move the boulder as far as possible 28 Tim Key 7 piss Pissed around for about... half an hour, I think. ✓

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