TdlM / taskmaster

Menu
  • Make shortlink

profanity

7 rows where task = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, roots (array)

id ▲ series episode task speaker roots quote studio
62 Series 1 1 Down an octave. 4 Score 11 points 23 Romesh Ranganathan 6 hell What does that mean? What the hell does that mean?
63 Series 1 1 Down an octave. 4 Score 11 points 23 Tim Key 7 fuck Fucking hard to get a point.
64 Series 1 1 Down an octave. 4 Score 11 points 23 Tim Key 7 wank You wanker.
65 Series 1 1 Down an octave. 4 Score 11 points 23 Tim Key 7 wank Wanker.
66 Series 1 1 Down an octave. 4 Score 11 points 23 Tim Key 7 shit Shit in the bucket?
67 Series 1 1 Down an octave. 4 Score 11 points 23 Tim Key 7 fuck Touching our heads? Fucking idiot.
68 Series 1 1 Down an octave. 4 Score 11 points 23 Romesh Ranganathan 6 Christ Oh, for Christ's sake. It's doing my head in already, this.

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