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

Table ID:

OCC_1861_S_CODEBOOK     (1251810)

Contents:

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

Approx. number of rows:

1,678

Table type:

Codebook

Documentation Author:

Humphrey Southall

Sources:

1. This codebook was originally constructed somewhat hurriedly in March 2017, but was revised in July 2017 following further cleaning of the source tables held in occ_1861_s, and addition of Scottish national totals.
2. N.B. 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. Although this tries to follow the assignments used in occ_1861_codebook, the Scottish data contain many additional occupations, so this is also modelled on the much larger 1841 codebook.

---

Checking:

1. The codebook has been checked to ensure that all combinations of class_num, order_num, sub_order_num and occupation that appear in the occ_1861_s table are in the codebook, except for some labels for totals and some problematic labels.

---

Indices:

Index	Type	Column(s) indexed
occ_1861_s_codebook_pkey	Primary key	sco_row
occ_1861_s_codebook_idx_class	Unique	class_num, order_num, sub_order_num, occupation

---

Constraints:

The table has the following associated constraints:

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

---

Columns within table:

Column	Type	Contents
sco_row	Integer number.	Number placing occupations in the correct sequence.
level_num	Integer number.	Number identifying the current row's level within the classification: 0: Row is an overall total, i.e. "Total of Males" or "Total of females". 1: Row is one of the six overall "Classes". 2: Row is one of the 18 "Orders". 3: This is currently un-used, but would identify one of the numbered sub-Orders, which are clearly the third tier in the classifciation although given only as numbers, without a name. 4: Row in an individual occupation.
class_num	Integer number.	Occupation Class number (NOT 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.
sub_order_num	Integer number.	Occupation Sub-order number as given in the original table.
occupation	Text string (max.len.=64).	Specific occupation as listed in the census table. These currently are based on the transcriptions of the data, and there are clearly many transcription errors.
occ_freq	Integer number.	Frequency count of the number of times this particular combination of class_num, order_num, suborder_num and occupation appears in occ_1861_s.
sic_query	Text string (max.len.=6).	Flag column: holds 'Q' if the assignment to SIC2007 seems particularly problematic.
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.