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_lgd_ew_pkey | Primary key | rec_num |
age_lgd__ew_dist_idx | Unique | adm_cnty, dist_name, lg_type, year, rec_num |
age_lgd_ew_cnty_idx | Unique | adm_cnty, year, rec_num |
age_lgd_ew_g_unit_idx | Unique | g_unit, rec_num |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
age_lgd_ew_pkey | Primary Key | See details above for primary key index |
ck_age_lgd_ew_f_tot | Check | (((tot_fem - (((((((((((((((((f_0_4 + f_5_9) + f_10_14) + f_15_19) + f_20_24) + f_25_29) + f_30_34) + f_35_39) + f_40_44) + f_45_49) + f_50_54) + f_55_59) + f_60_64) + f_65_69) + f_70_74) + f_75_79) + f_80_84) + f_85_up)) * correct) = 0) |
ck_age_lgd_ew_f_u5 | Check | (((((f_0 + f_1) + f_2) + f_3) + f_4) = f_0_4) |
ck_age_lgd_ew_m_tot | Check | (((tot_male - (((((((((((((((((m_0_4 + m_5_9) + m_10_14) + m_15_19) + m_20_24) + m_25_29) + m_30_34) + m_35_39) + m_40_44) + m_45_49) + m_50_54) + m_55_59) + m_60_64) + m_65_69) + m_70_74) + m_75_79) + m_80_84) + m_85_up)) * correct) = 0) |
ck_age_lgd_ew_m_u5 | Check | (((((m_0 + m_1) + m_2) + m_3) + m_4) = m_0_4) |
Column | Type | Contents |
---|---|---|
year | Integer number. | Year in which census was taken. |
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. |
adm_cnty_unit | Integer number. | Unique ID number for county unit. |
g_unit | Integer number. | Unique ID number for local government district unit. |
part_of | Text string (max.len.=5). | A 'P' in this column indicates that data for only part of the place is recorded. It may be that another part is recorded in a different county. |
tot_pop | Integer number. | Total population. |
tot_male | Integer number. | Total male population. |
m_0 | Integer number. | Males aged under 1. |
m_1 | Integer number. | Males aged between 1 and 2. |
m_2 | Integer number. | Males aged between 2 and 3. |
m_3 | Integer number. | Males aged between 3 and 4. |
m_4 | Integer number. | Males aged between 4 and 5. |
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_79 | Integer number. | Males aged 75 to 79. |
m_80_84 | Integer number. | Males aged 80 to 84. |
m_85_89 | Integer number. | Males aged 85 to 89. |
m_85_up | Integer number. | Males aged 85 and over. This is the top age band for 1971; for earlier years it is derived. |
m_90_94 | Integer number. | Males aged 90 to 94. |
m_95_up | Integer number. | Males aged 95 and over. |
m_95_99 | Integer number. | Males aged 95 to 99. |
m_100_up | Integer number. | Males aged 100 and over. |
tot_fem | Integer number. | Total female population. |
f_0 | Integer number. | Females aged under 1. |
f_1 | Integer number. | Females aged between 1 and 2. |
f_2 | Integer number. | Females aged between 2 and 3. |
f_3 | Integer number. | Females aged between 3 and 4. |
f_4 | Integer number. | Females aged between 4 and 5. |
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_79 | Integer number. | Females aged 75 to 79. |
f_80_84 | Integer number. | Females aged 80 to 84. |
f_85_89 | Integer number. | Females aged 85 to 89. |
f_85_up | Integer number. | Females aged 85 and over. This is the top age band for 1971; for earlier years it is derived. |
f_90_94 | Integer number. | Females aged 90 to 94. |
f_95_up | Integer number. | Females aged 95 and over. |
f_95_99 | Integer number. | Females aged 95 to 99. |
f_100_up | Integer number. | Females aged 100 and over. |
m_0_14 | Integer number. | Males aged 0 to 14 [derived]. |
m_15_64 | Integer number. | Males aged 15 to 64 [derived]. |
m_65_up | Integer number. | Males aged 65 and over [derived]. |
f_0_14 | Integer number. | Females aged 0 to 14 [derived]. |
f_15_64 | Integer number. | Females aged 15 to 64 [derived]. |
f_65_up | Integer number. | Females aged 65 and over [derived]. |
correct | Integer number. | Flag field supporting check constraints: Set equal to 0 if there is an uncorrectable error, and to 1 otherwise. |
notes | Text string (max.len.=4004). | Notes. |
rec_num | Integer number. | Unique number identifying row in table. |