episodes
- tasks
- the number of "standard" tasks (those having five judged attempts) in this episode
10 rows where series = 6
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 |
---|---|---|---|---|---|---|---|---|---|---|
35 | Series 6 6 | 1 | The old soft curved padlock. | Alice Levine 33 | 2018-05-02 | 2018-03-22 | 72 | 5 | ➚ | |
36 | Series 6 6 | 2 | Tarpeters. | Liza Tarbuck 35 | 2018-05-09 | 2018-03-22 | 73 | 6 | ➚ | |
37 | Series 6 6 | 3 | One warm prawn. | Liza Tarbuck 35 | 2018-05-16 | 2018-03-23 | 78 | 5 | ➚ | |
38 | Series 6 6 | 4 | BMXing! | Russell Howard 36 | 2018-05-23 | 2018-03-23 | 106 | 7 | ➚ | |
39 | Series 6 6 | 5 | H. | Tim Vine 37 | 2018-05-30 | 2018-03-26 | 107 | 6 | ➚ | |
40 | Series 6 6 | 6 | We met at mealtimes. | Tim Vine 37 | 2018-06-06 | 2018-03-26 | 87 | 6 | ➚ | |
41 | Series 6 6 | 7 | Roadkill doused in syrup. | Russell Howard 36 | 2018-06-13 | 2018-03-27 | 87 | 6 | ➚ | |
42 | Series 6 6 | 8 | What kind of pictures? | Russell Howard 36 | 2018-06-20 | 2018-03-27 | 79 | 5 | ➚ | |
43 | Series 6 6 | 9 | The Bubble Brothers. | Alice Levine 33 | 2018-06-27 | 2018-03-28 | 75 | 6 | ➚ | |
44 | Series 6 6 | 10 | He was a different man. | Asim Chaudhry 34 | 2018-07-04 | 2018-03-28 | 73 | 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 );