episodes
- tasks
- the number of "standard" tasks (those having five judged attempts) in this episode
8 rows where series = 5
This data as json, CSV (advanced)
Suggested facets: winner, studio_date, points, tasks, finale, air_date (date), studio_date (date)
id ▲ | series | episode | title | winner | air_date | studio_date | points | tasks | finale | TMI |
---|---|---|---|---|---|---|---|---|---|---|
25 | Series 5 5 | 1 | Dignity intact. | Bob Mortimer 24 | 2017-09-13 | 2017-07-03 | 75 | 5 | ➚ | |
26 | Series 5 5 | 2 | The leprechaun or the lesbian. | Sally Phillips 27 | 2017-09-20 | 2017-07-03 | 91 | 6 | ➚ | |
27 | Series 5 5 | 3 | Phoenix. | Bob Mortimer 24 | 2017-09-27 | 2017-07-04 | 73 | 5 | ➚ | |
28 | Series 5 5 | 4 | Residue around the hoof. | Mark Watson 25 | 2017-10-04 | 2017-07-04 | 96 | 7 | ➚ | |
29 | Series 5 5 | 5 | A wind-dried puffin. | Mark Watson 25 | 2017-10-11 | 2017-07-05 | 72 | 5 | ➚ | |
30 | Series 5 5 | 6 | Spoony Neeson. | Sally Phillips 27 | 2017-10-18 | 2017-07-05 | 78 | 5 | ➚ | |
31 | Series 5 5 | 7 | Boing boing. | Bob Mortimer 24 | 2017-10-25 | 2017-07-06 | 78 | 6 | ➚ | |
32 | Series 5 5 | 8 | Their water's so delicious. | Sally Phillips 27 | 2017-11-01 | 2017-07-06 | 68 | 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 );