episode_scores

10 rows where contestant = 68

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
476 An imbalance in the poppability. 96 Alan Davies 68 15 3 15 3
481 Oatmeal and death. 97 Alan Davies 68 16 3= 31 4
486 The end of the franchise. 98 Alan Davies 68 14 3= 45 4
491 The customised inhaler. 99 Alan Davies 68 21 1 66 2
496 Croissants is croissants. 100 Alan Davies 68 14 3 80 3
501 A chair in a sweet. 101 Alan Davies 68 14 4 94 3
506 The integrity of the product. 102 Alan Davies 68 16 3 110 2=
511 A couple of Ethels. 103 Alan Davies 68 21 1= 131 2=
516 Nothing matters. 104 Alan Davies 68 11 4 142 3
521 Caring Uncle Minpict. 105 Alan Davies 68 19 3 161 3=

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