episodes

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

10 rows where series = 10

✎ 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
75 Series 10 10 1 God's haemorrhoid. Richard Herring 57 2020-10-15 2020-07-27 47 5 ➚
76 Series 10 10 2 A documentary about a despot. Katherine Parkinson 55 2020-10-22 2020-07-27 87 5 ➚
77 Series 10 10 3 Point of swivel. Daisy May Cooper 53 2020-10-29 2020-07-28 72 5 ➚
78 Series 10 10 4 Toshwash. Daisy May Cooper 53 2020-11-05 2020-07-28 77 5 ➚
79 Series 10 10 5 I hate your trainers. Richard Herring 57 2020-11-12 2020-07-29 102 6 ➚
80 Series 10 10 6 Hippopotamus. Mawaan Rizwan 56 2020-11-19 2020-07-29 77 5 ➚
81 Series 10 10 7 Legit glass. Johnny Vegas 54 2020-11-26 2020-07-30 65 5 ➚
82 Series 10 10 8 Moments of silence. Richard Herring 57 2020-12-03 2020-07-30 59 5 ➚
83 Series 10 10 9 Air Horn Andy. Richard Herring 57 2020-12-10 2020-07-31 74 5 ➚
84 Series 10 10 10 Dog meat trifle. Richard Herring 57 2020-12-17 2020-07-31 68 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
);