episode_scores

10 rows where contestant = 72

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank

id ▲ episode contestant score rank series srank
480 An imbalance in the poppability. 96 Victoria Coren Mitchell 72 12 5 12 5
485 Oatmeal and death. 97 Victoria Coren Mitchell 72 13 5 25 5
490 The end of the franchise. 98 Victoria Coren Mitchell 72 13 5 38 5
495 The customised inhaler. 99 Victoria Coren Mitchell 72 16 2 54 5
500 Croissants is croissants. 100 Victoria Coren Mitchell 72 10 4 64 5
505 A chair in a sweet. 101 Victoria Coren Mitchell 72 9 5 73 5
510 The integrity of the product. 102 Victoria Coren Mitchell 72 18 1 91 5
515 A couple of Ethels. 103 Victoria Coren Mitchell 72 9 4= 100 5
520 Nothing matters. 104 Victoria Coren Mitchell 72 8 5 108 5
525 Caring Uncle Minpict. 105 Victoria Coren Mitchell 72 13 5 121 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
);