A vision of Britain from 1801 to now.
Including maps, statistical trends and historical descriptions.
We are extremely grateful to the following:
Index | Type | Column(s) indexed |
---|---|---|
soc_1951_ew_pkey | Primary key | rec_num |
soc_1951_ew_g_unit_idx | Unique | g_unit, rec_num |
soc_1951_ew_idx | adm_cnty, lg_dist, lg_type, rec_num |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
soc_1951_ew_pkey | Primary Key | See details above for primary key index |
ck_soc_1951_ew | Check | ((tot_m15 = ((((class_1 + class_2) + class_3) + class_4) + class_5))) |
Column | Type | Contents | adm_cnty | Text string (max.len.=44). | Name of Administrative County unit as it appeared in the original report. | lg_dist | Text string (max.len.=64). | Name of Local Government District unit as it appeared in the original report. | lg_type | Text string (max.len.=16). | Type of Local Government District. | cnty_unit | Integer number. | Unique ID number for county unit. | g_unit | Integer number. | Unique ID number for local government district unit. | pop_1951 | Integer number. | Total population of district (NB this information does not appear in the original tables). | tot_m15 | Integer number. | Total Males (Occupied and Retired) aged 15 and over. | class_1 | Integer number. | Number of males aged 15 and over in Social Class 1 (Professional, etc Occupations). | class_2 | Integer number. | Number of males aged 15 and over in Social Class 2 (Intermediate Occupations). | class_3 | Integer number. | Number of males aged 15 and over in Social Class 3 (Skilled Occupations). | class_4 | Integer number. | Number of males aged 15 and over in Social Class 4 (Partly Skilled Occupations). | class_5 | Integer number. | Number of males aged 15 and over in Social Class 5 (Unskilled Occupations). | notes | Text string (max.len.=1004). | Notes about boundary changes; values appearing are: 'B ??', 'B,N ??', 'C ??', 'N ??', 'N,B ??' (NB these do not appear in table 27 and were presumably transcribed by Dr. Dorling from somewhere else). | rec_num | Integer number. | Unique number identifying row in table. |
---|