Housing density data for Local Authorities in Scotland in 2011

Table ID:
HOUS_2011_S     (6565503)
Contents:
Housing density data for Local Authorities in Scotland in 2011
Approx. number of rows:
32
Table type:
Raw Data
Documentation Author:
Paula Aucott
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. This table combines two complete tables in the 2011 Quick Statistics release: Table QS409SC, "Persons per room - Households" and Table QS410SC, "Persons per room - People". They were downloaded from the Scotland's Census website on 2nd August 2016, and assembled into a single file.


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.


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
hous_2011_s_pkey Primary key lau_name
hous_2011_s_g_unit_idx Unique g_unit


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
hous_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.
g_unit Integer number. Unique ID number for local authority unit from the auo gazetteer.
tot_hous Integer number. Count of all households
h_u_50 Integer number. Number of householdsliving at less than and up to 0.5 persons per room.
h_50_1 Integer number. Number of householdsliving at 0.5 and over and up to 1.0 persons per room.
h1_1_5 Integer number. Number of householdsliving at over 1 and up to 1.5 persons per room.
h1_5_up Integer number. Number of householdsliving at over 1.5 persons per room.
pop_hous Integer number. Count of all people in households.
p_u_50 Integer number. Total population in all households living at less than and up to 0.5 persons per room.
p_50_1 Integer number. Total population in all households living at 0.5 and over and up to 1.0 persons per room.
p1_1_5 Integer number. Total population in all households living at over 1 and up to 1.5 persons per room.
p1_5_up Integer number. Total population in all households living at over 1.5 persons per room.
rec_num Integer number. Unique number identifying row in table.