intros
6 rows where person = 24
This data as json, CSV (advanced)
id ▲ | series | clip | person | task |
---|---|---|---|---|
176 | Series 5 5 | ▶ | Bob Mortimer 24 | Build a can tower & greet Alex from different countries 174 |
181 | Series 5 5 | ▶ | Bob Mortimer 24 | Score a basket without your hands 149 |
186 | Series 5 5 | ▶ | Bob Mortimer 24 | Make marmite 163 |
188 | Series 5 5 | ▶ | Bob Mortimer 24 | Create the greatest splat 155 |
193 | Series 5 5 | ▶ | Bob Mortimer 24 | Transport a coconut as far as possible 190 |
206 | Series 5 5 | ▶ | Bob Mortimer 24 | Coconut bobsleigh 185 |
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) );