TdlM / taskmaster

Menu
  • Make shortlink

profanity

3 rows where task = 68

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: roots, studio, roots (array)

id ▲ series episode task speaker roots quote studio
207 Series 3 3 A pea in a haystack. 12 Propel a pea along a red carpet 68 Greg Davies 2 shit In first place, with an incredible shitty, sicky performance, it's Rob the Roller. ✓
208 Series 3 3 A pea in a haystack. 12 Propel a pea along a red carpet 68 Paul Chowdhry 15 shit It's like finding a pea in a... haystack. Shit!
209 Series 3 3 A pea in a haystack. 12 Propel a pea along a red carpet 68 Rob Beckett 16 fuck And then when I finish, fucking bang it on there.

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