episode_scores

10 rows where contestant = 35

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
173 The old soft curved padlock. 35 Liza Tarbuck 35 17 3 17 3
178 Tarpeters. 36 Liza Tarbuck 35 19 1 36 1
183 One warm prawn. 37 Liza Tarbuck 35 22 1 58 1
188 BMXing! 38 Liza Tarbuck 35 20 4 78 1
193 H. 39 Liza Tarbuck 35 25 2 103 1
198 We met at mealtimes. 40 Liza Tarbuck 35 20 2 123 1
203 Roadkill doused in syrup. 41 Liza Tarbuck 35 17 3 140 1
208 What kind of pictures? 42 Liza Tarbuck 35 17 1= 157 1
213 The Bubble Brothers. 43 Liza Tarbuck 35 14 4 171 1
218 He was a different man. 44 Liza Tarbuck 35 10 5 181 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
);