Housing amenity and tenure data for 1991 wards for Great Britain

Table ID:
HCOND_1991_GB_WARD     (6565277)
Contents:
Housing amenity and tenure data for 1991 wards for Great Britain
Approx. number of rows:
10,764
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. The data are from Table S20, "Tenure and amenities: Households with residents [100%]", in the 1991 Small Area Statistics. The original table is a cross-tabulation between amenities and tenure type, but what is held here are the marginal totals, i.e. numbers with each amenity and, separately, numbers in each tenure category. The amenity data were downloaded from the NOMIS online system on 26th July 2016, and the tenure data were added on 24th November 2016.


Notes:

  1. The amenity data are limited to households living in "permanent buildings". Columns with names beginning "h_" are counts of numbers of households, and those beginning "p_" are counts of persons in the households.


Checking:

  1. The data are exactly as downloaded from NOMIS. They have NOT been rounded to the nearest 5, and some check sums work, as listed below.
  2. The following check-sums were computed:
    • That h_excl_bath_wc + h_share_bath_wc = tot_hhold. All rows passed this check and it was imposed as a check constraint.
    • That h_excl_bath_wc_heat + h_excl_bath_wc_no_heat = h_excl_bath_wc. 1,214 rows failed this check.
    • That h_share_bath_wc_heat + h_share_bath_wc_no_heat = h_share_bath_wc. 651 rows failed this check.
    • That h_excl_bath + h_share_bath + h_no_bath = tot_hhold, 1,193 rows failed this check.
    • That h_excl_inside_wc + h_share_inside_wc + h_no_inside_wc = tot_hhold, 1,205 rows failed this check.
    • That p_excl_bath_wc + p_share_bath_wc = tot_persons. All rows passed this check and it was imposed as a check constraint.
    • That p_excl_bath_wc_heat + p_excl_bath_wc_no_heat = p_excl_bath_wc. 1,203 rows failed this check.
    • That p_share_bath_wc_heat + p_share_bath_wc_no_heat = p_share_bath_wc. 696 rows failed this check.
    In each case, the checking script listed 20 of the non-compliant wards, and in every case these were in Scotland.
  3. The wards in this table have been checked to be identical to those in our polygon table for 1991 wards.


Indices:

IndexTypeColumn(s) indexed
hcond_1991_gb_ward_pkey Primary key geogcode


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
hcond_1991_gb_ward_pkey Primary Key See details above for primary key index
hcond_1991_gb_ward_check Check ((h_excl_bath_wc + h_share_bath_wc) = tot_hhold)
hcond_1991_gb_ward_check1 Check ((p_excl_bath_wc + p_share_bath_wc) = tot_persons)



Columns within table:

ColumnTypeContents
ward_name Text string (max.len.=58). Name of ward given in the data.
geogcode Text string (max.len.=16). These are six-character alphanumeric codes defined by ONS, and identify "Frozen" 1991 Wards. The documentation supplied by NOMIS says: "Wards are defined by the Local Government Commissions, and reviews take place on a rolling basis. ONS uses the wards in place at the time of the Census of Population as building blocks for other geographies. Currently, these are 1991 wards. These frozen wards allow the ONS to produce time series on a fixed geographic base. The UK has 11,330 frozen 1991 wards. Ward population counts can vary substantially, even within a single local authority, but the national average is about 5500. More populous electoral wards tend to occur in large urban areas".
district_name Text string (max.len.=44). Name of the local authority district containing the ward.
lad_geogcode Text string (max.len.=14). ONS ID for the local authority district containing the ward as used in other datasets.
tot_hhold Integer number. TOTAL HOUSEHOLDS.
h_excl_bath_wc Integer number. Households with exclusive use of bath/shower and inside WC.
h_excl_bath_wc_heat Integer number. Households with exclusive use of bath/shower and inside WC: with central heating in all or some rooms.
h_excl_bath_wc_no_heat Integer number. Households with exclusive use of bath/shower and inside WC: with no central heating.
h_share_bath_wc Integer number. Households lacking or sharing use of bath/shower and/or inside WC.
h_share_bath_wc_heat Integer number. Households lacking or sharing use of bath/shower and/or inside WC: with central heating in all or some rooms.
h_share_bath_wc_no_heat Integer number. Households lacking or sharing use of bath/shower and/or inside WC: with no central heating.
h_excl_bath Integer number. Households with exclusive use of bath/shower.
h_share_bath Integer number. Households with shared use of bath/shower.
h_no_bath Integer number. Households with no bath/shower.
h_excl_inside_wc Integer number. Households with exclusive use of inside WC.
h_share_inside_wc Integer number. Households with shared use of inside WC.
h_no_inside_wc Integer number. Households with no inside WC.
h_no_car Integer number. Households with no car.
h_permanent_tot Integer number. Total Households: Residents all permanent.
h_owned_outright Integer number. Total Households: Owner occupied owned outright.
h_owned_buying Integer number. Total Households: Owner occupied buying.
h_rent_furn Integer number. Total Households: Rented privately furnished.
h_rent_unfurn Integer number. Total Households: Rented privately unfurnished.
h_rent_job Integer number. Total Households: Rented with a job or business.
h_rent_assoc Integer number. Total Households: Rented from a housing association.
h_rent_council Integer number. Total Households: Rented from a LA, new town or Scottish Homes.
h_non_perm Integer number. Total Households: Non-permanent accomodation.
tot_persons Integer number. TOTAL PERSONS IN HOUSEHOLDS.
p_excl_bath_wc Integer number. Total persons in households with exclusive use of bath/shower and inside WC.
p_excl_bath_wc_heat Integer number. Total persons in households with central heating in all or some rooms.
p_excl_bath_wc_no_heat Integer number. Total persons in households with no central heating.
p_share_bath_wc Integer number. Total persons in households lacking or sharing use of bath/shower and/or inside WC.
p_share_bath_wc_heat Integer number. Total persons in households with central heating in all or some rooms.
p_share_bath_wc_no_heat Integer number. Total persons in households with no central heating.
p_no_car Integer number. Total persons in households with no car.
p_permanent_tot Integer number. Total persons in households: Residents all permanent.
p_owned_outright Integer number. Total persons in households: Owner occupied owned outright.
p_owned_buying Integer number. Total persons in households: Owner occupied buying.
p_rent_furn Integer number. Total persons in households: Rented privately furnished.
p_rent_unfurn Integer number. Total persons in households: Rented privately unfurnished.
p_rent_job Integer number. Total persons in households: Rented with a job or business.
p_rent_assoc Integer number. Total persons in households: Rented from a housing association.
p_rent_council Integer number. Total persons in households: Rented from a LA, new town or Scottish Homes.
p_non_perm Integer number. Total persons in households: Non-permanent accomodation.
rec_num Integer number. Sequence number keeping the rows in the order downloaded from NOMIS.