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 |
---|---|---|
age_wards_gb_pkey | Primary key | rec_num |
age_wards_gb_idx_name | Unique | ward, lg_dist, lg_type, adm_cnty, year, rec_num |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
age_wards_gb_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | year | Integer number. | Year in which the census was taken. | lg_dist | Text string (max.len.=36). | Name of Local Government District or Scottish Burgh/District of County. | adm_cnty | Text string (max.len.=28). | Name of Administrative County or Scottish County/City in which the District was located. NB this column is currently null for Scottish districts. | lg_type | Text string (max.len.=8). | Type of Local Government District or Scottish Burgh/District of County. | ward | Text string (max.len.=9). | Code indicating the ward to which the data relate. | pop_tot | Integer number. | Total population, computed from the individual age groups. | pop_m | Integer number. | Total male population, computed from the individual age groups. | pop_f | Integer number. | Total female population, computed from the individual age groups. | m_0 | Integer number. | Males aged under 1. | m_1_4 | Integer number. | Males aged 1 to 4. | m_0_4 | Integer number. | Males aged 0 to 4. | m_5_9 | Integer number. | Males aged 5 to 9. | m_10_14 | Integer number. | Males aged 10 to 14. | m_15_19 | Integer number. | Males aged 15 to 19. | m_20_24 | Integer number. | Males aged 20 to 24. | m_25_29 | Integer number. | Males aged 25 to 29. | m_30_34 | Integer number. | Males aged 30 to 34. | m_35_39 | Integer number. | Males aged 35 to 39. | m_40_44 | Integer number. | Males aged 40 to 44. | m_45_49 | Integer number. | Males aged 45 to 49. | m_50_54 | Integer number. | Males aged 50 to 54. | m_55_59 | Integer number. | Males aged 55 to 59. | m_60_64 | Integer number. | Males aged 60 to 64. | m_65_69 | Integer number. | Males aged 65 to 69. | m_70_74 | Integer number. | Males aged 70 to 74. | m_75_up | Integer number. | Males aged 75 and over. | m_75_79 | Integer number. | Males aged 75 to 79. | m_80_84 | Integer number. | Males aged 80 to 84. | m_85_up | Integer number. | Males aged 75 and over. | f_0 | Integer number. | Females aged under 1. | f_1_4 | Integer number. | Females aged 1 to 4. | f_0_4 | Integer number. | Females aged 0 to 4. | f_5_9 | Integer number. | Females aged 5 to 9. | f_10_14 | Integer number. | Females aged 10 to 14. | f_15_19 | Integer number. | Females aged 15 to 19. | f_20_24 | Integer number. | Females aged 20 to 24. | f_25_29 | Integer number. | Females aged 25 to 29. | f_30_34 | Integer number. | Females aged 30 to 34. | f_35_39 | Integer number. | Females aged 35 to 39. | f_40_44 | Integer number. | Females aged 40 to 44. | f_45_49 | Integer number. | Females aged 45 to 49. | f_50_54 | Integer number. | Females aged 50 to 54. | f_55_59 | Integer number. | Females aged 55 to 59. | f_60_64 | Integer number. | Females aged 60 to 64. | f_65_69 | Integer number. | Females aged 65 to 69. | f_70_74 | Integer number. | Females aged 70 to 74. | f_75_up | Integer number. | Females aged 75 and over. | f_75_79 | Integer number. | Females aged 75 to 79. | f_80_84 | Integer number. | Females aged 80 to 84. | f_85_up | Integer number. | Females aged 85 and over. | notes | Long text. | Notes. | cnty_unit | Integer number. | Unique ID number for container unit (Administrative or Scottish County/City). | dist_unit | Integer number. | Unique ID number for unit (Local Government District or Scottish Burgh/District of County). | rec_num | Integer number. | Unique number identifying row in table. |
---|