episode_scores

10 rows where contestant = 34

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
172 The old soft curved padlock. 35 Asim Chaudhry 34 8 5 8 5
177 Tarpeters. 36 Asim Chaudhry 34 13 4= 21 5
182 One warm prawn. 37 Asim Chaudhry 34 19 2 40 3=
187 BMXing! 38 Asim Chaudhry 34 18 5 58 5
192 H. 39 Asim Chaudhry 34 19 4 77 4
197 We met at mealtimes. 40 Asim Chaudhry 34 17 3 94 4
202 Roadkill doused in syrup. 41 Asim Chaudhry 34 15 4 109 4
207 What kind of pictures? 42 Asim Chaudhry 34 16 3= 125 4
212 The Bubble Brothers. 43 Asim Chaudhry 34 12 5 137 4
217 He was a different man. 44 Asim Chaudhry 34 22 1 159 4

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