Updated schema; wrote XSLT to transform old dates

Posted by on 15 Aug 2011 in Activity Log

Updated the schema to use the new standard date format (YYYY-MM-DD) in all date fields, namely trial_file_start_date, trial_file_end_date, respite_rr_date, and outcome_date. I wrote an XSLT transformation to convert the dates in the otherwise-valid data files to the new format. I also modified the PHP import script so that it no longer does any date conversion.

This entry was posted by Jamie 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.