intros
6 rows where person = 98
This data as json, CSV (advanced)
id ▲ | series | clip | person | task |
---|---|---|---|---|
548 | Series 15 15 | ▶ | Frankie Boyle 98 | Task bingo 734 |
553 | Series 15 15 | ▶ | Frankie Boyle 98 | Achieve an impressive effect with a single breath 724 |
558 | Series 15 15 | ▶ | Frankie Boyle 98 | Catch the potatoes in the potato hat 728 |
564 | Series 15 15 | ▶ | Frankie Boyle 98 | Pile the pineapples on the path 752 |
571 | Series 15 15 | ▶ | Frankie Boyle 98 | Make these things the same colour 757 |
580 | Series 15 15 | ▶ | Frankie Boyle 98 | Compose and perform a musical solo 722 |
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) );