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 |
---|---|---|
occ_1951_ew_stat_pkey | Primary key | rec_num |
occ_1951_ew_stat_g_unit_idx | Unique | g_unit, rec_num |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
occ_1951_ew_stat_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | cnty_name | Text string (max.len.=44). | Name of Administrative County unit as it appeared in the original report. | adm_cnty | Text string (max.len.=44). | Standardised name of Administrative county. | dist_name | Text string (max.len.=64). | Name of Local Government District unit as it appeared in the original report. | lg_dist | Text string (max.len.=64). | Standardised name of local government district. | lg_type | Text string (max.len.=16). | Type of Local Government District. | nation_unit | Integer number. | [No description available] | adm_cnty_unit | Integer number. | Unique ID number for county unit. | g_unit | Integer number. | Unique ID number for local government district unit. | sex | Text string (max.len.=6). | Sex to which the data refer: 'F'=Females, 'M'=Male, 'T'=Total. | total | Integer number. | Total Population, all ages. | tot_o15 | Integer number. | Total Population (occupied and retired) aged 15 and above. | occupied | Integer number. | Total Occupied, aged 15 and above. | retired | Integer number. | Number of Retired, aged 15 and above. | employer | Integer number. | Number of Employers, aged 15 and above. | manager | Integer number. | Number of Managers, aged 15 and above. | operativ | Integer number. | Number of Operatives, aged 15 and above. | selfempl | Integer number. | Number of Self-Employed, aged 15 and above. | unempl | Integer number. | Number of Unemployed, aged 15 and above. | notes | Text string (max.len.=1004). | Notes. | rec_num | Integer number. | Unique number identifying row in table. |
---|