1881 occupational/age data for parishes and sub-districts, from microdata.

Table ID:

OCC_1881     (28355)

Contents:

1881 occupational/age data for parishes and sub-districts, from microdata.

Approx. number of rows:

0

Table type:

Raw Data

Documentation Author:

Humphrey Southall

Geography:

Reporting units are identified by:
   Registration District Number
   Parish Identifier

Chronology:

The data are for the single year 1881.

Sources:

1. These data were derived from the complete transcription of the census Enumerators' Books for 1881, created by the Genealogical Society of Utah in collaboration with family history societies throughout Britain.
2. The underlying data used here were very extensively enhanced by a project based in the Department of History at the University of Essex, led by Kevin Schurer with Matthew Woollard as the senior researcher. This project was initially funded by the Leverhulme Trust, as 'The 19th Century Censuses Collection' (Humphrey Southall was a co-applicant on that project), and subsequently by the ESRC under their 'Future of Work' Programme. In particular, Matthew Woollard assigned each of the c. half million occupational titles that appeared in the original transcription to the 414 occupational categories that were used in the published reports of the 1881 census.
3. The data set held here was derived from the enhanced version of the 1881 microdata by Hamish James of the History Data Service, also at Essex University, in September 2002 and supplied to the GBHGIS project at that time.

---

Notes:

1. The data were created by the History Data Service via the following query applied to their database holding the microdata:
   

   select reg_cnty,subd_id,parid,occode,sex,hds_agegroup,count(whole1881.recid)
   as freq into hs1
   from whole1881
   group by reg_cnty,subd_id,parid,occode,sex,hds_agegroup
   order by reg_cnty,subd_id,parid,occode,sex,hds_agegroup
   

2. This data set is designed to be usable by either Registration sub-Districts or parishes, so it contains separate rows for the different parts of parishes which are divided into more than one sub-district.
3. To permit the table to be linked to the various codebooks, some null values have been changed: Null values of 'regc_code' have been replaced by 'UNK'. Null values of 'subd_id' have been replaced by '999999'. Unknown values of 'sex' were marked by '@', which has been replaced by 'U'. Null values of 'age_group' have been replaced by '99'.

---

Checking:

1. The data are currently as supplied by the History Data Service. A number of cross-checks against the published 1881 tables for age-groups and occupations, and for parish-level populations, are possible but have yet to be applied. Given the large problems in working with the micro-data, exact matches with the published data are unlikely.

---

Acknowledgments:

We are extremely grateful to the following:

1. Hamish James: These data were derived from the 1881 micro-data by Hamish James, whose contribution should be acknowledged.

---

Indices:

Index	Type	Column(s) indexed
occ_1881_pk	Primary key	subd_id, par_id, occ_code, sex, age_group
occ_1881_reg_idx		reg_num, occ_code, sex, age_group

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
occ_1881_pk	Primary Key	See details above for primary key index
occ_1881_fk_age	Foreign Key	Column(s) {7} link to table occ_1881_age_groups, column(s) {1}.
occ_1881_fk_occ_code	Foreign Key	Column(s) {5} link to table occ_1881_occ_codes, column(s) {1}.
occ_1881_fk_places	Foreign Key	Column(s) {3,4} link to table occ_1881_places, column(s) {2,3}.
occ_1881_fk_regc	Foreign Key	Column(s) {1} link to table occ_1881_regc_codes, column(s) {1}.
occ_1881_sex_check	Check	((((sex)::text = 'M'::text) OR ((sex)::text = 'F'::text)) OR ((sex)::text = 'U'::text))

---

Columns within table:

Column	Type	Contents
regc_code	Text string (max.len.=7).	A three-letter abbreviation for the name of the Registration County, as defined in 'occ_1881_regc_codes'.
reg_num	Integer number.	[No description available]
subd_id	Integer number.	Combined Registration District and sub-District ID.
par_id	Integer number.	Number identifying each parish.
occ_code	Integer number.	Code number identifing the occupational category. These run from 1 to 414, with 999 indicating missing values.
sex	Text string (max.len.=5).	Gender: 'M' = Male, 'F' = Female.
age_group	Integer number.	Age group, in five year bands: 1 = 0-4, 2 = 5-9, etc. This was generated using the function: ceiling((whole1881.age+1)/5).
freq	Integer number.	Number of persons in this category.