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 |
---|---|---|
mort_age_ew_reg_dec_pkey | Primary key | decade, reg_dist_unit |
mort_age_ew_reg_dec_idx | Unique | reg_dist, reg_cnty, decade |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
mort_age_ew_reg_dec_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | decade | Integer number. | Inter-censal period, for example 1901-11='1900'. | reg_num | Integer number. | Number identifying each RD, and placing it in order. | reg_sfx | Text string (max.len.=8). | Suffix to ID number, allowing IDs such as '431A'. | reg_dist | Text string (max.len.=44). | Name of Registration District to which data relate. | reg_cnty | Text string (max.len.=24). | Name of Registration County in which the district was located. | reg_dist_unit | Integer number. | ID number of the Registration District, as defined in the AUO. | reg_cnty_unit | Integer number. | ID number of the Registration County, as defined in the AUO. | births | Integer number. | Total number of births. | deaths | Integer number. | Total number of deaths. | m_births | Integer number. | Total number of male births. | m_deaths | Integer number. | Total number of male deaths. | m_0 | Integer number. | Deaths of males aged under 1. | m_1 | Integer number. | Deaths of males aged 1 and under 2. | m_2 | Integer number. | Deaths of males aged 2 and under 3. | m_3 | Integer number. | Deaths of males aged 3 and under 4. | m_4 | Integer number. | Deaths of males aged 4 and under 5. | m_2_4 | Integer number. | Deaths of males aged 2 and under 5 (1901-10 only). | m_0_4 | Integer number. | Deaths of males aged 0 to 4. | m_5_9 | Integer number. | Deaths of males aged 5 to 9. | m_10_14 | Integer number. | Deaths of males aged 10 to 14. | m_15_19 | Integer number. | Deaths of males aged 15 to 19. | m_20_24 | Integer number. | Deaths of males aged 20 to 24. | m_25_34 | Integer number. | Deaths of males aged 25 to 34. | m_35_44 | Integer number. | Deaths of males aged 35 to 44. | m_45_54 | Integer number. | Deaths of males aged 45 to 54. | m_55_64 | Integer number. | Deaths of males aged 55 to 64. | m_65_74 | Integer number. | Deaths of males aged 65 to 74. | m_75_up | Integer number. | Deaths of males aged 75 and upwards. | m_75_84 | Integer number. | Deaths of males aged 75 to 84. (1851-60 only) | m_85_up | Integer number. | Deaths of males aged 85 and upwards (1851-60 only). | f_births | Integer number. | Total number of female births. | f_deaths | Integer number. | Total number of female deaths. | f_0 | Integer number. | Deaths of females aged under 1. | f_1 | Integer number. | Deaths of females aged 1 and under 2. | f_2 | Integer number. | Deaths of females aged 2 and under 3. | f_3 | Integer number. | Deaths of females aged 3 and under 4. | f_4 | Integer number. | Deaths of females aged 4 and under 5. | f_2_4 | Integer number. | Deaths of females aged 2 and under 5 (1901-10 only). | f_0_4 | Integer number. | Deaths of females aged 0 to 4. | f_5_9 | Integer number. | Deaths of females aged 5 to 9. | f_10_14 | Integer number. | Deaths of females aged 10 to 14. | f_15_19 | Integer number. | Deaths of females aged 15 to 19. | f_20_24 | Integer number. | Deaths of females aged 20 to 24. | f_25_34 | Integer number. | Deaths of females aged 25 to 34. | f_35_44 | Integer number. | Deaths of females aged 35 to 44. | f_45_54 | Integer number. | Deaths of females aged 45 to 54. | f_55_64 | Integer number. | Deaths of females aged 55 to 64. | f_65_74 | Integer number. | Deaths of females aged 65 to 74. | f_75_up | Integer number. | Deaths of females aged 75 and upwards. | f_75_84 | Integer number. | Deaths of females aged 75 to 84. (1851-60 only) | f_85_up | Integer number. | Deaths of females aged 85 and upwards (1851-60 only). | notes | Text string (max.len.=304). | Comments transcribed from source. | rec_num | Integer number. | Unique number identifying row in table. |
---|