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

Table ID:

OCC_1931_S     (28411)

Contents:

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

Approx. number of rows:

39,444

Table type:

Raw Data

Documentation Author:

Paula Aucott

Geography:

Reporting units are identified by:
   Administrative County
   Local Government District Type
   Local Government Unit

Chronology:

The data are for the single year 1931.

Sources:

1. This data was 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." ' in the Census of Scotland 1931, Volume III entitled 'Occupations and Industries' pp42-137.

---

Notes:

1. This table was transcribed by Rachel Granville in Portsmouth in Spring 2002.
2. Despite listing them separetely the table also notes that the counties include the large burghs situated within them, except for the four cities of Edinburgh, Glasgow, Dundee and Aberdeen.
3. The table also notes that 'persons termed out of work are included in the Occupied (Orders I-XXXI). Retired are not so included, but are aggregated in Order XXXII.'

---

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:

Index	Type	Column(s) indexed
occ_1931_s_idx	Unique	lg_unit, lg_type, adm_cnty, row_id
occ_1931_s_idx2	Unique	adm_cnty, ac_tot, row_id, lev_3, occup, lg_unit
occ_1931_s_idx3	Unique	adm_cnty, lg_type, row_id, lev_3, lg_unit

---

Columns within table:

Column	Type	Contents
lg_unit	Text string (max.len.=44).	Name of the unit the data relates to.
lg_type	Text string (max.len.=8).	Type of unit. This is limited to: 'CO'=Scottish County, 'CT'=City, 'BU'=Scottish Burgh.
adm_cnty	Text string (max.len.=28).	Name of county in which the unit 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 mort 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.
notes	Long text.	Notes.
ac_tot	Text string (max.len.=6).	Flag to indicate rows which are totals for Administrative counties. This is always set to 'T' where lg_type ='CO'.