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_1901_pkey | Primary key | reg_dist, reg_cnty, year |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
age_reg_ew_1901_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | year | Integer number. | Year in which census taken. | reg_num | Integer number. | Number identifying each RD, and placing it in order | num_sfx | Text string (max.len.=6). | Suffix to identifying number; handles numbers such as '431A'. | reg_dist | Text string (max.len.=84). | Name of Registration District. | reg_cnty | Text string (max.len.=44). | Name of Registration County in which the RD was located | reg_cnty_unit | Integer number. | ID number of the Registration County containing the District, as defined in the AUO. | g_unit | Integer number. | ID number of the Registration District itself, as defined in the AUO. | 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_12 | Integer number. | Males aged 10 to 12. | m_13 | Integer number. | Males aged 13. | m_14 | Integer number. | Males aged 14. | m_15 | Integer number. | Males aged 15. | m_16 | Integer number. | Males aged 16. | m_17 | Integer number. | Males aged 17. | m_18 | Integer number. | Males aged 18. | m_19 | Integer number. | Males aged 19. | m_20 | Integer number. | Males aged 20. | m_21_24 | Integer number. | Males aged 21 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. | 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_12 | Integer number. | Females aged 10 to 12. | f_13 | Integer number. | Females aged 13. | f_14 | Integer number. | Females aged 14. | f_15 | Integer number. | Females aged 15. | f_16 | Integer number. | Females aged 16. | f_17 | Integer number. | Females aged 17. | f_18 | Integer number. | Females aged 18. | f_19 | Integer number. | Females aged 19. | f_20 | Integer number. | Females aged 20. | f_21_24 | Integer number. | Females aged 21 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. | 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. | m_15_64 | Integer number. | Males aged 15 to 64. | m_65_up | Integer number. | Males aged 65 and over. | f_0_14 | Integer number. | Females aged 0 to 14. | f_15_64 | Integer number. | Females aged 15 to 64. | f_65_up | Integer number. | Females aged 65 and over. | notes | Long text. | Notes. | rec_num | Integer number. | Sequence number added on loading, keeping rows in order. |
---|