Relationship to Head dictionary for ICEM data

Table ID:
ICEM_HEADREL_CODEBOOK     (1250944)
Contents:
Relationship to Head dictionary for ICEM data
Approx. number of rows:
108,492
Table type:
Codebook
Documentation Author:
Paula Aucott

Sources:

  1. This meta-data file "Relationship to Head dictionary" was downloaded in spreadsheet format on the 26th November 2015 from the website of the Integrated Census Microdata (I-CeM) project based at the University of Essex. http://www.essex.ac.uk/history/research/ICeM/documentation.html


Notes:

  1. This table covers England and Wales 1891-1911 and Scotland 1891-1901.
  2. Numeric codes identifying the relationship to the head of household used within the Icem project are as follows for residential kin: Head (gender unspecified) = 10, Head (male) = 11, Head (female) = 12, Spouse = 20, Husband = 21, Wife = 22, Mistress = 28, Child = 30, Son = 31, Daughter = 32, Step son = 33, Step daughter = 34, Son in law = 35, Daughter in law = 36, Adopted/fostered son = 37, Adopted/fostered daughter = 38, Nephew/niece = 40, Nephew = 41, Niece = 42, Step nephew = 43, Step niece = 44, Nieces husband = 45, Nephews wife = 46, Adopted nephew = 47, Adopted niece = 48, 1st cousin once removed 50 = 50, 1st cousin once removed (downwards) i.e., cousins son = 51, 1st cousin once removed (downwards) i.e., cousins daughter = 52, Grandchild = 60, Grandson = 61, Granddaughter = 62, Grand stepson = 63, Grand stepdaughter = 64, Granddaughters husband = 65, Grandsons wife = 66, Adopted grandson = 67, Adopted granddaughter = 68, Great nephew/niece = 70, Great nephew = 71, Great niece = 72, Great step nephew = 73, Great step niece = 74, Great nephew in law = 75, Great niece in law = 76, Great grandchild = 80, Great grandson = 81, Great granddaughter = 82, Grandparent = 110, Grandfather = 111, Grandmother = 112, Step grandfather = 113, Step grandmother = 114, Grandfather in law = 115, Grandmother in law = 116, Parent = 120, Father = 121, Mother = 122, Step father = 123, Step mother = 124, Father in law = 125, Mother in law = 126, Adoptive father = 127, Adoptive mother = 128, Uncle = 131, Aunt = 132, Step uncle = 133, Step aunt = 134, Uncle in law = 135, Aunt in law = 136, Great uncle = 141, Great aunt = 142, Brother = 151, Sister = 152, Step brother = 153, Step sister = 154, Brother in law = 155, Sister in law = 156, Half brother = 157, Half sister = 158, First cousin = 160, Second cousin = 170, Miscellaneous relative = 190.
  3. Numeric codes identifying the relationship to the head of household used within the Icem project for residents without kinship ties: Visitor = 2000, Visitors families = 2010-2199, Inmate = 5000, Inmates families = 5010-5199, Pauper/Almsperson etc. = 5200, Patients/Lunatics, etc., = 5300, Prisoners, etc. in correctional institutions = 5400, Scholars = 5500, Students = 5600, Foundlings/orphans = 5700, Religious house inmates = 5750, Army = 5800, Navy = 5900, Servant = 6000, Familial servants = 6010-6199, Domestic servant = 6200, Housekeeper = 6210, Governess = 6220, School teacher, etc., = 6300, Apprentice = 6500, Assistants = 6600, Journeymen = 6700, Farm servant titles = 6800, Others with "working" titles = 6900, No relationship given = 9999
  4. The I-CeM guide notes that the relationship to head may have been altered automatically by a program and the "relinf" code will be set to "1", "2" or "3" where this is true. The head of household may also have been automatically altered, indicated by the "headinf" variable being set to "1".
  5. The I-CeM guide specifies that kin relationships take precedence where there is a difference between the first and second "relcodes".
  6. Inverted commas had to be added around the text in the data file where a "\" characater appeared and spaces deleted from numeric columns in the data in order for the data to successfully load into the database.


Checking:

  1. The data have not been checked.


Indices:

IndexTypeColumn(s) indexed
icem_headrel_codebook_pkey Primary key rec_num
icem_headrel_codebook_idx Unique relcode, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
icem_headrel_codebook_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
relation Text string (max.len.=64). Relationship to head of household as given in the transcription from the Census between 1851 and 1911.
relcode Integer number. Standardised four digit numeric code identifying relationship to head of household used within the Icem project.
relcode2 Integer number. Standardised four digit numeric code identifying real relationship to head of household used within the Icem project where additional information was available, for example given in parentheses.
relmarcode Integer number. Standardised one digit numeric code. Not identified in the ICeM documentation, presumably identifying relationship to head conjugally. Values given as 0, 5, 6, 7 and 8.
rec_num Integer number. Unique number identifying row in table.