episode_scores

5 rows where episode = 143

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ episode contestant score rank series srank
711 Skateboard Division. 143 Julian Clary 103 15 1 86 2
712 Skateboard Division. 143 Lucy Beaumont 104 7 5 65 4
713 Skateboard Division. 143 Sam Campbell 105 14 2 88 1
714 Skateboard Division. 143 Sue Perkins 106 12 4 72 3
715 Skateboard Division. 143 Susan Wokoma 107 13 3 63 5

Advanced export

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

CSV options: 

CREATE TABLE episode_scores (
   id         INTEGER PRIMARY KEY,
   episode    INTEGER REFERENCES episodes(id),
   contestant INTEGER REFERENCES people(id),
   score      INTEGER,
   rank       TEXT,
   series     INTEGER,
   srank      TEXT
);