Socio-Economic Group data for 2011 Local Authorities in Scotland

Table ID:

SEG_2011_S     (1252983)

Contents:

Socio-Economic Group data for 2011 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 are for the single year 2011.

Sources:

1. These data were obtained from data table 'KS613SC - NS-SeC - Females', table 'KS612SC - NS-SeC - Males' and table 'KS611SC - NS-SeC' [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.
2. This table was originally called soc_2011_s. It was renamed in January 2017 to be seg_2011_s to more accurately reflect its content and because a new social grade table for 2011 has been added to the database.

---

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.
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:

Index	Type	Column(s) indexed
seg_2011_s_pkey	Primary key	rec_num
seg_2011_s_g_unit_idx	Unique	g_unit, sex, rec_num

---

Constraints:

The table has the following associated constraints:

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

---

Columns within table:

Column	Type	Contents
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_1	Integer number.	Count 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"
g2	Integer number.	Count 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"
g4	Integer number.	Count 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"
g6	Integer number.	Count of persons in socio-economic group 6: Semi-Routine Occupations"
g7	Integer number.	Count of persons in socio-economic group 7: Routine Occupations"
g14_1	Integer number.	Count 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"
g15	Integer number.	Count of persons in socio-economic group 15: Full-Time Students"
rec_num	Integer number.	Unique number identifying row in table.