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) );