episode_scores
10 rows where contestant = 45
This data as json, CSV (advanced)
Suggested facets: score, rank, srank
| id ▲ | episode | contestant | score | rank | series | srank |
|---|---|---|---|---|---|---|
| 273 | Hello. 55 | Lou Sanders 45 | 20 | 1= | 20 | 1= |
| 278 | A novel about Russian Gulags. 56 | Lou Sanders 45 | 21 | 1 | 41 | 1 |
| 283 | Stuck in a mammal groove. 57 | Lou Sanders 45 | 19 | 1 | 60 | 1 |
| 288 | The barrel dad. 58 | Lou Sanders 45 | 15 | 1= | 75 | 1 |
| 293 | Stay humble. 59 | Lou Sanders 45 | 20 | 2= | 95 | 1 |
| 298 | Rock 'n' roll umlaut. 60 | Lou Sanders 45 | 12 | 3 | 107 | 1 |
| 303 | This is Trevor. 61 | Lou Sanders 45 | 13 | 2= | 120 | 1 |
| 308 | Aquatic sewing machine. 62 | Lou Sanders 45 | 12 | 3 | 132 | 1 |
| 313 | I've been a bit ill. 63 | Lou Sanders 45 | 20 | 1 | 152 | 1 |
| 318 | Clumpy swayey clumsy man. 64 | Lou Sanders 45 | 12 | 3= | 164 | 1 |
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 );