Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
..
Failed to load latest commit information.
8-out-of-10-cats.csv
8-out-of-10-cats.md
8-out-of-10-cats.png
QI.csv
QI.md
QI.png
README.md
a-league-of-their-own.csv
a-league-of-their-own.md
a-league-of-their-own.png
argumental.csv
argumental.md
argumental.png
askrhodgilbert.csv
askrhodgilbert.md
askrhodgilbert.png
asyetuntitled.csv
asyetuntitled.md
asyetuntitled.png
bad-language.csv
bad-language.md
bad-language.png
best-behaviour.csv
best-behaviour.md
best-behaviour.png
big-fat-quiz.csv
big-fat-quiz.md
big-fat-quiz.png
bigask.csv
bigask.md
bigask.png
blame-game.csv
blame-game.md
blame-game.png
breakingthenews.csv
breakingthenews.md
breakingthenews.png
bring-me-the-head.csv
bring-me-the-head.md
call-my-bluff.csv
call-my-bluff.md
call-my-bluff.png
cats-does-countdown.csv
cats-does-countdown.md
cats-does-countdown.png
celebrityjuice.csv
celebrityjuice.md
celebrityjuice.png
dilemma.csv
dilemma.md
dilemma.png
does-the-team-think.csv
does-the-team-think.md
does-the-team-think.png
dogatemyhomework.csv
dogatemyhomework.md
dtrt.csv
dtrt.md
dtrt.png
duckquacks.csv
duckquacks.md
duckquacks.png
eureka.csv
eureka.md
fighting-talk.csv
fighting-talk.md
fighting-talk.png
game-of-two-halves.csv
game-of-two-halves.md
globalpillage.csv
globalpillage.md
globalpillage.png
go8bit.csv
go8bit.md
go8bit.png
gondolas.csv
gondolas.md
gqt.csv
gqt.md
gqt.png
heresy.csv
heresy.md
heresy.png
hignfy.csv
hignfy.md
hignfy.png
insert-name-here.csv
insert-name-here.md
insert-name-here.png
iot.csv
iot.md
iot.png
isihac.csv
isihac.md
isihac.png
its-not-me-its-you.csv
its-not-me-its-you.md
its-not-me-its-you.png
its-not-what-you-know.csv
its-not-what-you-know.md
its-not-what-you-know.png
its-only-a-theory.csv
its-only-a-theory.md
its-only-a-theory.png
justaminute.csv
justaminute.md
justaminute.png
listomania.csv
listomania.md
listomania.png
loosewomen.csv
loosewomen.md
loosewomen.png
media-circus.csv
media-circus.md
mocktheweek.csv
mocktheweek.md
mocktheweek.png
never-mind-the-buzzcocks.csv
never-mind-the-buzzcocks.md
never-mind-the-buzzcocks.png
newsquiz.csv
newsquiz.md
newsquiz.png
out-of-order.csv
out-of-order.md
out-of-order.png
petrolheads.csv
petrolheads.md
petrolheads.png
petticoat-line.csv
petticoat-line.md
petticoat-line.png
playtothewhistle.csv
playtothewhistle.md
playtothewhistle.png
qanda.csv
qanda.md
qos.csv
qos.md
qos.png
question-time.csv
question-time.md
question-time.png
safeword.csv
safeword.md
safeword.png
shootingstars.csv
shootingstars.md
shootingstars.png
spicks-and-specks.csv
spicks-and-specks.md
sweatthesmallstuff.csv
sweatthesmallstuff.md
sweatthesmallstuff.png
taskmaster.csv
taskmaster.md
taskmaster.png
the-infinite-monkey-cage.csv
the-infinite-monkey-cage.md
the-infinite-monkey-cage.png
the-last-leg.csv
the-last-leg.md
the-last-leg.png
the-panel.csv
the-panel.md
the-unbelievable-truth.csv
the-unbelievable-truth.md
the-unbelievable-truth.png
they-think-its-all-over.csv
they-think-its-all-over.md
they-think-its-all-over.png
virtuallyfamous.csv
virtuallyfamous.md
virtuallyfamous.png
whatthedickens.csv
whatthedickens.md
whatthedickens.png
whose-line-is-it-anyway.csv
whose-line-is-it-anyway.md
whose-line-is-it-anyway.png
wouldilietoyou.csv
wouldilietoyou.md
wouldilietoyou.png

README.md

Data format

The data are stored in csv files. Each line contains the episode ID, the air date, a list of participants, and a URL reference for the listing.

  • The episode ID is usually the series and the episode number within the series e.g. 2x05. Some shows don't really have easily identifiable series (e.g. Question Time) so other IDs have been used such as their episode ID on BBC iPlayer or the air date.
  • The date is stored as YYYY-MM-DD.
  • The participants are semi-colon separated. Each entry is in the form "xxxxxxxx:YYYYY ZZZZZZ (AAAAA - BBBBB)".
    • xxxxxxxx - a unique ID for the person. This is to help disambiguate people with the same name i.e. there are several different Peter Jones'. The IDs are in the master list of people.
    • YYYYY ZZZZZZZ - the participant's name (preferably as it appears in the listings). This will not be consistent between episodes as sometimes people are given titles (MP, MEP, MSP, Baroness, Lord etc) or change their name (marriage, stage/real names etc). The unique ID should be used to consistently match people across episodes/shows.
    • AAAAA - a gender signifier e.g. Himself/Herself/Themselves etc
    • BBBBB - an optional role they had in the episode e.g. "Host" or "Team Captain"
  • It is good to have references, so this field contains a link (or links) to sources on the web for this specific episode e.g. iPlayer, BBC Genome, comedy.co.uk etc