episode_scores
10 rows where contestant = 46
This data as json, CSV (advanced)
| id ▲ | episode | contestant | score | rank | series | srank |
|---|---|---|---|---|---|---|
| 274 | Hello. 55 | Paul Sinha 46 | 10 | 5 | 10 | 5 |
| 279 | A novel about Russian Gulags. 56 | Paul Sinha 46 | 19 | 3 | 29 | 5 |
| 284 | Stuck in a mammal groove. 57 | Paul Sinha 46 | 11 | 4 | 40 | 5 |
| 289 | The barrel dad. 58 | Paul Sinha 46 | 11 | 4 | 51 | 5 |
| 294 | Stay humble. 59 | Paul Sinha 46 | 14 | 5 | 65 | 5 |
| 299 | Rock 'n' roll umlaut. 60 | Paul Sinha 46 | 9 | 5 | 74 | 5 |
| 304 | This is Trevor. 61 | Paul Sinha 46 | 13 | 2= | 87 | 5 |
| 309 | Aquatic sewing machine. 62 | Paul Sinha 46 | 21 | 1 | 108 | 5 |
| 314 | I've been a bit ill. 63 | Paul Sinha 46 | 17 | 3 | 125 | 5 |
| 319 | Clumpy swayey clumsy man. 64 | Paul Sinha 46 | 11 | 5 | 136 | 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 );