intros
4 rows where task = 501
This data as json, CSV (advanced)
id ▲ | series | clip | person | task |
---|---|---|---|---|
407 | Series 11 11 | ▶ | Mike Wozniak 66 | Make the sauna stones hiss 501 |
410 | Series 11 11 | ▶ | Jamali Maddix 64 | Make the sauna stones hiss 501 |
416 | Series 11 11 | ▶ | Charlotte Ritchie 63 | Make the sauna stones hiss 501 |
429 | Series 11 11 | ▶ | Lee Mack 65 | Make the sauna stones hiss 501 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE intros ( id INTEGER PRIMARY KEY, series INTEGER REFERENCES series(id), clip INTEGER, person INTEGER REFERENCES people(id), task INTEGER REFERENCES tasks(id) );