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_reg_ew_pkey | Primary key | rec_num |
age_reg_dist_ew_idx | Unique | reg_cnty, dist_name, year, rec_num |
age_reg_ew_cnty_idx | Unique | reg_cnty, year, rec_num |
age_reg_ew_g_unit_idx | Unique | g_unit, rec_num |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
age_reg_ew_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | year | Integer number. | Year in which census was taken. | reg_num | Integer number. | Number of Registration District, as listed in original census report. | reg_sfx | Text string (max.len.=6). | Suffix to Registration District number as given in the original report. | cnty_name | Text string (max.len.=44). | Name of Registration County unit as it appeared in the original report. | reg_cnty | Text string (max.len.=44). | Name of registration county unit in standardised form. | dist_name | Text string (max.len.=64). | Name of Local Government District unit as it appeared in the original report. | reg_dist | Text string (max.len.=84). | Name of registration district unit in standardised form. | reg_cnty_unit | Integer number. | Unique ID number for county unit. | g_unit | Integer number. | Unique ID number for registration district unit. | 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 1. | m_2 | Integer number. | Males aged 2. | m_3 | Integer number. | Males aged 3. | m_4 | Integer number. | Males aged 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_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_90_94 | Integer number. | Males aged 90 to 94. | m_95_up | Integer number. | Males aged 95 and over; this is a derived value, included for better comparability with C20 data. | 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 1. | f_2 | Integer number. | Females aged 2. | f_3 | Integer number. | Females aged 3. | f_4 | Integer number. | Females aged 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_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_90_94 | Integer number. | Females aged 90 to 94. | f_95_up | Integer number. | Females aged 95 and over; this is a derived value, included for better comparability with C20 data. | 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]. | notes | Text string (max.len.=4004). | Notes. | rec_num | Integer number. | Unique number identifying row in table. |
---|