TdlM / taskmaster

Menu
  • Make shortlink

profanity

6 rows where task = 3

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▲ series episode task speaker roots quote studio
7 Series 1 1 Melon buffet. 1 Paint a horse while riding a horse 3 Tim Key 7 shit Horseshit.
8 Series 1 1 Melon buffet. 1 Paint a horse while riding a horse 3 Romesh Ranganathan 6 shit What a pile of horse shit.
9 Series 1 1 Melon buffet. 1 Paint a horse while riding a horse 3 Tim Key 7 shit And I am absolutely dogshit at painting.
10 Series 1 1 Melon buffet. 1 Paint a horse while riding a horse 3 Greg Davies 2 shit The top three are absolutely shit. ✓
11 Series 1 1 Melon buffet. 1 Paint a horse while riding a horse 3 Tim Key 7 Christ Ow, Jesus Christ!
12 Series 1 1 Melon buffet. 1 Paint a horse while riding a horse 3 Josh Widdicombe 4 wank Stop being such a wanker. ✓

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