episode_scores

10 rows where contestant = 67

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, rank, srank

id ▲ episode contestant score rank series srank
430 It's not your fault. 86 Sarah Kendall 67 18 1 18 1
435 The Lure of the Treacle Puppies. 87 Sarah Kendall 67 17 2 35 2
440 Run up a tree to the moon. 88 Sarah Kendall 67 20 1 55 1
445 Premature conker. 89 Sarah Kendall 67 23 1 78 1
450 Slap and tong. 90 Sarah Kendall 67 12 4= 90 1
455 Absolute casserole. 91 Sarah Kendall 67 16 3 106 1
460 You've got no chutzpah. 92 Sarah Kendall 67 12 3= 118 1
465 An orderly species. 93 Sarah Kendall 67 12 4 130 1
470 Mr Octopus and Pottyhands. 94 Sarah Kendall 67 16 3 146 1
475 Activate Jamali. 95 Sarah Kendall 67 12 4= 158 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
);