episodes

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

5 rows where winner = 57

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: studio_date, 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 ➚
79 Series 10 10 5 I hate your trainers. Richard Herring 57 2020-11-12 2020-07-29 102 6 ➚
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
);