Doctor Who Episode Database

SQL database of Doctor Who episodes and related data. Currently used by the Catalogopolis API.

License

Public domain. Collections of facts can’t be copywritten. But since licensing may be an issue for some people attempting to use this data, I’ve made it available under CC0.

To the extent possible under law,

Dana Ross
has waived all copyright and related or neighboring rights to
Doctor Who Episode Database.
This work is published from:

United States.

Tables

actors

id : a sequentially assigned database ID
uuid : a unique ID to identify records outside the database
name
gender

doctors

id
incarnation
primary_actor

serials

id
season_id
story
serial
title
production_code

episodes

id
title
serial_id
story
episode_order
original_air_date
runtime
uk_viewers_mm
appreciation_index
missing
recreated

seasons

id
name

companions

id
name
actor

directors

id
name

writers

id
name

serials_doctors

serial_id
doctor_id

serials_companions

serial_id
companion_id

serials_directors

serial_id
director_id

serials_writers

serial_id
writer_id

UUIDs

Use this tool to generate decimal UUIDs when creating or updating records: https://onlinerandomtools.com/generate-random-uuid?chain=remove-string-punctuation%2Cconvert-hex-to-decimal&count=100