2011 Economic Activity Statistics for Local Authorities in England and Wales

Table ID:
EMPL_2011_EW     (6562612)
Contents:
2011 Economic Activity 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 "KS603EW - Economic Activity - Females", table "KS602EW - Economic Activity - Males" and table "KS601EW - Economic Activity" [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:

IndexTypeColumn(s) indexed
empl_2011_ew_pkey Primary key rec_num
empl_2011_ew_g_unit_idx Unique g_unit, rec_num
empl_2011_ew_lau_idx Unique g_name, lg_type, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
empl_2011_ew_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
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.
active_employ_pt Integer number. Count of the usual resident population aged between 16 and 74 who were economically active: Employee part-time.
active_employ_pt_pc Floating point number. Percentage of the usual resident population aged between 16 and 74 who were economically active: Employee part-time.
active_employ_ft Integer number. Count of the usual resident population aged between 16 and 74 who were economically active: Employee full-time.
active_employ_ft_pc Floating point number. Percentage of the usual resident population aged between 16 and 74 who were economically active: Employee full-time.
active_selfemploy Integer number. Count of the usual resident population aged between 16 and 74 who were economically active: Self-Employed.
active_selfemploy_pc Floating point number. Percentage of the usual resident population aged between 16 and 74 who were economically active: Self-Employed.
active_unemploy Integer number. Count of the usual resident population aged between 16 and 74 who were economically active: Unemployed.
active_unemploy_pc Floating point number. Percentage of the usual resident population aged between 16 and 74 who were economically active: Unemployed.
active_student_ft Integer number. Count of the usual resident population aged between 16 and 74 who were economically active: Full-time student.
active_student_ft_pc Floating point number. Percentage of the usual resident population aged between 16 and 74 who were economically active: Full-time student.
inactive_retired Integer number. Count of the usual resident population aged between 16 and 74 who were economically inactive: Retired.
inactive_retired_pc Floating point number. Percentage of the usual resident population aged between 16 and 74 who were economically inactive: Retired.
inactive_student Integer number. Count of the usual resident population aged between 16 and 74 who were economically inactive: Student (including full-time students).
inactive_student_pc Floating point number. Percentage of the usual resident population aged between 16 and 74 who were economically inactive: Student (including full-time students).
inactive_carer Integer number. Count of the usual resident population aged between 16 and 74 who were economically inactive: Looking After Home or Family.
inactive_carer_pc Floating point number. Percentage of the usual resident population aged between 16 and 74 who were economically inactive: Looking After Home or Family.
inactive_ltsickdisable Integer number. Count of the usual resident population aged between 16 and 74 who were economically inactive: Long-Term Sick or Disabled.
inactive_ltsickdisable_pc Floating point number. Percentage of the usual resident population aged between 16 and 74 who were economically inactive: Long-Term Sick or Disabled.
inactive_other Integer number. Count of the usual resident population aged between 16 and 74 who were economically inactive: Other.
inactive_other_pc Floating point number. Percentage of the usual resident population aged between 16 and 74 who were economically inactive: Other.
unemploy_16_24 Integer number. Count of the usual resident population who were Unemployed; Aged 16 to 24
unemploy_16_24_pc Floating point number. Percentage of the usual resident population who were Unemployed; Aged 16 to 24
unemploy_50_74 Integer number. Count of the usual resident population who were Unemployed; Aged 50 to 74
unemploy_50_74_pc Floating point number. Percentage of the usual resident population who were Unemployed; Aged 50 to 74
unemploy_never Integer number. Count of the usual resident population who were Unemployed; Never worked
unemploy_never_pc Floating point number. Percentage of the usual resident population who were Unemployed; Never worked
unemploy_ltunemploy Integer number. Count of the usual resident population who were Unemployed; Long-Term Unemployed
unemploy_ltunemploy_pc Floating point number. Percentage of the usual resident population who were Unemployed; Long-Term Unemployed
rec_num Integer number. Unique number identifying row in table.