Codebook organising 1861 occupations into classes and orders, and mapping to SIC2007

Table ID:

OCC_1861_CODEBOOK     (1251784)

Contents:

Codebook organising 1861 occupations into classes and orders, and mapping to SIC2007

Approx. number of rows:

713

Table type:

Codebook

Documentation Author:

Humphrey Southall

Chronology:

The data are for the single year 1861.

Sources:

1. This codebook covers all occupations listed in the tables 'Occupations of Males aged 20 Years and upwards in Districts' and 'Occupations of Females aged 20 Years and upwards in Districts', in Volume II of the Population Tables published by the 1861 Census of Population.
2. However, the District-level tables contain only the occupation titles plus the numbers for the Classes, Orders and sub-Orders, so the names of the Classes and Orders are taken from Table XVIII in the same report, giving a national summary for England and Wales.

---

Notes:

1. Mappings to SIC2007 were based fairly closely on those already defined for the 1841 and 1881 occupation codebooks.

---

Indices:

Index	Type	Column(s) indexed
occ_1861_codebook_pkey	Primary key	gender, row_seq
occ_1861_codebook_idx_class	Unique	class_num, class_name, order_num, order_name, suborder_num, suborder_name, old_occup_label

---

Constraints:

The table has the following associated constraints:

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

---

Columns within table:

Column	Type	Contents
gender	Text string (max.len.=6).	'M' or 'F', indicating whether the data from the tables for males or for females.
row_seq	Integer number.	Number placing occupations in the correct sequence. NB there are separate sequences for the Male and Female tables.
class_num	Text string (max.len.=8).	Occupation Class number (in roman numerals) extracted from the original table.
class_name	Text string (max.len.=42).	Name of the Occupation Class.
order_num	Integer number.	Occupation Order number as given in the original table.
order_name	Text string (max.len.=154).	Name of the Occupation Order.
suborder_num	Integer number.	Occupation Sub-order number as given in the original table.
suborder_name	Text string (max.len.=84).	Name of the Occupation sub-Order.
occupation	Text string (max.len.=64).	Specific occupation as stated in the census table. These are not based on the transcriptions of the data, but on careful checking of the original reports accessed via Hist-Pop.
occup_html	Text string (max.len.=84).	Occupations with addition HTML coding to more closely reproduce the formatting in the original reports. This mainly means adding italicisation.
old_occup_label	Text string (max.len.=64).	These string are essential to loading the data in from the available transcriptions, but have different functions depending on gender. For males, they are CDDA's original transcriptions of the occupations, differing mainly in that they expanded up abbreviations; the values now held in occupation are often abbreviated. For females, they are the highly abbreviated variable/column names in David Gatley's SPSS file.
sic_division	Integer number.	Division in the 2007 Standard Industrial Classification, as assigned by Humphrey Southall.
sic_division_name	Text string (max.len.=144).	Name of the SIC Division.