intros
5 rows where person = 80
This data as json, CSV (advanced)
id ▲ | series | clip | person | task |
---|---|---|---|---|
479 | Series 13 13 | ▶ | Chris Ramsey 80 | Guess Shoe 614 |
486 | Series 13 13 | ▶ | Chris Ramsey 80 | Get the most ducks in Alex's basket 649 |
492 | Series 13 13 | ▶ | Chris Ramsey 80 | Recreate a historical moment using traffic cones 609 |
497 | Series 13 13 | ▶ | Chris Ramsey 80 | Create an edible sculpture 634 |
504 | Series 13 13 | ▶ | Chris Ramsey 80 | Find all ten ducks in the lab 599 |
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) );