The group has been fairly busy during the past period. We held a meeting on the 16th March to look at the Access database option for interrogating the data and then discussed the practicalities of capturing census data into spreadsheets. Read the notes of the meeting here.
16 Mar 2012 Notes on the workshop Excel and Access
Helen and Carole held an informal meeting on the 29th of March to discuss the way forward and we decided that we would capture the census data from the years 1841, 1861, 1891 and 1911 into spreadsheets and then use this for various queries in Access. Before the data could be used it has to be checked for accuracy and several members have volunteered to do this for us. (see the meeting notes). We have also made copies of the original documents for this purpose and I am pleased to inform you that we have managed to capture the data for all the Census years plus for 1901 under the following headings (more or less)
No of household/Given name/Surname/Relationship/Age/Estimated birth year/Birth City/Birth Country.
The data has been uploaded to Google Documents and access to this has been given to Helen Ashdown as well.
Volunteers will be sent the data to check as agreed.
******************
Helen has also been experimenting with data in the Access database and has produced several query results which can be consulted here.
PLEASE INFORM ME OF ANY POTENTIAL COPYRIGHT INFRINGEMENTS
We have also finished transcribing the data from the Monumental inscriptions photographic project from 2008 and we are in the process of capturing the data from the “Register of Graves in the Burial Ground of the Terrington and Ganthorpe in Yorkshire” journal in a spreadsheet and will post this when completed.
Please let us know of any mistakes or updates required in these documents