episode_scores

10 rows where contestant = 37

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
175 The old soft curved padlock. 35 Tim Vine 37 11 4 11 4
180 Tarpeters. 36 Tim Vine 37 14 2= 25 4
185 One warm prawn. 37 Tim Vine 37 15 4 40 3=
190 BMXing! 38 Tim Vine 37 21 3 61 3
195 H. 39 Tim Vine 37 26 1 87 3
200 We met at mealtimes. 40 Tim Vine 37 23 1 110 2
205 Roadkill doused in syrup. 41 Tim Vine 37 20 2 130 2
210 What kind of pictures? 42 Tim Vine 37 16 3= 146 2
215 The Bubble Brothers. 43 Tim Vine 37 16 2 162 2
220 He was a different man. 44 Tim Vine 37 13 3 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
);