Web-based search rebuild

Posted by on 24 Jan 2011 in Activity Log

Started the rebuild of the web-based 'query builder' search tool. Stew's SQL structure was for the most part complete, except for a missing jury_id_fk field in the trials table to point to the juries table. Other than that, the SQL structure is as Stew left it, though that may change at some point during the rebuild. For the search itself, I'm starting from scratch and building some PHP classes to handle building the complex search queries.

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.