add cart choropleth column cross cube error file folder geo help home lock obs poi rdf remove search slice spreadsheet success table unlock warning

[this is a icon-] A spreadsheet from a data cube dataset

Mid-Year Household Estimates: a data cube spreadsheet

The number of households in each council area and in Scotland

Count (Households)
Add 1 column to data cart
Filter Areas by type:
Dimensions
Dimension
Value
Measure Type
  1. Count
Reference Period
  1. 2001
  2. 2002
  3. 2003
  4. 2004
  5. 2005
  6. 2006
  7. 2007
  8. 2008
  9. 2009
  10. 2010
  11. 2011
  12. 2012
  13. 2013
  14. 2014
  15. 2015
  16. 2016
  17. 2017
  18. 2018
  19. 2019
  20. 2020
  21. 2021
Reference Area
(showing types of area available in these data)
  1. Countries
  2. Council Areas
Download
This slice, as a spreadsheet csv
Entire dataset
Note: These may be large files.
CSVN-Triples
About the Dataset
Contact
Publisher
Not supplied
Creator
Not supplied
In dataset
License
Issued
13/07/2017
Modified
23/06/2022
Next update due
June 2023
Description

This dataset contains information on the number (‘count’) of households in each council area and in Scotland. The estimates are based on summary information on the number of dwellings in different categories provided by each council to the Scottish Government, using the Council Tax Base form, ‘Ctaxbase’, available from the Scottish Government website. Council Tax data contains information on the various discounts/exemptions awarded to each dwelling in Scotland. From these we can determine which dwellings are occupied and which are vacant or second homes. Information about the number of dwellings by their occupancy status is published on statistics.gov.scot in the ‘Household Estimates’ dataset. The number of occupied dwellings is roughly equivalent to the number of households in a council area. Data is provided in September each year, however the mid-year household estimate for Scotland and each council area is calculated by adjusting the number of occupied dwellings from September back to June. This is to be in line with the mid-year population estimates and household projections which are both based at 30 June each year. A further adjustment is made to account for differences in the number of households estimated from Council Tax data and recorded in Scotland’s Census 2001 and 2011.

For full details of the methods used see the Estimates of Households and Dwellings in Scotland publications on the National Records of Scotland (NRS) website.

Details
Confidentiality Policy

This dataset does not contain any directly identifiable personal information.

Quality Management

Estimates are compared with earlier years’ data, and with dwellings data extracted from the Assessor’s Portal, to identify any potential issues. Explanations for large changes in total dwellings are sought from local authorities. The total number of dwellings of each occupation status in each local authority is also compared to the neighbourhood scale (data zone level) collection of Council Tax data used to produce NRS’ small area household estimates (published on statistics.gov.scot as the ‘Household Estimates’ dataset).

Accuracy and Reliability

Figures have been rounded to the nearest whole number. Totals may not equal the sum of their parts as a result of this rounding. NRS’s household estimates use data on occupied dwellings taken from Council Tax systems. Although an occupied dwelling is roughly equivalent to a household, the number of occupied dwellings can differ from the number of households recorded by the census. One reason is that some dwellings may be shared by more than one household; each household would be counted by the Census but only the dwelling would be counted in Council Tax data. Another reason is that certain communal establishments (for example student halls of residence) will be included in the count of occupied dwellings from Council Tax systems but would not be classified as households in the census. The occupied dwellings figures are adjusted to account for differences between Council Tax data and the census. However, as we move further from the most recent census this may not fully account for the discrepancies.

In order to produce statistics about occupied and vacant dwellings for smaller geographic areas, NRS collects equivalent data from Council Tax systems at neighbourhood (data zone) level. This collection is carried out in September each year to align with the timing of the Ctaxbase collection. The neighbourhood data is available from the NRS website, and is published on statistics.gov.scot as the ‘Household Estimates’ dataset. For a number of council areas, the totals from summing data zone figures do not exactly match the council area figures from ‘Ctaxbase’. For example, some dwellings on the Council Tax systems do not have postcode information or have invalid postcode information. The postcode is used to identify the data zone, so a dwelling without a postcode will not be included in the data zone level figures. In most cases where there are differences, councils have confirmed that the Ctaxbase figures will be more accurate. However a small number of councils have told us that the data zone level total for a particular category is more accurate than the Ctaxbase figure. In such cases, we use the data zone total in both the neighbourhood statistics and council area household estimates. There are inconsistencies between the ways in which some Councils record Council Tax discounts and exemptions. Changes over time in categories of Council Tax discounts and exemptions can occur because a Council area has carried out a review and identified cases where a dwelling has been incorrectly categorised rather than as a result of real change 'on the ground'. In 2013, many Councils re-classified long-term empty properties and second homes, which resulted in an apparent rise in the annual increase in the number of occupied dwellings. The re-classifications were due to Council Tax changes, both in the charging of long-term empty properties and the definition of such properties and second homes. Those Council areas with the biggest changes had all carried out re-classification exercises. This makes it difficult to determine how much of the change in these areas was due to homes being brought back into use. It is possible that not all information held on Council Tax billing systems is up-to-date. For example: Councils may not be notified immediately of a change in the circumstances of a household which affects eligibility for a Council Tax discount or exemption. Furthermore it may take time for changes as a result of new building or demolition to be recorded.

Coherence and Comparability

The statistics are also provided in Excel, PDF and CSV formats on the NRS website. They are designed to be consistent, and incorporate comparable historical data where appropriate.

Accessibility and Clarity

It is the policy of the NRS to make its website and products accessible according to published guidelines. More information is available in the Accessibility section of the NRS website.

Relevance

The statistics are mainly used for informing Councils’ decisions about housing need and service provision. They are also used as the denominator for other statistics (e.g. the percentage of households receiving benefits).

Timeliness and Punctuality

Data is received from Council Tax billing systems on the first Monday of September each year and published the following summer.

Revisions

When uploading the 2018 data the 2017 value for Aberdeen City was revised down slightly to take into account the increased number of student halls in the area

Household estimates were slightly revised from 2012-2016 due to improved data on student accommodations. The revision is a decrease of less than 1.5%.

In 2015, revisions were made to the household estimates previously published for Shetland Islands (2007-2014), City of Edinburgh (2014) and West Lothian (2013-2014). For full details see the Estimates of households and dwellings in Scotland, 2015 publications on the NRS website. Revisions and corrections to previously published estimates are dealt with in accordance with the Scottish Government Statistician Group corporate policy statement on revisions and corrections - a copy of which is available on the Scottish Government website.

URI

This slice of multidimensional data is not a Linked Data resource in the database: it's a virtual resource (i.e. you can't query it by SPARQL). But does have a permanent unique URL which can be bookmarked.

http://statistics.gov.scot/slice?dataset=http%3A%2F%2Fstatistics.gov.scot%2Fdata%2Fmid-year-household-estimates&http%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fdimension%23refPeriod=http%3A%2F%2Freference.data.gov.uk%2Fid%2Fyear%2F2007
Dimensions Linked Data

A linked data-orientated view of dimensions and values

Dimension Locked Value
Reference Period
http://purl.org/linked-data/sdmx/2009/dimension#refPeriod
2007
http://reference.data.gov.uk/id/year/2007
Reference Area
http://purl.org/linked-data/sdmx/2009/dimension#refArea
(not locked to a value)
Measure Type
http://purl.org/linked-data/cube#measureType
(not locked to a value)