episode_scores

10 rows where contestant = 42

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
225 The mean bean. 45 Rhod Gilbert 42 19 2 19 2
230 My eyes are circles. 46 Rhod Gilbert 42 22 3 41 2
235 Twelve blush majesty two. 47 Rhod Gilbert 42 9 5 50 3
240 OLLIE. 48 Rhod Gilbert 42 17 1= 67 3
245 Lotta soup. 49 Rhod Gilbert 42 18 3 85 3
250 A coquettish fascinator. 50 Rhod Gilbert 42 18 2 103 3
255 The perfect stuff. 51 Rhod Gilbert 42 21 1 124 2=
260 Mother honks her horn. 52 Rhod Gilbert 42 20 1 144 2
265 The pendulum draws the eye. 53 Rhod Gilbert 42 9 5 153 3
270 I can hear it gooping. 54 Rhod Gilbert 42 14 3 167 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
);