Skip to content
MySQL database of Doctor Who episodes and related data
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
README.md
doctor_who.sql

README.md

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.

CC0
To the extent possible under law, David 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
  • 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
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.