GB Historical DB

Detailed occupation information for Scottish cities, counties and burghs from 1931.

Table ID:
OCC_1931_S     (1251988)
Contents:
Detailed occupation information for Scottish cities, counties and burghs from 1931.
Approx. number of rows:
40,136
Table type:
Raw Data
Documentation Author:
Paula Aucott
Chronology:
The data are for the single year 1931.

Sources:

  1. These data were transcribed from Table 2, 'Occupations of Males and of Females, aged 14 years and over, in Cities, Counties and Large Burghs, showing also the total "Operatives" and the total Persons "Out of Work."', pp. 42-137 in Census of Scotland 1931, volume III, Occupations and Industries.
  2. This table was transcribed by Rachel Granville in Portsmouth in Spring 2002.
  3. The national totals were transcribed from the same table by Harold Price in Portsmouth in March 2017.

Notes:

  1. The table contains data for the following area types, all of which have been matched to the AUO. These are the exact same units as appear in the ind_1931_s table, except that this transcription does not include the national totals:
    • Nation (1 area): Scottish national totals.
    • County (33 areas): These data include the Burghs which are in the table4, but exclude data for the Cities.
    • City (4 areas): Aberdeen, Dundee, Edinburgh and Glasgow.
    • Burgh (20 areas): NB these are only the Large Burghs, while other Scotland 1931 tables cover 190 Burghs.
  2. The list of occupations is different from and longer than the list used for England and Wales, so at some stage an additional codebook needs to be created.
  3. The first eleven rows for each area list numbers in the following occupational statuses, as recorded in the 'occup' column:
    1. TOT_POP: Total Population.
    2. TOT_U14: [Total Population] Aged under 14 years of age.
    3. TOT_O14: [Total Population] Aged 14 years and over.
    4. OP: "Operatives: Number".
    5. OP_PERCENT: "Operatives: Per cent of Gainfully Occupied (I-XXXI)".
    6. UNEMPL: "Out of Work: Number". A note adds "Persons termed out of work are included in the Occupied (Orders I-XXXI)".
    7. UNEMPL_PERCENT: "Out of Work: Per cent of Gainfully Occupied (I-XXXI)".
    8. OCC_G: "I-XXXI. Gainfully Occupied, aged 14 years and over".
    9. OCC_NG: "XXXII. (part). Occupied (Not Gainfully), aged 14 years and over".
    10. RET: "XXXII. (part). Retired". A note adds "Retired are not so included [i.e. in the Occupied (Orders I-XXXI)], but are segregated in Order XXXII."
    11. UNOC: "XXXII. (part). No Occupation".
    Note that the original table also includes a total for those "In Occupations, aged 14 years and over", but it is not included in this transcription. It can be computed as OCC_G + OCC_NG.

Checking:

  1. The total population was checked against the sum of those under and those over 14 years of age.
  2. The sum of those "Gainfully occupied", "Not gainfully occupied", "Retired" and with "No occupation" was checked against the total population over 14 years.
  3. The figure given for the percentage of people gainfully occupied was compared against a calculated percentage of operators divided by the number gainfully employed.
  4. The figure given for the percentage of people unemployed was compared against a calculated percentage of unemployed divided by the number gainfully employed.
  5. The sum of the 32 level 1 categories was checked against the total aged over 14.
  6. Wherever possible the sum of the components of each Level 1 category was checked against the reported total. Unfortunately, many categories only had some of their components listed and we could only check that the total of those listed was equal to the reported total.

Indices:

IndexTypeColumn(s) indexed
occ_1931_s_pkey Primary key rec_num
occ_1931_s_idx Unique area_name, area_type, sco_cnty, row_id
occ_1931_s_idx2 Unique sco_cnty, row_id, lev_3, occup, area_type, area_name
occ_1931_s_idx3 Unique sco_cnty, area_type, row_id, lev_3, area_name

Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
occ_1931_s_pkey Primary Key See details above for primary key index


Columns within table:

ColumnTypeContents
area_name Text string (max.len.=44). Name of the area the data relates to.
area_type Text string (max.len.=10). Type of area. See note above.
sco_cnty Text string (max.len.=28). Name of county in which the area is situated.
row_id Integer number. Numeric field identifying and placing in order the different rows of information for each reporting unit; for example, 'Boiler firemen and stokers' (category 903, order XXX) will always have a row id=661.
lev_1 Floating point number. Level 1 occupational category, given in roman numerals in the original report. This column is not-null for all rows apart from the initial 'occupational status' data.
lev_2 Floating point number. Level 2 occupational category. This does not appear for all level 1 categories, while some categories are further sub-divided (see note above).
lev_3 Floating point number. Level 3 (lowest) occupational category. This is usually a three-digit number, but it is sometimes a sequence of such numbers linked by commas and dashes.
occup Text string (max.len.=124). Name of the occupational category. NB this may be the name of a level 1, 2 or 3 category, or an occupational status. In most cases, it is simply whatever text appears next to the row of numbers.
males Floating point number. Number of males in category.
females Floating point number. Number of females in category.
g_unit Integer number. Identified for reporting area, as defined in GBH AUO.
rec_num Integer number. Sequence number placing rows in an overall order, added on loading.