episodes

Table actions
tasks
the number of "standard" tasks (those having five judged attempts) in this episode

10 rows where series = 6

✎ View and edit SQL

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

CSV options: 

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
);