Marital Condition dictionary for ICEM data

Table ID:

ICEM_CONJ_CODEBOOK     (1250921)

Contents:

Marital Condition dictionary for ICEM data

Approx. number of rows:

7,889

Table type:

Codebook

Documentation Author:

Paula Aucott

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:

Index	Type	Column(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:

Constraint	Type	Details
icem_conj_codebook_pkey	Primary Key	See details above for primary key index

---

Columns within table:

Column	Type	Contents
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.