episode_scores

5 rows where episode = 5

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ episode contestant score rank series srank
21 Little denim shorts. 5 Frank Skinner 3 20 1 77 3
22 Little denim shorts. 5 Josh Widdicombe 4 18 2 85 1
23 Little denim shorts. 5 Roisin Conaty 5 14 4 60 5
24 Little denim shorts. 5 Romesh Ranganathan 6 16 3 81 2
25 Little denim shorts. 5 Tim Key 7 10 5 70 4

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
);