episode_scores

10 rows where contestant = 39

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
222 The mean bean. 45 Jessica Knappett 39 14 3 14 3
227 My eyes are circles. 46 Jessica Knappett 39 23 1= 37 3
232 Twelve blush majesty two. 47 Jessica Knappett 39 15 3= 52 2
237 OLLIE. 48 Jessica Knappett 39 16 3= 68 2
242 Lotta soup. 49 Jessica Knappett 39 25 1 93 1=
247 A coquettish fascinator. 50 Jessica Knappett 39 16 5 109 2
252 The perfect stuff. 51 Jessica Knappett 39 18 2 127 1
257 Mother honks her horn. 52 Jessica Knappett 39 19 2 146 1
262 The pendulum draws the eye. 53 Jessica Knappett 39 18 2 164 1
267 I can hear it gooping. 54 Jessica Knappett 39 11 5 175 2

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