GB Historical DB

Socio-Economic Group data for 2011 Local Authorities in England and Wales

Table ID:
SEG_2011_EW     (1252975)
Contents:
Socio-Economic Group data for 2011 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 data table 'KS613EW - NS-SeC - Females', table 'KS612EW - NS-SeC - Males' and table 'KS611EW - NS-SeC' [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.
  2. This table was originally called soc_2011_ew. It was renamed in January 2017 to be seg_2011_ew to more accurately reflect its content and because a new social grade table for 2011 has been added to the database.

Notes:

  1. This table holds data for all Local Authorities in England and Wales.
  2. 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."
  3. Unlike some earlier SEG data, the 2011 groups were not sub-divided to permit calculation of the RG's five social classes. No calculations have yet been added to permit grouping of SEGs to these classes.
  4. This data only relates to persons aged between 16 and 74.

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
seg_2011_ew_pkey Primary key rec_num
seg_2011_ew_g_unit_idx Unique g_unit, sex, rec_num

Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
seg_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: 'KS612' = Male SEG table; 'KS613'= Female SEG table; 'KS611'= Total SEG table.
tot_16_74 Integer number. Count of the usual resident population aged between 16 and 74.
g1 Integer number. Count of persons in socio-economic group 1: Higher Managerial, Administrative and Professional Occupations"
g1_pc Floating point number. Percentage of persons in socio-economic group 1: Higher Managerial, Administrative and Professional Occupations"
g1_1 Integer number. Count of persons in socio-economic group 1.1: Large Employers and Higher Managerial and Administrative Occupations"
g1_1_pc Floating point number. Percentage of persons in socio-economic group 1.1: Large Employers and Higher Managerial and Administrative Occupations"
g1_2 Integer number. Count of persons in socio-economic group 1.2: Higher Professional Occupations"
g1_2_pc Floating point number. Percentage of persons in socio-economic group 1.2: Higher Professional Occupations"
g2 Integer number. Count of persons in socio-economic group 2: Lower Managerial, Administrative and Professional Occupations"
g2_pc Floating point number. Percentage of persons in socio-economic group 2: Lower Managerial, Administrative and Professional Occupations"
g3 Integer number. Count of persons in socio-economic group 3: Intermediate Occupations"
g3_pc Floating point number. Percentage of persons in socio-economic group 3: Intermediate Occupations"
g4 Integer number. Count of persons in socio-economic group 4: Small Employers and Own Account Workers"
g4_pc Floating point number. Percentage of persons in socio-economic group 4: Small Employers and Own Account Workers"
g5 Integer number. Count of persons in socio-economic group 5: Lower Supervisory and Technical Occupations"
g5_pc Floating point number. Percentage of persons in socio-economic group 5: Lower Supervisory and Technical Occupations"
g6 Integer number. Count of persons in socio-economic group 6: Semi-Routine Occupations"
g6_pc Floating point number. Percentage of persons in socio-economic group 6: Semi-Routine Occupations"
g7 Integer number. Count of persons in socio-economic group 7: Routine Occupations"
g7_pc Floating point number. Percentage of persons in socio-economic group 7: Routine Occupations"
g8 Integer number. Count of persons in socio-economic group 8: Never Worked and Long-Term Unemployed"
g8_pc Floating point number. Percentage of persons in socio-economic group 8: Never Worked and Long-Term Unemployed"
g14_1 Integer number. Count of persons in socio-economic group 14.1: Never Worked"
g14_1_pc Floating point number. Percentage of persons in socio-economic group 14.1: Never Worked"
g14_2 Integer number. Count of persons in socio-economic group 14.2: Long-Term Unemployed"
g14_2_pc Floating point number. Percentage of persons in socio-economic group 14.2: Long-Term Unemployed"
no_class Integer number. Count of persons not classified in a socio-economic group"
no_class_pc Floating point number. Percentage of persons not classified in a socio-economic group"
g15 Integer number. Count of persons in socio-economic group 15: Full-Time Students"
g15_pc Floating point number. Percentage of persons in socio-economic group 15: Full-Time Students"
g17 Integer number. Count of persons in socio-economic group 17: Not Classifiable for Other Reasons"
g17_pc Floating point number. Percentage of persons in socio-economic group 17: Not Classifiable for Other Reasons"
rec_num Integer number. Unique number identifying row in table.