Capital Trials at the Old Bailey

• Accused
• • one record for every individual, so slightly fewer records than the number of trials, as a small number of individuals will be involved in more than one trial
  • accused_id (primary key)
  • surname
  • given name
  • gender
  • age
• AKA
• • one record for every instance of an alias name, the same aka name may point to different accuseds and one accused may have more than one AKA
  • aka_id (primary key)
  • name
  • accused_id
• Trial
• • one record for every trial
  • trial_id (primary key)
  • case_number (used to link trials together where individuals were tried together)
  • sources
  • notes
  • trial_date_start
  • trial_date_end
  • Jury
  • accused_id_fk
  • respited (a Boolean indicator for the respited larcenies)
• Recorder_report
• • ?one record for every trial
  • recorder_report_id (primary key)
  • report_text
  • footnote
  • trial_id_fk
• Crime
• • one record for every charge, total slightly higher than number of trials as some trials included 2+ charges
  • crime_id (primary key)
  • crime_description
  • crime_details
  • trial_id_fk
• Respite_sentence
• • one record for every respite of sentence, total slightly higher than number of trials as some trials included 2+ respites
  • respite_id (primary key)
  • respite_decision
  • trial_id_fk
• Outcome
• • one record for every trial OR one record for every outcome, total slightly higher than number of trials as some trials included 2+ outcomes
  • outcome_id (primary key)
  • type (execution, pardon, died, other)
  • date
  • description
  • location
  • further_notes
  • reference
  • trial _id_fk

The database for the Bailey project has been created on csmgenr2. We're now ready to start creating tables. Over the past couple of months, I have been working with Simon Devereau on the kinds of queries the db needs to support and anomolous fields and records and with Clifton on the table design.

A number of earlier posts on this project can be found by going to the depts blog and searching for the word "Bailey". Here are the titles of those postings from most recent to earliest:

• estimate of data preparation for Bailey db
• further review of Bailey data
• look through Old Bailey records again
• revise structure for Old Bailey database
• find unconventional data in OldBailey listing
• preliminary meeting on OldBaileyCapitalCrimes proposal