2011 Occupational Statistics for Local Authorities in England and Wales

Table ID:

OCC_2011_EW     (1252076)

Contents:

2011 Occupational Statistics for Local Authorities in England and Wales

Approx. number of rows:

1,044

Table type:

Raw Data

Documentation Author:

Paula Aucott

Geography:

Reporting units are identified by:
   Local Government District Type

Chronology:

The data are for the single year 2011.

Sources:

1. These data were obtained from table "KS610EW - Occupation - Females", table "KS609EW - Occupation - Males" and table "KS608EW - Occupation" [Totals] for Local Authorities from the 2011 Census of Population. The data was downloaded on 22nd October 2015 in spreadsheet format from the Census part of the Topics section on the Neighbourhood Statistics website operated by the Office for National Statistics. The data 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 which may affect results from the check sums. "In order to protect against disclosure of personal information from the 2011 Census, there has been swapping of records in the Census database between different geographic areas, and so some counts will be affected. In the main, the greatest effects will be at the lowest geographies, since the record swapping is targeted towards those households with unusual characteristics in small areas. More details on the ONS Census disclosure control strategy may be found at Census Results / Statistical Disclosure Control."

---

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:

Index	Type	Column(s) indexed
occ_2011_ew_pkey	Primary key	rec_num
occ_2011_ew_g_unit_idx	Unique	g_unit, rec_num
occ_2011_ew_lau_idx	Unique	g_name, lg_type, rec_num

---

Constraints:

The table has the following associated constraints:

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

---

Columns within table:

Column	Type	Contents
lau_code	Text string (max.len.=24).	ONS Code for the Local Authority as it appeared in the original table.
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.
managers_pc	Floating point number.	Percentage 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.
professional_pc	Floating point number.	Percentage 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.
technical_pc	Floating point number.	Percentage 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.
administrative_pc	Floating point number.	Percentage 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.
skilled_pc	Floating point number.	Percentage 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.
care_pc	Floating point number.	Percentage 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.
sales_pc	Floating point number.	Percentage 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.
machine_pc	Floating point number.	Percentage 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.
elementary_pc	Floating point number.	Percentage of the usual resident population aged between 16 and 74 employed in Elementary occupations.
rec_num	Integer number.	Unique number identifying row in table.