intros

6 rows where person = 42

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ series clip person task
247 Series 7 7 ▶ Rhod Gilbert 42 Write a ten word story while running 271
256 Series 7 7 ▶ Rhod Gilbert 42 Don’t blink 302
265 Series 7 7 ▶ Rhod Gilbert 42 Predict what another contestant will do with an object 273
271 Series 7 7 ▶ Rhod Gilbert 42 Paint a blindfolded still life 272
273 Series 7 7 ▶ Rhod Gilbert 42 Draw the biggest and best circle 274
282 Series 7 7 ▶ Rhod Gilbert 42 Change your appearance in a lift 284

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE intros (
   id     INTEGER PRIMARY KEY,
   series INTEGER REFERENCES series(id),
   clip   INTEGER,
   person INTEGER REFERENCES people(id),
   task   INTEGER REFERENCES tasks(id)
);