A vision of Britain from 1801 to now.
Including maps, statistical trends and historical descriptions.
ceiling((whole1881.age+1)/5)This places each individual into a five year band, starting with 0 to 4, 5 to 9 and so on, but unlike the published census reports there is no catch-all top category (e.g. '100 and upwards'). This table therefore runs up to age_group=30, ages 145-9 so as to cover the highest actual value. Age-group = 99 is included to cover unknown values.
Index | Type | Column(s) indexed |
---|---|---|
occ_1881_age_groups_pkey | Primary key | age_group |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
occ_1881_age_groups_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | age_group | Integer number. | Values of 'age_group' as they appear in 'occ_1881', running from 1 (0 to 4) to 30 (145-9). | min_age | Integer number. | Lowest age, in years, within the age group. | max_age | Integer number. | Highest age, in years, within the age group. | age_label | Text string (max.len.=15). | Text describing the age group, e.g. '0 to 4'. |
---|