intros
5 rows where person = 65
This data as json, CSV (advanced)
id ▲ | series | clip | person | task |
---|---|---|---|---|
408 | Series 11 11 | ▶ | Lee Mack 65 | Make the best uniform for this bee 512 |
418 | Series 11 11 | ▶ | Lee Mack 65 | Complete various tasks while saying ‘metronome’ 528 |
421 | Series 11 11 | ▶ | Lee Mack 65 | Make the balloon hover 496 |
429 | Series 11 11 | ▶ | Lee Mack 65 | Make the sauna stones hiss 501 |
435 | Series 11 11 | ▶ | Lee Mack 65 | Appear as different as possible in four photos 535 |
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) );