Private households' access to water supplies, etc in Scotland

Table ID:

HCOND_1961_S     (60478)

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:

Index	Type	Column(s) indexed
hcond_1961_s_pkey	Primary key	rec_num

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
hcond_1961_s_pkey	Primary Key	See details above for primary key index

---

Columns within table:

Column	Type	Contents
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.