episode_scores

10 rows where contestant = 36

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
174 The old soft curved padlock. 35 Russell Howard 36 18 1= 18 1=
179 Tarpeters. 36 Russell Howard 36 14 2= 32 2
184 One warm prawn. 37 Russell Howard 36 16 3 48 2
189 BMXing! 38 Russell Howard 36 24 1 72 2
194 H. 39 Russell Howard 36 21 3 93 2
199 We met at mealtimes. 40 Russell Howard 36 12 5 105 3
204 Roadkill doused in syrup. 41 Russell Howard 36 21 1 126 3
209 What kind of pictures? 42 Russell Howard 36 17 1= 143 3
214 The Bubble Brothers. 43 Russell Howard 36 15 3 158 3
219 He was a different man. 44 Russell Howard 36 12 4 170 3

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