Private households' access to water supplies, etc in Scotland

Table ID:
HCOND_1961_S     (6565241)
Contents:
Private households' access to water supplies, etc in Scotland
Approx. number of rows:
964
Table type:
Raw Data
Documentation Author:
Paula Aucott
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. The information is taken from table 23, 'Private Households by availability of certain Household Arrangements' by 'County, Large Burghs, Small Burghs, Districts of County, New Towns', in the County Reports of the 1961 Census of Scotland.


Notes:

  1. The information covers the whole of Scotland and was entered in Portsmouth by Rachel Granville in Summer 2002. It gives information on whether the households had access to hot and cold water taps, fixed baths, water closets or all four arrangements and if so, whether that access was exclusive or shared.
  2. The table contains data for seven types of area, identified by values of 'dist_type'. All areas of these types have been consistently matched to the AUO:
    • CT = City (4 areas): Aberdeen, Dundee, Edinburgh and Glasgow.
    • DC = District of County (197 areas).
    • LBu = Large Burgh (20 areas): Other main towns.
    • SBu = Small Burgh (174 areas): small towns.
    • LD = Landward (33 areas): Remainders of counties, excluding the Burghs.
    • NT = New Town (3 areas): Cumbernauld, East Kilbride, Glenrothes.
    • li>CON = Conurbation: (1 area), Central Clydeside.
  3. The data contain either two or three rows for all areas:
    • for smaller units it is divided into 'All Households' (h_type = 'A') and 'Households Sharing Dwellings' (h_type = 'S')
    • or
    • for larger units it is divided into 'All Households' (h_type = 'A') and 'Households Sharing Dwellings with Exclusive use' (h_type = 'SEU') and 'Households Sharing Dwellings with non-exclusive use' (h_type = 'SNEU')
  4. The rows giving totals for the 4 cities has been duplicated and added to the table again as data for the burghs of the same name. This is to ensure consistency in the mapping on A Vision of Britain through Time. Please ignore these rows for all other purposes.


Checking:

  1. The number of households with shared use of a cold water tap was turned into a percentage of the total number of households then this percentage was checked against the percentage figure given in the original table.
  2. The number of households without use of a cold water tap was turned into a percentage of the total number of households then this percentage was checked against the percentage figure given in the original table.
  3. The number of households with shared use of a hot water tap was turned into a percentage of the total number of households then this percentage was checked against the percentage figure given in the original table.
  4. The number of households without use of a hot water tap was turned into a percentage of the total number of households then this percentage was checked against the percentage figure given in the original table.
  5. The number of households with shared use of a fixed bath was turned into a percentage of the total number of households then this percentage was checked against the percentage figure given in the original table.
  6. The number of households without use of a fixed bath was turned into a percentage of the total number of households then this percentage was checked against the percentage figure given in the original table.
  7. The number of households with shared use of a water closet was turned into a percentage of the total number of households then this percentage was checked against the percentage figure given in the original table.
  8. The number of households without use of a water closet was turned into a percentage of the total number of households then this percentage was checked against the percentage figure given in the original table.
  9. The number of households with exclusive use of all four arrangements was turned into a percentage of the total number of households then this percentage was checked against the percentage figure given in the original table.
  10. 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_1961_s_pkey Primary key rec_num
hcond_1961_s_idx Unique sco_cnty, area_name, area_type, h_type, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
hcond_1961_s_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
area_type Text string (max.len.=16). Type of area, as listed in the original report; see note above.
area_name Text string (max.len.=64). Name of the area, as it appeared in the original report, i.e. lower case.
sco_cnty Text string (max.len.=44). Name of container unit (county).
cnty_unit Integer number. ID number from AUO for county containing the area.
g_unit Integer number. Unique ID number for unit.
im_auth Text string (max.len.=44). Immediate authority, in this case the Census.
im_note Text string (max.len.=44). Note on Immediate authority, in this case the table number from the Census where the majority of data came from.
h_type Text string (max.len.=12). Values given are 'A' for 'All Households' and 'S' for 'Households Sharing Dwellings'. For administrative units with larger populations the shared dwellings are divided into those which have shared exclusive use 'SEU' and those with shared non-exclusive use 'SNEU'.
tot_hous Integer number. Total number of houses.
cold_s Integer number. Households with shared access to a cold water tap.
pc_cold_s Floating point number. Percentage of Households with shared access to a cold water tap.
cold_n Integer number. Households without access to a cold water tap.
pc_cold_n Floating point number. Percentage of Households without access to a cold water tap.
hot_s Integer number. Households with shared access to a hot water tap.
pc_hot_s Floating point number. Percentage of Households with shared access to a hot water tap.
hot_n Integer number. Households without access to a hot water tap.
pc_hot_n Floating point number. Percentage of Households without access to a hot water tap.
bath_s Integer number. Households with shared use of a fixed bath.
pc_bath_s Floating point number. Percentage of Households with shared use of a fixed bath.
bath_n Integer number. Households with no use of a fixed bath.
pc_bath_n Floating point number. Percentage of Households with no use of a fixed bath.
wc_s Integer number. Households with shared use of a water closet.
pc_wc_s Floating point number. Percentage of Households with shared use of a water closet.
wc_n Integer number. Households with no use of a water closet.
pc_wc_n Floating point number. Percentage of Households with no use of a water closet.
all4_e Integer number. Households with exclusive access to all 4 facilities.
pc_all4_e Floating point number. Percentage of Households with exclusive access to all 4 facilities.
notes Text string (max.len.=1004). Any comments added during transcription.
rec_num Integer number. Unique number identifying row in table.