TdlM / taskmaster

Menu
  • Make shortlink

profanity

7 rows where task = 24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speaker, roots, quote, studio, roots (array)

id ▲ series episode task speaker roots quote studio
69 Series 1 1 Down an octave. 4 Fill an eggcup with tears 24 Tim Key 7 shit I don't wanna sort of "spoiler alert" my VT, but I was shit at it. ✓
70 Series 1 1 Down an octave. 4 Fill an eggcup with tears 24 Josh Widdicombe 4 fuck I mean, there's fuck-all in there.
71 Series 1 1 Down an octave. 4 Fill an eggcup with tears 24 Romesh Ranganathan 6 shit Oh, shit!
72 Series 1 1 Down an octave. 4 Fill an eggcup with tears 24 Romesh Ranganathan 6 fuck Fuck!
73 Series 1 1 Down an octave. 4 Fill an eggcup with tears 24 Romesh Ranganathan 6 fuck Oh, fuck me!
74 Series 1 1 Down an octave. 4 Fill an eggcup with tears 24 Romesh Ranganathan 6 shit Oh, shit.
75 Series 1 1 Down an octave. 4 Fill an eggcup with tears 24 Romesh Ranganathan 6 shit Oh, shit.

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