Age/sex data for Local Authorities in Scotland in 2011.

Table ID:

AGE_SEX_2011_S     (1246648)

Contents:

Age/sex data for Local Authorities in Scotland in 2011.

Approx. number of rows:

288

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 "DC1104SC - Residence type by sex by age" 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.
3. The original data was downloaded as individual tabs for each Council Area in a single spreadsheet. Each tab was copied and pasted in a transposed format into a new single sheet to ensure the data matched the English and Welsh data as closely as possible.

---

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
age_sex_2011_s_pkey	Primary key	rec_num
age_sex_2011_s_g_unit_idx	Unique	g_unit, rec_num
age_sex_2011_s_lau_idx	Unique	g_name, lg_type, rec_num

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
age_sex_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).
res_sex	Text string (max.len.=64).	Residence type by sex whereby "All poeple", "Lives in a household", and "Lives in a communal establishment" is borken down into "Total", "Males" and "Females".
tot_pop	Integer number.	Total population.
p_0_4	Integer number.	Persons aged 0 to 4.
p_5_9	Integer number.	Persons aged 5 to 9.
p_10_11	Integer number.	Persons aged 10 to 11.
p_12_14	Integer number.	Persons aged 12 to 14.
p_15	Integer number.	Persons aged 15.
p_16_17	Integer number.	Persons aged 16 and 17.
p_18_19	Integer number.	Persons aged 18 and 19.
p_20_24	Integer number.	Persons aged 20 to 24.
p_25_29	Integer number.	Persons aged 25 to 29.
p_30_34	Integer number.	Persons aged 30 to 34.
p_35_39	Integer number.	Persons aged 35 to 39.
p_40_44	Integer number.	Persons aged 40 to 44.
p_45_49	Integer number.	Persons aged 45 to 49.
p_50_54	Integer number.	Persons aged 50 to 54.
p_55_59	Integer number.	Persons aged 55 to 59.
p_60_64	Integer number.	Persons aged 60 to 64.
p_65_69	Integer number.	Persons aged 65 to 69.
p_70_74	Integer number.	Persons aged 70 to 74.
p_75_79	Integer number.	Persons aged 75 to 79.
p_80_84	Integer number.	Persons aged 80 to 84.
p_85_89	Integer number.	Persons aged 85 to 89.
p_90_94	Integer number.	Persons aged 90 to 94.
p_95_up	Integer number.	Persons aged 95 and over.
p_0_14	Integer number.	Persons aged 0 to 14 [derived].
p_15_64	Integer number.	Persons aged 15 to 64 [derived].
p_65_up	Integer number.	Persons aged 65 and over [derived].
p_75_up	Integer number.	Persons aged 75 and over to match the top age band in earlier years. [derived].
p_85_up	Integer number.	Persons aged 85 and over to match the top age band in earlier years. [derived].
notes	Text string (max.len.=4004).	Notes.
rec_num	Integer number.	Unique number identifying row in table.