episodes
- tasks
- the number of "standard" tasks (those having five judged attempts) in this episode
3 rows where winner = 43
This data as json, CSV (advanced)
Suggested facets: tasks, finale, air_date (date), studio_date (date)
id ▲ | series | episode | title | winner | air_date | studio_date | points | tasks | finale | TMI |
---|---|---|---|---|---|---|---|---|---|---|
55 | Series 8 8 | 1 | Hello. | Iain Stirling 43 | 2019-05-08 | 2019-03-21 | 78 | 5 | ➚ | |
59 | Series 8 8 | 5 | Stay humble. | Iain Stirling 43 | 2019-06-05 | 2019-03-25 | 92 | 6 | ➚ | |
64 | Series 8 8 | 10 | Clumpy swayey clumsy man. | Iain Stirling 43 | 2019-07-10 | 2019-03-27 | 66 | 5 | ✓ | ➚ |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE episodes ( id INTEGER PRIMARY KEY, series INTEGER REFERENCES series(id), episode INTEGER, title TEXT, winner INTEGER REFERENCES people(id), air_date TEXT, studio_date TEXT, points INTEGER, tasks INTEGER, finale INTEGER, TMI INTEGER );