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. |