series

tasks

the number of "standard" tasks (those having five judged attempts) in this series

1 row where episodes = 0, special = 1 and "studio_end" is on date 2023-11-27 sorted by air_start

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: air_start (date), air_end (date), studio_start (date), studio_end (date)

CREATE TABLE series (
   id           INTEGER PRIMARY KEY,
   name         TEXT,
   episodes     INTEGER,
   champion     INTEGER REFERENCES people(id),
   air_start    TEXT,
   air_end      TEXT,
   studio_start TEXT,
   studio_end   TEXT,
   points       INTEGER,
   tasks        INTEGER,
   special      INTEGER,
   TMI          INTEGER
);