A vision of Britain through time

A vision of Britain from 1801 to now.

Including maps, statistical trends and historical descriptions.

- Table ID:
- HOUS_1931_S (6565421)
- Contents:
- Housing Statistics (persons per room) from the 1931 Scottish Census.
- Approx. number of rows:
- 75
- Table type:
- Raw Data
- Documentation Author:
- Paula Aucott
- Chronology:
- The data cover the period 1881 to 1911.

- This table is a partial transcription of table 26 ('Houses: Number of Rooms by Number of Persons') in the individual county reports of the 1931 Census for Scotland.

- These data were entered by Rachel Granville in Portsmouth in Autumn 2002.
- A partial transciption of these tables were entered to give as accurate a match as possible to the England and Wales data. All columns were entered apart from the individual number of private families occupying 5, 6 to 7, 8 to 9, and 10 or more rooms and all columns which can be calculated using transcribed data, i.e. total persons in private houses against number of persons per room, also total occupied private houses in 1921, total persons in private houses in 1931 and 1921, number of private houses without sub-lets and percentage of these out of all private houses against number of rooms.
- The data covers counties, cities and some burghs, as indicated by area_type:
**County**(33 areas): Includes data for all burghs, whether or not separately listed, but not data for Cities.**City**(4 areas): Aberdeen, Dundee, Edinburgh and Glasgow.**Large Burgh**(20 areas): These match those listed in the 1931 Industry Table.**Small Burgh**(14 areas).

- Note given on the table 'Institutions and other large establishments, with their populations, are excluded from Tables 26-29. Additional information in regard to the sub-letting of Houses will be found in Table 30.
- Note given on the table for cities 'The 1921 figures are for the area of the City as at the Census of 1931.'
- The 'over_1', 'over_1_5' and 'over_2' fields were computed by us from the data. Our calculations assume that tenements occupied by '15 or more' persons contained 15 people, and are therefore obviously underestimates.
- The field 'tot_u5' was not transcribed, but computed from the totals for families occupying, 2, 3 and 4 rooms after the data had been loaded.
- The rows giving totals for the 4 cities have 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.

- The data was checked in excel to ensure the total number of private houses matched the combined figure of private houses with the same number of rooms where the number of rooms equalled 1, 2, 3 or 4 i.e. r1_tot=r1_p1+r1_p2...
- The same check was done to ensure the total number of private families (tot_pfam) matched the combined total of families in each house.
- The total number of private families was also checked against the sum of the totals for each house with a different number of rooms i.e.r1_tot+r2_tot...
- The total number of houses with 1 sub-let was compared against the sum of houses with 1 sub-let with different number of rooms. The same was done for 2 or more sub-lets, but this could only check the total was not less than the combined sum.
- 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.

Index | Type | Column(s) indexed |
---|---|---|

hous_1931_s_pkey | Primary key | rec_num |

The table has the following associated constraints:

Constraint | Type | Details |
---|---|---|

hous_1931_s_pkey | Primary Key | See details above for primary key index |

Column | Type | Contents |
---|---|---|

rec_num | Integer number. | Unique number identifying row in table. |

sco_cnty | Text string (max.len.=44). | Name of Scottish County unit containing the district as it appeared in the original report. |

area_name | Text string (max.len.=64). | Name of Scottish District unit as it appeared in the original report, i.e. lower case. |

area_type | Text string (max.len.=16). | Type of area. |

cnty_unit | Integer number. | ID for county containing the unit, from the AUO. |

g_unit | Integer number. | ID number for the unit, from the AUO. |

tot_u5 | Integer number. | Total number of private families living in less than 5 rooms (derived from r1_tot+r2_tot+r_3tot+r4_tot). |

r1_p1 | Integer number. | Number of 1 person private families occupying 1 room. |

r1_p2 | Integer number. | Number of 2 person private families occupying 1 room. |

r1_p3 | Integer number. | Number of 3 person private families occupying 1 room. |

r1_p4 | Integer number. | Number of 4 person private families occupying 1 room. |

r1_p5 | Integer number. | Number of 5 person private families occupying 1 room. |

r1_p6 | Integer number. | Number of 6 person private families occupying 1 room. |

r1_p7 | Integer number. | Number of 7 person private families occupying 1 room. |

r1_p8 | Integer number. | Number of 8 person private families occupying 1 room. |

r1_p9 | Integer number. | Number of 9 person private families occupying 1 room. |

r1_p10 | Integer number. | Number of 10 person private families occupying 1 room. |

r1_p11 | Integer number. | Number of 11 person private families occupying 1 room. |

r1_p12 | Integer number. | Number of 12 person private families occupying 1 room. |

r1_p13 | Integer number. | Number of 13 person private families occupying 1 room. |

r1_p14 | Integer number. | Number of 14 person private families occupying 1 room. |

r1_p15up | Integer number. | Number of 15 or more person private families occupying 1 room. |

r1_tot | Integer number. | Total number of private families occupying 1 room. |

r2_p1 | Integer number. | Number of 1 person private families occupying 2 rooms. |

r2_p2 | Integer number. | Number of 2 person private families occupying 2 rooms. |

r2_p3 | Integer number. | Number of 3 person private families occupying 2 rooms. |

r2_p4 | Integer number. | Number of 4 person private families occupying 2 rooms. |

r2_p5 | Integer number. | Number of 5 person private families occupying 2 rooms. |

r2_p6 | Integer number. | Number of 6 person private families occupying 2 rooms. |

r2_p7 | Integer number. | Number of 7 person private families occupying 2 rooms. |

r2_p8 | Integer number. | Number of 8 person private families occupying 2 rooms. |

r2_p9 | Integer number. | Number of 9 person private families occupying 2 rooms. |

r2_p10 | Integer number. | Number of 10 person private families occupying 2 rooms. |

r2_p11 | Integer number. | Number of 11 person private families occupying 2 rooms. |

r2_p12 | Integer number. | Number of 12 person private families occupying 2 rooms. |

r2_p13 | Integer number. | Number of 13 person private families occupying 2 rooms. |

r2_p14 | Integer number. | Number of 14 person private families occupying 2 rooms. |

r2_p15up | Integer number. | Number of 15 or more person private families occupying 2 rooms. |

r2_tot | Integer number. | Total number of private families occupying 2 rooms. |

r3_p1 | Integer number. | Number of 1 person private families occupying 3 rooms. |

r3_p2 | Integer number. | Number of 2 person private families occupying 3 rooms. |

r3_p3 | Integer number. | Number of 3 person private families occupying 3 rooms. |

r3_p4 | Integer number. | Number of 4 person private families occupying 3 rooms. |

r3_p5 | Integer number. | Number of 5 person private families occupying 3 rooms. |

r3_p6 | Integer number. | Number of 6 person private families occupying 3 rooms. |

r3_p7 | Integer number. | Number of 7 person private families occupying 3 rooms. |

r3_p8 | Integer number. | Number of 8 person private families occupying 3 rooms. |

r3_p9 | Integer number. | Number of 9 person private families occupying 3 rooms. |

r3_p10 | Integer number. | Number of 10 person private families occupying 3 rooms. |

r3_p11 | Integer number. | Number of 11 person private families occupying 3 rooms. |

r3_p12 | Integer number. | Number of 12 person private families occupying 3 rooms. |

r3_p13 | Integer number. | Number of 13 person private families occupying 3 rooms. |

r3_p14 | Integer number. | Number of 14 person private families occupying 3 rooms. |

r3_p15up | Integer number. | Number of 15 or more person private families occupying 3 rooms. |

r3_tot | Integer number. | Total number of private families occupying 3 rooms. |

r4_p1 | Integer number. | Number of 1 person private families occupying 4 rooms. |

r4_p2 | Integer number. | Number of 2 person private families occupying 4 rooms. |

r4_p3 | Integer number. | Number of 3 person private families occupying 4 rooms. |

r4_p4 | Integer number. | Number of 4 person private families occupying 4 rooms. |

r4_p5 | Integer number. | Number of 5 person private families occupying 4 rooms. |

r4_p6 | Integer number. | Number of 6 person private families occupying 4 rooms. |

r4_p7 | Integer number. | Number of 7 person private families occupying 4 rooms. |

r4_p8 | Integer number. | Number of 8 person private families occupying 4 rooms. |

r4_p9 | Integer number. | Number of 9 person private families occupying 4 rooms. |

r4_p10 | Integer number. | Number of 10 person private families occupying 4 rooms. |

r4_p11 | Integer number. | Number of 11 person private families occupying 4 rooms. |

r4_p12 | Integer number. | Number of 12 person private families occupying 4 rooms. |

r4_p13 | Integer number. | Number of 13 person private families occupying 4 rooms. |

r4_p14 | Integer number. | Number of 14 person private families occupying 4 rooms. |

r4_p15up | Integer number. | Number of 15 or more person private families occupying 4 rooms. |

r4_tot | Integer number. | Total number of private families occupying 4 rooms. |

tot_pfam_p1 | Integer number. | The total number of 1 person private families. |

tot_pfam_p2 | Integer number. | The total number of 2 person private families. |

tot_pfam_p3 | Integer number. | The total number of 3 person private families. |

tot_pfam_p4 | Integer number. | The total number of 4 person private families. |

tot_pfam_p5 | Integer number. | The total number of 5 person private families. |

tot_pfam_p6 | Integer number. | The total number of 6 person private families. |

tot_pfam_p7 | Integer number. | The total number of 7 person private families. |

tot_pfam_p8 | Integer number. | The total number of 8 person private families. |

tot_pfam_p9 | Integer number. | The total number of 9 person private families. |

tot_pfam_p10 | Integer number. | The total number of 10 person private families. |

tot_pfam_p11 | Integer number. | The total number of 11 person private families. |

tot_pfam_p12 | Integer number. | The total number of 12 person private families. |

tot_pfam_p13 | Integer number. | The total number of 13 person private families. |

tot_pfam_p14 | Integer number. | The total number of 14 person private families. |

tot_pfam_p15up | Integer number. | The total number of 15 or over person private families. |

tot_pfam | Integer number. | The total number of private families. |

r5_tot | Integer number. | The total number of private families occupying 5 rooms. |

r6_tot | Integer number. | The total number of private families occupying 6 rooms. |

r7_tot | Integer number. | The total number of private families occupying 7 rooms. |

r8_tot | Integer number. | The total number of private families occupying 8 rooms. |

r9_tot | Integer number. | The total number of private families occupying 9 rooms. |

r10up_tot | Integer number. | The total number of private families occupying 10 and over rooms. |

pop_pfam | Integer number. | The total population in private families. |

r1_1slet | Integer number. | Number of private houses with 1 room and 1 sub-let. |

r2_1slet | Integer number. | Number of private houses with 2 rooms and 1 sub-let. |

r3_1slet | Integer number. | Number of private houses with 3 rooms and 1 sub-let. |

r4_1slet | Integer number. | Number of private houses with 4 rooms and 1 sub-let. |

r5_1slet | Integer number. | Number of private houses with 5 rooms and 1 sub-let. |

r6_1slet | Integer number. | Number of private houses with 6 rooms and 1 sub-let. |

r7_1slet | Integer number. | Number of private houses with 7 rooms and 1 sub-let. |

r8_1slet | Integer number. | Number of private houses with 8 rooms and 1 sub-let. |

r9_1slet | Integer number. | Number of private houses with 9 rooms and 1 sub-let. |

r10up_1slet | Integer number. | Number of private houses with 10 rooms and up and 1 sub-let. |

tot_1slet | Integer number. | total Number of private houses with 1 sub-let. |

r1_2slet | Integer number. | Number of private houses with 1 room and 2 or more sub-lets. |

r2_2slet | Integer number. | Number of private houses with 2 rooms and 2 or more sub-lets. |

r3_2slet | Integer number. | Number of private houses with 3 rooms and 2 or more sub-lets. |

r4_2slet | Integer number. | Number of private houses with 4 rooms and 2 or more sub-lets. |

r5_2slet | Integer number. | Number of private houses with 5 rooms and 2 or more sub-lets. |

r6_2slet | Integer number. | Number of private houses with 6 rooms and 2 or more sub-lets. |

r7_2slet | Integer number. | Number of private houses with 7 rooms and 2 or more sub-lets. |

r8_2slet | Integer number. | Number of private houses with 8 rooms and 2 or more sub-lets. |

r9_2slet | Integer number. | Number of private houses with 9 rooms and 2 or more sub-lets. |

r10up_2slet | Integer number. | Number of private houses with 10 rooms or more and 2 or more sub-lets. |

tot_2slet | Integer number. | Total number of private houses with 2 or more sub-lets. |

over_1 | Integer number. | Number of occupants of tenements of 4 rooms or less with more than 1 occupants per room. (derived value) |

over_1_5 | Integer number. | Number of occupants of tenements of 4 rooms or less with more than 1.5 occupants per room. (derived value) |

over_2 | Integer number. | Number of occupants of tenements of 4 rooms or less with more than 2 occupants per room. (derived value) |

notes | Text string (max.len.=404). | Comments (generally appearing as footnotes to the original table and mostly concerning boundary changes). |