Some clarification from PD about how language fields work in the 1911 data. There are two language fields: 1st language spoken and 2nd language spoken. I had mistakingly thought that 1st language spoken was equivalent to the "mother tongue" of previous years and imported it as such. I had also made a new "secondary_language" field in the 1911 table and in all of the views. PD, however, informs me that, in fact, there is no "mother tongue" in the 1911 census and "1st language spoken" and "2nd language spoken" are new fields. So, I've modified the 1911 census table and all of the census views as follows: - census_1911 table: renamed "mother_tongue_id" to "first_language_id"; renamed "secondary_language_id" to "second_language_id" - view for census 1911: converted mother_tongue and mother_tongue_id to NULL fields - views for all census years: renamed "secondary_language_id" to "second_language_id"; added "first_language_id" and "first_language" as NULL fields to all years previous to 1911
This entry was posted by and is filed under Activity log.