title_coiners
2 rows where coiner = 5
This data as json, CSV (advanced)
id ▲ | episode | coiner | task |
---|---|---|---|
1 | Melon buffet. 1 | Roisin Conaty 5 | Eat as much watermelon as possible 2 |
4 | Down an octave. 4 | Roisin Conaty 5 | Make a block of ice disappear 20 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE title_coiners ( id INTEGER PRIMARY KEY, episode INTEGER REFERENCES episodes(id), coiner INTEGER REFERENCES people(id), task INTEGER REFERENCES tasks(id) );