1861 occupational statistics for the counties and towns of Scotland.

Table ID:
OCC_1861_S     (6566348)
Contents:
1861 occupational statistics for the counties and towns of Scotland.
Approx. number of rows:
30,122
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 in [Scottish County Name] at different Ages in 1861', (pp141-309) and 'Occupations of the Males/Females in the Towns or Town Districts of Scotland according to their Registration Boundaries - Arranged Alphabetically' (pp310-325) and 'Occupations of the Males/Females at different ages in Scotland in 1861', (pp93-113) all taken from "Abstracts; Occupations of the people" in the "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 eqivualent 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. No work has yet been done on an 1861 occupation codebook for Scotland


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.


Indices:

IndexTypeColumn(s) indexed
occ_1861_s_pkey Primary key rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
occ_1861_s_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
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_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.