series
- tasks
- the number of "standard" tasks (those having five judged attempts) in this series
1 row where champion = 105 sorted by air_start
This data as json, CSV (advanced)
Suggested facets: air_start (date), air_end (date), studio_start (date), studio_end (date)
id | name | episodes | champion | air_start ▲ | air_end | studio_start | studio_end | points | tasks | special | TMI |
---|---|---|---|---|---|---|---|---|---|---|---|
16 | Series 16 | 10 | Sam Campbell 105 | 2023-09-21 | 2023-11-23 | 2023-05-02 | 2023-05-12 | 721 | 50 | ➚ |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE series ( id INTEGER PRIMARY KEY, name TEXT, episodes INTEGER, champion INTEGER REFERENCES people(id), air_start TEXT, air_end TEXT, studio_start TEXT, studio_end TEXT, points INTEGER, tasks INTEGER, special INTEGER, TMI INTEGER );