taskmaster

Tables

attempts

id, task, contestant, PO, base, adjustment, points, rank, episode, series, team, location

3,975 rows

discrepancies

id, contestant, task, episode, series, observed, official

10 rows

episode_scores

id, episode, contestant, score, rank, series, srank

740 rows

episodes

id, series, episode, title, winner, air_date, studio_date, points, tasks, finale, TMI

148 rows

intros

id, series, clip, person, task

616 rows

measurements

id, task, contestant, measurement, objective

2,037 rows

normalized_scores

id, task, contestant, base, adjustment, points, rank, rigid, spread, scale, 5+3, 3+2, 3½+2½

3,975 rows

objectives

id, unit, target, label

179 rows

people

id, series, seat, name, dob, gender, hand, team, champion, TMI

117 rows

podcast

id, episode, guest, topic, rating

150 rows

profanity

id, series, episode, task, speaker, roots, quote, studio

2,041 rows

series

id, name, episodes, champion, air_start, air_end, studio_start, studio_end, points, tasks, special, TMI

23 rows

series_scores

id, series, contestant, score, rank

105 rows

special_locations

id, name, latlong

28 rows

task_briefs

id, task, brief

819 rows

task_readers

id, task, reader, team, live

300 rows

task_winners

id, task, winner, team, live

1,036 rows

tasks

id, series, episode, summary, tags, location, points, std, TMI, YT

819 rows

tasks_by_objective

id, task, objective

425 rows

team_tasks

id, task, team, win

190 rows

teams

id, series, members, size, initials, irregular

36 rows

title_coiners

id, episode, coiner, task

148 rows

Queries

Views

Download SQLite DB: taskmaster.db 876.0 KB