update table specs

Posted by on 24 Jan 2008 in Activity Log

updated the table and field specification based on input from Simon and based on Clifton's table structure. Will review the BaileyCapitalTrials.txt file with Clifton and then we can make necessary modifications to the mysql tables themselves.

Waiting on Simon to provide lists of normalized crimes, respites, and outcomes. We'll then either use data provided by Simon with that information or will generate some based on the 1790s records we have.

This entry was posted by Stewart and filed under Activity Log.

Capital Trials at the Old Bailey

Simon Devereaux has approximately 10,000 records of people convicted in potentially capital cases between 1710 and 1840 in London heard at the Old Bailey court. This project will create a web-based database which will allow interested researchers and members of the public to compose queries on that data (e.g. women charged with robbery 1710-1720). It must be able to support a range of queries and produce output allowing researchers to identify trends in judicial practice over that time.