episode_scores

10 rows where contestant = 33

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
171 The old soft curved padlock. 35 Alice Levine 33 18 1= 18 1=
176 Tarpeters. 36 Alice Levine 33 13 4= 31 3
181 One warm prawn. 37 Alice Levine 33 6 5 37 5
186 BMXing! 38 Alice Levine 33 23 2 60 4
191 H. 39 Alice Levine 33 16 5 76 5
196 We met at mealtimes. 40 Alice Levine 33 15 4 91 5
201 Roadkill doused in syrup. 41 Alice Levine 33 14 5 105 5
206 What kind of pictures? 42 Alice Levine 33 13 5 118 5
211 The Bubble Brothers. 43 Alice Levine 33 18 1 136 5
216 He was a different man. 44 Alice Levine 33 16 2 152 5

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