episodes
- tasks
- the number of "standard" tasks (those having five judged attempts) in this episode
2 rows where winner = 69
This data as json, CSV (advanced)
Suggested facets: air_date (date)
id ▲ | series | episode | title | winner | air_date | studio_date | points | tasks | finale | TMI |
---|---|---|---|---|---|---|---|---|---|---|
98 | Series 12 12 | 3 | The end of the franchise. | Desiree Burch 69 | 2021-10-07 | 80 | 5 | ➚ | ||
104 | Series 12 12 | 9 | Nothing matters. | Desiree Burch 69 | 2021-11-18 | 72 | 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 );