Housing conditions data for Local Authorities in Scotland in 2011

Table ID:
HCOND_2011_S     (6565301)
Contents:
Housing conditions data for Local Authorities in Scotland in 2011
Approx. number of rows:
224
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 "DC4410SC - Types of central heating in household by occupancy rating (rooms)" 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
hcond_2011_s_pkey Primary key rec_num
hcond_2011_s_g_unit_idx Unique g_unit, rec_num
hcond_2011_s_lau_idx Unique g_name, lg_type, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
hcond_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 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).
age Text string (max.len.=34). Age category divisions of counts: "All people in households", "0 to 15", "16 to 24", "25 to 34", "35 to 49", "50 to 64", "65 and over".
pop_hhold Integer number. Count of All people in households: Total
hhold_occ_plus2 Integer number. Count of All people in households: with occupancy rating of plus 2 or more
hhold_occ_plus1 Integer number. Count of All people in households: with occupancy rating of plus 1
hhold_occ_0 Integer number. Count of All people in households: with occupancy rating of 0
hhold_occ_minus1_less Integer number. Count of All people in households: with occupancy rating of minus 1 or less
no_cheat Integer number. Count of All people in households with No Central Heating: Total
no_cheat_occ_plus2 Integer number. Count of All people in households with No Central Heating: with occupancy rating of plus 2 or more
no_cheat_occ_plus1 Integer number. Count of All people in households with No Central Heating: with occupancy rating of plus 1
no_cheat_occ_0 Integer number. Count of All people in households with No Central Heating: with occupancy rating of 0
no_cheat_occ_minus1_less Integer number. Count of All people in households with No Central Heating: with occupancy rating of minus 1 or less
gas_cheat Integer number. Count of All people in households with Gas Central Heating: Total
gas_cheat_occ_plus2 Integer number. Count of All people in households with Gas Central Heating: with occupancy rating of plus 2 or more
gas_cheat_occ_plus1 Integer number. Count of All people in households with Gas Central Heating: with occupancy rating of plus 1
gas_cheat_occ_0 Integer number. Count of All people in households with Gas Central Heating: with occupancy rating of 0
gas_cheat_occ_minus1_less Integer number. Count of All people in households with Gas Central Heating: with occupancy rating of minus 1 or less
elec_cheat Integer number. Count of All people in households with Electric Central Heating (including storage heaters): Total
elec_cheat_occ_plus2 Integer number. Count of All people in households with Electric Central Heating (including storage heaters): with occupancy rating of plus 2 or more
elec_cheat_occ_plus1 Integer number. Count of All people in households with Electric Central Heating (including storage heaters): with occupancy rating of plus 1
elec_cheat_occ_0 Integer number. Count of All people in households with Electric Central Heating (including storage heaters): with occupancy rating of 0
elec_cheat_occ_minus1_less Integer number. Count of All people in households with Electric Central Heating (including storage heaters): with occupancy rating of minus 1 or less
oil_cheat Integer number. Count of All people in households with Oil Central Heating: Total
oil_cheat_occ_plus2 Integer number. Count of All people in households with Oil Central Heating: with occupancy rating of plus 2 or more
oil_cheat_occ_plus1 Integer number. Count of All people in households with Oil Central Heating: with occupancy rating of plus 1
oil_cheat_occ_0 Integer number. Count of All people in households with Oil Central Heating: with occupancy rating of 0
oil_cheat_occ_minus1_less Integer number. Count of All people in households with Oil Central Heating: with occupancy rating of minus 1 or less
solid_cheat Integer number. Count of All people in households with Solid Fuel (for example wood, coal) Central Heating: Total
solid_cheat_occ_plus2 Integer number. Count of All people in households with Solid Fuel (for example wood, coal) Central Heating: with occupancy rating of plus 2 or more
solid_cheat_occ_plus1 Integer number. Count of All people in households with Solid Fuel (for example wood, coal) Central Heating: with occupancy rating of plus 1
solid_cheat_occ_0 Integer number. Count of All people in households with Solid Fuel (for example wood, coal) Central Heating: with occupancy rating of 0
solid_cheat_occ_minus1_less Integer number. Count of All people in households with Solid Fuel (for example wood, coal) Central Heating: with occupancy rating of minus 1 or less
oth_cheat Integer number. Count of All people in households with Other Central Heating: Total
oth_cheat_occ_plus2 Integer number. Count of All people in households with Other Central Heating: with occupancy rating of plus 2 or more
oth_cheat_occ_plus1 Integer number. Count of All people in households with Other Central Heating: with occupancy rating of plus 1
oth_cheat_occ_0 Integer number. Count of All people in households with Other Central Heating: with occupancy rating of 0
oth_cheat_occ_minus1_less Integer number. Count of All people in households with Other Central Heating: with occupancy rating of minus 1 or less
cheat_2more Integer number. Count of All people in households with Two or more types of Central Heating: Total
cheat_2more_occ_plus2 Integer number. Count of All people in households with Two or more types of Central Heating: with occupancy rating of plus 2 or more
cheat_2more_occ_plus1 Integer number. Count of All people in households with Two or more types of Central Heating: with occupancy rating of plus 1
cheat_2more_occ_0 Integer number. Count of All people in households with Two or more types of Central Heating: with occupancy rating of 0
cheat_2more_occ_minus1_less Integer number. Count of All people in households with Two or more types of Central Heating: with occupancy rating of minus 1 or less
rec_num Integer number. Unique number identifying row in table.