1881 occupational statistics for the counties and burghs of Scotland.

Table ID:

OCC_1881_S     (1251872)

Contents:

1881 occupational statistics for the counties and burghs of Scotland.

Approx. number of rows:

19,084

Table type:

Raw Data

Documentation Author:

Paula Aucott

Chronology:

The data are for the single year 1881.

Sources:

1. The data are transcribed from the following tables: 'Occupations of the inhabitants of the county of [Scottish County Name] at different Ages', and 'Occupations of the inhabitants of the [type of Burgh] Burgh of [Scottish Burgh Name] at different Ages', and 'Summary of the occupations of the inhabitants of Scotland, at Different Ages', all taken from "Abstracts; section XV. Occupations of the people" in the "Ninth Decennial Census of the Population of Scotland Taken 4th April 1881, with Report. Volume II, pp398-913". This is equivalent to the occ_1881_c table for England and Wales.
2. This is an incomplete transcription of the full tables. The original tables also include a breakdown of occupation for each gender by age: under 5 years, 5-14, 15-19, 20-24, 25-44, 45-64, 65 and up. There is no equivalent age-gender-occupation breakdown at county level for England and Wales and therefore these columns were not computerised. A "Total at all ages" column was not transcribed as the figures can be computed from the two columns we did transcribe.
3. These data were transcribed by Harold Price in Portsmouth in summer and autumn 2016.
4. The original tables do not include footnotes.

---

Notes:

1. The following values of area_type appear:
   • NATION: Scottish national total.
   • SCO_CNTY: County totals (33 areas).
   • PaBu: Parliamentary Burghs (27 areas).
   • PoBu: Police Burghs (7 areas).
2. The information on burghs mostly relates to Parliamentary burghs. In some cases it lists figures for Municipal or Police burghs, and occasionally gives figures for both Municipal/Police and Parliamentary. Where there is a choice the Parliamentary burgh figures have been entered, where there is not the municipal/police burgh figures have been entered. The different kind of burghs are identified in the data.
3. The data were standardised to follow more closely the structure of other occupational datasets already incorporated into our system. Specifically, in the original table all occupational data was placed into one field. We have divided this information up into separate Class, Order and sub-Order fields. Further, the locational data is recorded in two fields which means that this table has many rows, but few columns.
4. The 1881 occupation codebook for Scotland is currently only partially matched to sic2007 & VoB industrial sectors.

---

Checking:

1. Data were checked in each county by Harold Price during data entry to ensure: (i) the summed total value for each column of county order summary totals matched the county totals given. (ii) the summed total value for each order matched the county order summary totals given.
2. The 33 county and 34 burgh names were matched to units in the AUO. However, the status value of the burghs had to be disregarded for this process and further work is required in this area.

---

Indices:

Index	Type	Column(s) indexed
occ_1881_s_pkey	Primary key	rec_num

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
occ_1881_s_pkey	Primary Key	See details above for primary key index
occ_1881_s_fk_sco_row	Foreign Key	Column(s) {10} link to table occ_1881_s_codebook, column(s) {1}.

---

Columns within table:

Column	Type	Contents
rec_num	Integer number.	Unique number identifying row in table.
g_unit	Integer number.	ID for unit as defined in the GBH Administrative Unit Ontology.
area_name	Text string (max.len.=64).	The name of the Scottish Burgh or county to which the data relate.
area_type	Text string (max.len.=36).	The type of unit to which the data relate; nation, county or burgh (Parliamentary, or municipal/police).
level_num	Integer number.	Number identifying the finest level of detail of the codebook information for that row. Summary statistics will be listed under level 2, individual occupations level 4..
class_num	Integer number.	Occupational class reference number. These appear as roman numerals in the paper table but have been converted to Arabic style during transcription.
order_num	Integer number.	Occupational Order reference number. These are recorded in the original report.
sub_order_num	Integer number.	Occupational Sub Order reference number.
occupation	Text string (max.len.=84).	The specific occupation.
sco_row	Integer number.	Sequence number identifying occupation, as defined and looked up from the occ_1881_occ_codes table. This forms the basis for the cell references used for these data in the main data table.
m_u_20	Integer number.	Total males in the specified occupation under 20 years of age.
m_20_up	Integer number.	Total males in the specified occupation above 20 years of age.
f_u_20	Integer number.	Total females in the specified occupation under 20 years of age.
f_20_up	Integer number.	Total females in the specified occupation above 20 years of age.
notes	Long text.	Notes added during post processing of the data.