Skip to content

dana-ross/doctor-who-episodes

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

72 Commits
 
 
 
 

Repository files navigation

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, 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

Releases

No releases published

Packages

No packages published