1861 occupational statistics for the counties and towns of Scotland.

Table ID:

OCC_1861_S     (1251804)

Contents:

1861 occupational statistics for the counties and towns of Scotland.

Approx. number of rows:

30,128

Table type:

Raw Data

Documentation Author:

Paula Aucott

Chronology:

The data are for the single year 1861.

Sources:

1. The data are transcribed from the following tables:
   • 'Occupations of the Males/Females at different ages in Scotland in 1861', (pp. 93-113).
   • 'Occupations of the Males/Females in [Scottish County Name] at different Ages in 1861', (pp. 141-309).
   • 'Occupations of the Males/Females in the Towns or Town Districts of Scotland according to their Registration Boundaries - Arranged Alphabetically' (pp. 310-325).
   all taken from 'Abstracts; Occupations of the people' in Census of Scotland, 1861. Population Tables and Report. Ages, civil or conjugal condition, occupations, and birth places of the people in Scotland: with the number and ages of the blind, the deaf-dumb, and the inmates of poorhouses, prisons, lunatic asylums, and hospitals. Volume II". This is equivalent to the occ_1861_ew table for England and Wales.
2. This is an incomplete transcription of the full tables. The original tables for national and county figures also included a breakdown of occupation for each gender by age. There is no equivalent age-gender-occupation breakdown at county level for England and Wales and therefore these columns were no computerised. A "Total at all ages" column was not given for town data in the original table, but was transcribed for counties and the nation.

---

Notes:

1. These data were transcribed by Harold Price in Portsmouth in the summer and autumn of 2016.
2. The table contains data for three types of area, identified by values of 'area_type':
   • Nation (1 area): overall totals
   • County (31 areas): overall totals
   • Towns or Town Districts (23 areas): These relate to the main burghs
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 table has been consistently matched to the occ_1861_s_codebook.

---

Checking:

1. Town data were checked by Harold Price during data entry: (i) the total town districts for persons under 20 by gender was equal to all individual towns summed together (ii) the total town districts for persons 20 and over by gender was equal to all individual towns summed together The only errors were discrepancies in the original rather than transcription errors.
2. National and County data were checked by Harold Price during data entry: (i) the total for all ages was compared against the summed total for those under 20 years and those 20 and over by occupation and gender. No errors were identified.
3. The county level administrative units and Scotland have all been matched to the AUO. Although preliminary code is included in this build script to match the town level data to burghs within the AUO, it should not be considered final. Further work is required to define what is meant by "town" in order to match the data to different kinds of burgh within the AUO. Currently two towns, "Barony" and "Coatbridge", would not match with any AUO burgh.
4. National, Burgh and County data were visually checked by Paula Aucott to correct mis-numbered labels, missing rows were inserted and erroneous labels corrected.
5. The national totals for Scotland include, in the original listing for females on page 111, two rows of data both covering the occupation of "Currier" within Order 13, sub-Order 2, with different numerical data. This prevented a primary key being created on the table, so a single row was created with the numerical data being summed.

---

Indices:

Index	Type	Column(s) indexed
occ_1861_s_pkey	Primary key	g_unit, sco_row, gender

---

Constraints:

The table has the following associated constraints:

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

---

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 in and looked up from the occ_1861_occ_codes table. This forms the basis for the cell references used for these data in the main data table.
gender	Text string (max.len.=6).	Gender, "M" = Males or "F" = females.
all_ages	Integer number.	Total by gender in the specified occupation (counties only).
all_u_20	Integer number.	Total by gender in the specified occupation under 20 years of age.
all_20_up	Integer number.	Total by gender in the specified occupation above 20 years of age.
notes	Long text.	Notes added during post processing of the data.