Age structure data for Local Authorities in Scotland in 2011.

Table ID:
AGE_2011_S     (6561911)
Contents:
Age structure data for Local Authorities in Scotland in 2011.
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 cover the period 1881 to 1911.

Sources:

  1. These data were obtained from table "DC1117SC - Age by Sex" 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:

IndexTypeColumn(s) indexed
age_2011_s_pkey Primary key rec_num
age_2011_s_g_unit_idx Unique g_unit, rec_num
age_2011_s_lau_idx Unique g_name, lg_type, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
age_2011_s_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
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 Local Government District.
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.=24). Gender: "Males", "Females" or "All people"
tot_pop Integer number. Total population.
p_0 Integer number. Persons aged under 1.
p_1 Integer number. Persons aged 1.
p_2 Integer number. Persons aged 2.
p_3 Integer number. Persons aged 3.
p_4 Integer number. Persons aged 4.
p_5 Integer number. Persons aged 5.
p_6 Integer number. Persons aged 6.
p_7 Integer number. Persons aged 7.
p_8 Integer number. Persons aged 8.
p_9 Integer number. Persons aged 9.
p_10 Integer number. Persons aged 10.
p_11 Integer number. Persons aged 11.
p_12 Integer number. Persons aged 12.
p_13 Integer number. Persons aged 13.
p_14 Integer number. Persons aged 14.
p_15 Integer number. Persons aged 15.
p_16 Integer number. Persons aged 16.
p_17 Integer number. Persons aged 17.
p_18 Integer number. Persons aged 18.
p_19 Integer number. Persons aged 19.
p_20 Integer number. Persons aged 20.
p_21 Integer number. Persons aged 21.
p_22 Integer number. Persons aged 22.
p_23 Integer number. Persons aged 23.
p_24 Integer number. Persons aged 24.
p_25 Integer number. Persons aged 25.
p_26 Integer number. Persons aged 26.
p_27 Integer number. Persons aged 27.
p_28 Integer number. Persons aged 28.
p_29 Integer number. Persons aged 29.
p_30 Integer number. Persons aged 30.
p_31 Integer number. Persons aged 31.
p_32 Integer number. Persons aged 32.
p_33 Integer number. Persons aged 33.
p_34 Integer number. Persons aged 34.
p_35 Integer number. Persons aged 35.
p_36 Integer number. Persons aged 36.
p_37 Integer number. Persons aged 37.
p_38 Integer number. Persons aged 38.
p_39 Integer number. Persons aged 39.
p_40 Integer number. Persons aged 40.
p_41 Integer number. Persons aged 41.
p_42 Integer number. Persons aged 42.
p_43 Integer number. Persons aged 43.
p_44 Integer number. Persons aged 44.
p_45 Integer number. Persons aged 45.
p_46 Integer number. Persons aged 46.
p_47 Integer number. Persons aged 47.
p_48 Integer number. Persons aged 48.
p_49 Integer number. Persons aged 49.
p_50 Integer number. Persons aged 50.
p_51 Integer number. Persons aged 51.
p_52 Integer number. Persons aged 52.
p_53 Integer number. Persons aged 53.
p_54 Integer number. Persons aged 54.
p_55 Integer number. Persons aged 55.
p_56 Integer number. Persons aged 56.
p_57 Integer number. Persons aged 57.
p_58 Integer number. Persons aged 58.
p_59 Integer number. Persons aged 59.
p_60 Integer number. Persons aged 60.
p_61 Integer number. Persons aged 61.
p_62 Integer number. Persons aged 62.
p_63 Integer number. Persons aged 63.
p_64 Integer number. Persons aged 64.
p_65 Integer number. Persons aged 65.
p_66 Integer number. Persons aged 66.
p_67 Integer number. Persons aged 67.
p_68 Integer number. Persons aged 68.
p_69 Integer number. Persons aged 69.
p_70 Integer number. Persons aged 70.
p_71 Integer number. Persons aged 71.
p_72 Integer number. Persons aged 72.
p_73 Integer number. Persons aged 73.
p_74 Integer number. Persons aged 74.
p_75 Integer number. Persons aged 75.
p_76 Integer number. Persons aged 76.
p_77 Integer number. Persons aged 77.
p_78 Integer number. Persons aged 78.
p_79 Integer number. Persons aged 79.
p_80 Integer number. Persons aged 80.
p_81 Integer number. Persons aged 81.
p_82 Integer number. Persons aged 82.
p_83 Integer number. Persons aged 83.
p_84 Integer number. Persons aged 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_4 Integer number. Persons aged 0 to 4 [derived].
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].
rec_num Integer number. Unique number identifying row in table.