episode_scores

10 rows where contestant = 40

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
223 The mean bean. 45 Kerry Godliman 40 20 1 20 1
228 My eyes are circles. 46 Kerry Godliman 40 23 1= 43 1
233 Twelve blush majesty two. 47 Kerry Godliman 40 17 2 60 1
238 OLLIE. 48 Kerry Godliman 40 16 3= 76 1
243 Lotta soup. 49 Kerry Godliman 40 17 4 93 1=
248 A coquettish fascinator. 50 Kerry Godliman 40 17 3= 110 1
253 The perfect stuff. 51 Kerry Godliman 40 14 5 124 2=
258 Mother honks her horn. 52 Kerry Godliman 40 16 3= 140 3
263 The pendulum draws the eye. 53 Kerry Godliman 40 21 1 161 2
268 I can hear it gooping. 54 Kerry Godliman 40 15 2 176 1

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