Disability dictionary for ICEM data

Table ID:
ICEM_DISABLE_CODEBOOK     (6565561)
Contents:
Disability dictionary for ICEM data
Approx. number of rows:
66,154
Table type:
Codebook
Documentation Author:
Paula Aucott
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. This meta-data file "Disability 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. Binary numeric code identifying marital condition used within the Icem project are as follows: 1 = visual impairment, 2 = dumb and hearing impairment, 3 = idiocy and imbecility, 4 = lunacy, 5 = other disabilities, 6 = information relating to duration of disability, and 7 = information relating to severity of disability. For exmple, blind, dumb and lunatic would be coded 1101000.
  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 disability 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_disable_codebook_pkey Primary key rec_num
icem_disable_codebook_idx Unique discode, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
icem_disable_codebook_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
disability Text string (max.len.=64). Information about infirmity, illness or disability as given in the transcription from the Census between 1851 and 1911.
discode Integer number. Binary seven digit numeric code identifying disability or illness used within the Icem project.
discode2 Integer number. Standardised three digit numeric code identifying disability or illness used within the Icem project.
rec_num Integer number. Unique number identifying row in table.