episode_scores
10 rows where contestant = 99
This data as json, CSV (advanced)
Suggested facets: score, rank, srank
id ▲ | episode | contestant | score | rank | series | srank |
---|---|---|---|---|---|---|
642 | The curse of politeness. 129 | Ivo Graham 99 | 9 | 5 | 9 | 5 |
647 | Trapped in a loveless marriage. 130 | Ivo Graham 99 | 17 | 1 | 26 | 5 |
652 | I love to squander promise. 131 | Ivo Graham 99 | 21 | 1 | 47 | 3 |
657 | How heavy is the water? 132 | Ivo Graham 99 | 7 | 5 | 54 | 4 |
662 | Old Honkfoot. 133 | Ivo Graham 99 | 9 | 5 | 63 | 5 |
667 | It's my milk now. 134 | Ivo Graham 99 | 14 | 3 | 77 | 5 |
672 | Schrödinger's egg. 135 | Ivo Graham 99 | 14 | 4 | 91 | 5 |
677 | 100% Bosco. 136 | Ivo Graham 99 | 12 | 5 | 103 | 5 |
682 | A show about pedantry. 137 | Ivo Graham 99 | 16 | 3 | 119 | 5 |
687 | A yardstick for failure. 138 | Ivo Graham 99 | 12 | 3 | 131 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );