podcast
2 rows where guest = 100
This data as json, CSV (advanced)
id ▲ | episode | guest | topic | rating |
---|---|---|---|---|
127 | 126 | Jenny Eclair 100 | I love to squander promise. 131 | 4 |
139 | 138 | Jenny Eclair 100 | Don't like them go bang. 73 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE podcast ( id INTEGER PRIMARY KEY, episode INTEGER, guest INTEGER REFERENCES people(id), topic INTEGER REFERENCES episodes(id), rating REAL );