Marital Condition dictionary for ICEM data

Table ID:
ICEM_CONJ_CODEBOOK     (6565548)
Contents:
Marital Condition dictionary for ICEM data
Approx. number of rows:
7,889
Table type:
Codebook
Documentation Author:
Paula Aucott
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. This meta-data file "marital condition 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 1851-1861 and 1881-1911 and Scotland 1851-1901.
  2. Numeric codes identifying marital condition used within the Icem project are as follows: 1 = Single, 2 = Married, 3 = Married, spouse absent, 4 = Widowed, 5 = Divorced, 9 = Not recorded/unknown.
  3. The I-CeM guide notes that the conj may have been altered automatically by a program and the "marinf" code will be set to "1" where this is true.
  4. The I-CeM spreadsheet contained a row where the conj condition value is given as "#NAME?". This obviously is a formula function error in the spreadsheet. However, as this is a look-up table and we do not have the full dataset we do not know what the value should be and therefore cannot correct the error


Checking:

  1. The data have not been checked.


Indices:

IndexTypeColumn(s) indexed
icem_conj_codebook_pkey Primary key rec_num
icem_conj_codebook_idx Unique marcode, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
icem_conj_codebook_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
conj Text string (max.len.=64). Marital condition as given in the transcription from the Census between 1851 and 1911.
marcode Integer number. Standardised one digit numeric code identifying marital condition used within the Icem project.
rec_num Integer number. Unique number identifying row in table.