episode_scores

5 rows where episode = 103

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, series, srank

id ▲ episode contestant score rank series srank
511 A couple of Ethels. 103 Alan Davies 68 21 1= 131 2=
512 A couple of Ethels. 103 Desiree Burch 69 9 4= 119 4
513 A couple of Ethels. 103 Guz Khan 70 21 1= 131 2=
514 A couple of Ethels. 103 Morgana Robinson 71 19 3 132 1
515 A couple of Ethels. 103 Victoria Coren Mitchell 72 9 4= 100 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
);