revised xslt to generate SQL, and tables

Posted by on 12 Mar 2010 in Activity Log

Started work on revising the bailey_add_id_xsl file. It's now processing all but the aliases and mercy_appeals. The date conversion function is not working Did extensive changes to the database. Added necessary lookup tables, fields to existing lookup tables and values to all lookup tables. Cleaned out all records in the crimes, trials etc. tables (i.e. those populated from the data files) and then changed the fieldtype on their ID fields from varchar to int. Changed the table type on all tables to innoDB. Have not yet formally created the foreign-key connections.

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.