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_1881_ew_pk | Primary key | subd_id, par_id, occ_code, sex, age_group |
occ_1881_ew_reg_idx | reg_num, occ_code, sex, age_group |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
occ_1881_ew_pk | Primary Key | See details above for primary key index |
occ_1881_ew_fk_age_group | Foreign Key | Column(s) {7} link to table occ_1881_age_groups, column(s) {1}. |
occ_1881_ew_fk_occ_code | Foreign Key | Column(s) {5} link to table occ_1881_codebook, column(s) {1}. |
occ_1881_ew_fk_places | Foreign Key | Column(s) {3,4} link to table occ_1881_places, column(s) {2,3}. |
occ_1881_ew_fk_regc | Foreign Key | Column(s) {1} link to table occ_1881_regc_codes, column(s) {1}. |
occ_1881_ew_ck_sex | Check | ((((sex)::text = 'M'::text) OR ((sex)::text = 'F'::text) OR ((sex)::text = 'U'::text))) |
Column | Type | Contents | regc_code | Text string (max.len.=7). | A three-letter abbreviation for the name of the Registration County, as defined in 'occ_1881_ew_regc_codes'. | reg_num | Integer number. | Number identifying the Registration District, as extracted from subd_id and as used elsewhere in the 1881 census reports. | subd_id | Integer number. | Combined Registration District and sub-District ID, as defined in occ_1881_places. | par_id | Integer number. | Number identifying each parish, as defined in occ_1881_places. | occ_code | Integer number. | Code number identifing the occupational category, as defined on occ_1881_codebook. These run from 1 to 414, with 999 indicating missing values. | sex | Text string (max.len.=5). | Gender: 'M' = Male, 'F' = Female, 'U' = Unknown. | age_group | Integer number. | Age group, in five year bands: 1 = 0-4, 2 = 5-9, etc, as defined in occ_1881_age_groups. This was generated using the function: ceiling((whole1881.age+1)/5). After recoding a very small number of impossibly high values, these codes run up to 30, for ages 145 to 149, with 99 indicating missing data | freq | Integer number. | Number of persons in this combination of categories. | rec_num | Integer number. | Sequence number added to keep rows in order. |
---|