2011 Occupational Statistics for Local Authorities in Scotland

Table ID:
OCC_2011_S     (6566595)
Contents:
2011 Occupational Statistics for Local Authorities in Scotland
Approx. number of rows:
96
Table type:
Raw Data
Documentation Author:
Paula Aucott
Geography:
Reporting units are identified by:
   Local Government District Type
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. These data were obtained from table "KS610SC - Occupation - Females", table "KS609SC - Occupation - Males" and table "KS608SC - Occupation" [Totals] for Local Authorities from the 2011 Census of Population. The data was downloaded on 17th November 2015 in spreadsheet format from the Standard Outputs part of the Scotland's Census website operated by the National Records of Scotland. They are under Crown Copyright, but are made available for use under an Open Government Licence.


Notes:

  1. The data contained a caveat about accuracy due to data protection. This may affect results from the check sums: "In order to protect against disclosure of personal information, some records have been swapped between different geographic areas. Some cell values will be affected, particularly small values at the most detailed geographies." More details on Census disclosure control strategy may be found on their page about Confidentiality."
  2. This table covers local authority units which in Scotland are Scottish Council Areas.


Checking:

  1. The statistical data have not been checked
  2. The geographical units have been cross-checked against the GBHGIS administrative unit gazetteer to ensure that all units are correctly identified. The unit names and types have been standardised. Each unit has a unique unit ID assigned to it and this can be used to cross-reference against other data-sets.


Indices:

IndexTypeColumn(s) indexed
occ_2011_s_pkey Primary key rec_num
occ_2011_s_g_unit_idx Unique g_unit, rec_num
occ_2011_s_lau_idx Unique g_name, lg_type, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
occ_2011_s_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
lau_name Text string (max.len.=104). Name of the Local Authority as it appeared in the original table.
lg_type Text string (max.len.=16). Type of unit.
g_unit Integer number. Unique ID number for local authority unit from the auo gazetteer.
g_name Text string (max.len.=104). Standardised name of local authority (preferred English name as given in the auo gazetteer).
sex Text string (max.len.=6). Sex: 'F'=Row refers to women; 'M'=Row refers to men; 'T'=Row is a total for men and women.
source Text string (max.len.=20). Source table from which the data derive: 'KS609' = Male Occupations table; 'KS610'= Female Occupations table.
tot_16_74 Integer number. Count of the usual resident population aged between 16 and 74 in employment.
managers Integer number. Count of the usual resident population aged between 16 and 74 employed as Managers, Directors and Senior Officials.
professional Integer number. Count of the usual resident population aged between 16 and 74 employed in Professional occupations.
technical Integer number. Count of the usual resident population aged between 16 and 74 employed in Associate Professional and Technical occupations.
administrative Integer number. Count of the usual resident population aged between 16 and 74 employed in Administrative and Secretarial occupations.
skilled Integer number. Count of the usual resident population aged between 16 and 74 employed in Skilled Trades occupations.
care Integer number. Count of the usual resident population aged between 16 and 74 employed in Caring, Leisure and Other Service occupations.
sales Integer number. Count of the usual resident population aged between 16 and 74 employed in Sales and Customer Service occupations.
machine Integer number. Count of the usual resident population aged between 16 and 74 employed in Process, Plant and Machine occupations.
elementary Integer number. Count of the usual resident population aged between 16 and 74 employed in Elementary occupations.
rec_num Integer number. Unique number identifying row in table.