episode_scores

10 rows where contestant = 47

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
275 Hello. 55 Sian Gibson 47 16 3 16 3
280 A novel about Russian Gulags. 56 Sian Gibson 47 16 4 32 3=
285 Stuck in a mammal groove. 57 Sian Gibson 47 16 3 48 3
290 The barrel dad. 58 Sian Gibson 47 15 1= 63 2
295 Stay humble. 59 Sian Gibson 47 17 4 80 3
300 Rock 'n' roll umlaut. 60 Sian Gibson 47 15 1 95 2
305 This is Trevor. 61 Sian Gibson 47 11 4 106 3
310 Aquatic sewing machine. 62 Sian Gibson 47 8 4 114 4
315 I've been a bit ill. 63 Sian Gibson 47 16 4= 130 4
320 Clumpy swayey clumsy man. 64 Sian Gibson 47 13 2 143 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
);