GB Historical DB

Housing Amenity and Tenure statistics from the Census redistricted into 2011 Local Authority Districts

Table ID:
HCOND_REDISTRICTED     (1250851)
Contents:
Housing Amenity and Tenure statistics from the Census redistricted into 2011 Local Authority Districts
Approx. number of rows:
3,010
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1951 to 2011.
Dates and times are identified by:
   Year

Sources:

  1. This table was generated from data held in the following tables from the Census:
    • hcond_2011_gb_heat
    • hcond_1991_gb_ward
    • hcond_1971_ew
    • hcond_1971_s
    • hcond_1951_s
    • hcond_1951_ew
    . Data has been rearranged into columns containing counts.
  2. The table covers England, Wales and Scotland.

Notes:

  1. All counts currently held here are for numbers of households. Counts of numbers of persons in households are available for some but not all years. These often appear as cross-tabulations against tenure type, but here we include separate counts of tenure type.
  2. The source tables contain a wide range of variables, but there are large differences between censuses in which "amenities" were recorded. The 1951 report includes data on cooking facilities. This table therefore contains only a small subset of possible variables, limited to those which can usefully be compared between years. However, note that a direct comparison over the full period 1951-2011 is simply impossible, because the 2011 census gathered data only on Central Heating, which was not reported at all in 1951 or 1971.
  3. The one variable reported here for all years is the number of households with "All Amenities", but this unavoidably varies between years:
    • 1951: Households with exclusive use of piped water, a cooking stove, a kitchen sink, a Water Closet and a fixed bath.
    • 1971: Households with exclusive use of hot water, fixed bath and inside water closet.
    • 1991: Households with exclusive use of a bath or shower, inside WC and with central heating in all or some rooms.
    • 2011: "Household Spaces" with any kind of central heating.
  4. Data on tenure type is included from 1961 onwards, but what is held here has to be simpler than what is listed in any specific year due to variations in what was reported. See the detailed documentation of the columns, but note in particular that households renting from Housing Associations have to be included in the general "rented" category, rather than with council housing in a "social housing" category, because in 1971 they were included with those renting unfurnished property from private landlords.

Indices:

IndexTypeColumn(s) indexed
hcond_redistricted_pkey Primary key g_unit, year

Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
hcond_redistricted_pkey Primary Key See details above for primary key index
hcond_redistricted_area_type_check Check ((((area_type)::text = 'COUNTRY'::text) OR ((area_type)::text = 'DISTRICT'::text) OR ((area_type)::text = 'GOR'::text) OR ((area_type)::text = 'MOD_REG'::text) OR ((area_type)::text = 'MOD_CNTY'::text) OR ((area_type)::text = 'NATION'::text)))
hcond_redistricted_nat_source_check Check ((((nat_source)::text = 'Reported_total'::text) OR ((nat_source)::text = 'Sum_of_redist'::text) OR ((nat_source)::text = 'Sum_of_raw_EnumD'::text) OR ((nat_source)::text = 'Sum_of_raw_Par'::text) OR ((nat_source)::text = 'Sum_of_raw_Ward'::text) OR ((nat_source)::text = 'Sum_of_EW_and_Scot'::text)))


Columns within table:

ColumnTypeContents
area_type Text string (max.len.=16). Type of area:
  • "DISTRICT" = data are for a Local Authority District.
  • "MOD_CNTY" = data are for a current county (these exist only in England).
  • "GOR" = data are for a Government Office Region.
  • "NATION" = data are overall totals for England and Wales, or Scotland, or Great Britain.
nation Text string (max.len.=6). Nation unit within. Defined as "EW" for England and Wales", "S" for Scotland.
nat_source Text string (max.len.=28). Appears only for rows which are national totals, and then identifies how they were derived. This will ideally be "Reported_total".
area_code Text string (max.len.=18). ONS ID for the 2011 Local Authority District.
area_name Text string (max.len.=40). Name of the 2011 Local Authority District.
g_unit Integer number. GBHGIS ID number for the 2011 Local Authority District as defined in the AUO.
year Integer number. Calendar year the data are for.
geogcode_1991 Text string (max.len.=17). This column holds the census office identifier for the district as used in 1991, but only if we know the district had the same boundaries in 1991 and 2011. This is currently set only for the London Boroughs.
tot_hhold Integer number. Total number of households. In 2011, this is labelled "Household Spaces".
excl_bath Integer number. Number of households with exclusive use of a bath or shower. Both 1951 and 1971 specify a "fixed bath", and 1951 does not mention showers. The count is not available for 2011.
share_bath Integer number. Number of households with shared use of a bath or shower. Both 1951 and 1971 specify a "fixed bath", and 1951 does not mention showers. The count is not available for 2011.
excl_wc Integer number. Number of households with exclusive use of a WC (toilet). For 1951, this covers inside or outside WCs, for 1971 we combine the separate counts for indoor and outdoor WCs, and in 1991 the count is specifically of inside WCs. The count is not available for 2011.
share_wc Integer number. Number of households with shared use of a WC (toilet). For 1951, this covers inside or outside WCs, for 1971 we combine the separate counts for indoor and outdoor WCs, and in 1991 the count is specifically of inside WCs. The count is not available for 2011.
cen_heat Integer number. Number of households with central heating in some or all rooms. This is available only in 1991 and 2011, and in 2011 the original table provides a detailed breakdown of the kind of fuel used by the central heating.
all_amenity Integer number. Number of households with all possible amenities. See note above for how this varies between years.
tenure_total Integer number. Total number of households included in the tenure data. This excludes households in non-permanent households and those supplying no data.
tenure_owned Integer number. Number of households living in owner-occupied accommodation:
  • 1971: "Owner-Occupier".
  • 1991: "Owner occupied owned outright" and "Owner occupied buying".
  • 2011: Includes those owned outright, those owned with a mortgage or loan, and those "owned through shared ownership (part owned part rented)".
tenure_council Integer number. Number of households living in accommodation rented from public bodies:
  • 1971: "Rented from a council or new town"
  • 1991: "Rented from a LA, new town or Scottish Homes".
  • 2011: "rented from the Council (Local Authority)".
tenure_rented Integer number. Number of households living in other rented accommodation:
  • 1971: includes "Rented unfurnished from a private landlord or housing assocation" and "Rented furnished".
  • 1991: "Rented privately furnished", "Rented privately unfurnished", "Rented with a job or business" or "Rented from a housing association".
  • 2011: "rented from other social housing providers", "rented from private landlords or letting agencies", "rented from other sources" and "living rent free".
g_authority Text string (max.len.=28). Authority identifier for source of the data.
g_auth_note Text string (max.len.=408). Detail on authority
g_data_precision Text string (max.len.=12). Data precision identifier; E = Exact, GBE = Estimated by GBH project, GBR = Redistricted by GBH project.
g_data_status Text string (max.len.=9). Flag indicating access status. Current set to P for Public for all rows.
rec_num Integer number. Unique number identifying row in table.