Codebook assigning 1931 occupations for Scotland to social classes and other categorisations

Table ID:

OCC_1931_S_CODEBOOK     (1251995)

Contents:

Codebook assigning 1931 occupations for Scotland to social classes and other categorisations

Approx. number of rows:

596

Table type:

Codebook

Documentation Author:

Humphrey Southall

Chronology:

The data are for the single year 1931.

Sources:

1. This is closely based on occ_1931_codebook, but includes five additional "Occupation Units" that appear only for Scotland, and contains the significantly different labels for occupations appearing in the Scottish data.

---

Notes:

1. This table contains only the most detailed categories, so the rows are a subset of those appearing in 'occ_1931_s'.
2. The five additional "occupation Units" are:
   • 1 "Fishermen-Crofters"
   • 32 "Crofters"
   • 33 "Crofters' sons, daughters, or other relatives assisting in the work of the croft"
   • 767 "Ministers, clergymen: Church of Scotland"
   • 769 "Ministers, clergymen: Other Presbyterian churches"
   There were no Scottish census volumes providing occupational classifications, but the England and Wales Classification of Occupations volumes, for both 1921 and 1951, did list Crofters and assigned them to the same detailed "Code" as Farmers. This in turn means they must be assigned to Social Class 2. Similarly, the additional Scottish categories of clergymen are obviously assigned to the same social class as other clergymen.
3. Although all other occupation numbers and labels have been confirmed manually to be equivalent to those in the England and Wales data, the detailed differences in the labels suggest a need for further proof reading against the originals.

---

Checking:

1. The values of 'soc_class' were subject to very careful visual checking.

---

Indices:

Index	Type	Column(s) indexed
occ_1931_s_codebook_pkey	Primary key	row_id
occ_1931_s_codebook_idx1	Unique	row_id, lev_3, soc_class
occ_1931_s_codebook_idx3	Unique	row_id, lev_3, soc_class_div

---

Constraints:

The table has the following associated constraints:

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

---

Columns within table:

Column	Type	Contents
row_id	Floating point number.	Numeric field identifying and placing in order the different rows of information as they are usually listed. These IDs were created by the project, and exactly match those used in occ_1931_s.
lev_1	Floating point number.	Occupational Order, i.e. level 1 occupational category, given in roman numerals in the original report.
occ_order	Text string (max.len.=116).	Name of the Occupational Order (level 1 occupational category).
lev_2	Floating point number.	Occupational sub-Order, i.e. level 2 category. This does not appear for all level 1 categories.
sub_order	Text string (max.len.=88).	Name of the Occupational sub-Order (level 2 occupational category).
extra_detail	Text string (max.len.=68).	Sub-headings below the level of the sub-Orders. In the England and Wales data these have been incorporated into the labels for the Occupation Units. and are often needed to make sense of the latter.
lev_3	Floating point number.	Occupation Unit (level 3 occupational category); a three digit number running from 0 to 962.
occup	Text string (max.len.=110).	Name of the Occupation Unit. This is the full text as used in the source tables.
soc_class	Floating point number.	Social class. These run from 1 to 5.
soc_class_div	Text string (max.len.=10).	Social class, with social class 3 divided into manual ("3_MAN") and non-manual ("3_NM"). Values are identical to soc_class for all other classes, but NB the values are necessarily text strings, not integers.
sic_query	Text string (max.len.=6).	This is a flag column which holds 'Q' if our assignment of the 1931 occupation to the 2007 SIC was seen as especially problematic; otherwise empty.
sic_division	Integer number.	Integer number identifying the 2007 SIC 'Division' to which we have assigned the 1931 occupation. These form a single sequence running from 1 to 99, and we have added code 100 to identify people who were in employment but cannot be assigned to an industry. Persons who were not working have a null value.
sic_division_name	Text string (max.len.=138).	Name of the 2007 SIC 'Division'. For example, 'AGRICULTURE, FORESTRY AND FISHING' is divided into (01) 'Crop and animal production, hunting and related service activities', (02) 'Forestry and logging', and (03) 'Fishing and aquaculture'. Some Sections contain only one division.