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 |
---|---|---|
cause_ew_reg_dec_idx1 | Unique | decade, cause, sex, reg_dist, reg_cnty, start_date |
cause_ew_reg_dec_idx2 | Unique | cause, sex, reg_dist, reg_cnty, decade, start_date |
cause_ew_reg_dec_idx3 | Unique | reg_dist, reg_cnty, decade, cause, sex, start_date |
Column | Type | Contents | rec_num | Integer number. | Sequence number added on loading, keeping rows in original order. | decade | Integer number. | Decade to which data relate; for example, '1860' means 1861-70. | reg_cnty | Text string (max.len.=24). | Name of Registration County in which the district was located. | reg_num | Integer number. | Number identifying each RD, and placing it in order. | reg_sfx | Text string (max.len.=8). | Suffix to identifying number; handles numbers such as '431A' but generally null. | reg_dist | Text string (max.len.=44). | Name of Registration District to which data relate. | cause | Text string (max.len.=44). | Generally, cause of death, but see note above. | short_cause | Text string (max.len.=10). | A highly abbreviated version of the cause, added partly to assist in linking the data to our Data Documentation System. | sex | Text string (max.len.=5). | Sex: M=male, F=female, T=total. NB the 1860s are the only decade in which the cause of death data are tabulated by sex. See note above. | total | Integer number. | Total of the following numeric columns, which is usually the total number of deaths for all ages. | males | Integer number. | Total of males in the following numeric columns, which is usually the total number of male deaths for all ages. This column is only used by the data for the 1880s and 1890s; one consequence is that for these decades the number of male births is in this column rather than a separate row. | females | Integer number. | Total of females in the following numeric columns, which is usually the total number of female deaths for all ages. This column is only used by the data for the 1880s and 1890s; one consequence is that for these decades the number of female births is in this column rather than a separate row. | a_0 | Integer number. | Deaths of persons aged under 1. | a_1 | Integer number. | Deaths of persons aged 1 and under 2. | a_2 | Integer number. | Deaths of persons aged 2 and under 3; not listed for the 1900s. | a_3 | Integer number. | Deaths of persons aged 3 and under 4; not listed for the 1900s. | a_4 | Integer number. | Deaths of persons aged 4 and under 5; not listed for the 1900s. | a_2_4 | Integer number. | Deaths of persons aged 2 and under 5; raw data for the 1900s, and computed from the component years for all other decades. | a_0_4 | Integer number. | Deaths of persons aged 0 to 4. | a_5_9 | Integer number. | Deaths of persons aged 5 to 9. | a_10_14 | Integer number. | Deaths of persons aged 10 to 14. | a_15_19 | Integer number. | Deaths of persons aged 15 to 19. | a_20_24 | Integer number. | Deaths of persons aged 20 to 24. | a_25_34 | Integer number. | Deaths of persons aged 25 to 34. | a_35_44 | Integer number. | Deaths of persons aged 35 to 44. | a_45_54 | Integer number. | Deaths of persons aged 45 to 54. | a_55_64 | Integer number. | Deaths of persons aged 55 to 64. | a_65_74 | Integer number. | Deaths of persons aged 65 to 74. | a_75_84 | Integer number. | Deaths of persons aged 75 to 84. | a_75_up | Integer number. | Deaths of persons aged 75 and upwards. This is raw data for the 1880s onwards, and computed as the sum of a_75_84 and a_85_up for earlier decades. | a_85_up | Integer number. | Deaths of persons aged 85 and upwards. | correct | Integer number. | Flag indicating rows that fail to meet check-sums: 1 if row passes all check-sums, 0 otherwise. | start_date | Database date value. | First date within the period covered by this row of data. This is generally the 1st of January in the first year of the decade but there are some complex exceptions, mainly in the 1870s. | end_date | Database date value. | Last date within the period covered by this row of data. This is generally the 31st of December in the final year of the decade but there are some complex exceptions, mainly in the 1870s. | notes | Long text. | Comments taken from original report, usually indicating the effects of boundary changes, etc. NB these appear once on each page in the original reports but are here appended to all affected rows. | nation_unit | Integer number. | ID of either England or Wales, as appropriate and derived from the county the District was in. | reg_cnty_unit | Integer number. | ID number of the Registration County, as defined in the AUO. | reg_dist_unit | Integer number. | ID number of the Registration District, as defined in the AUO. |
---|
The following entries appear in the 'cause' field in the 1860's. Most are self-explanatory but note that the first two are not 'causes' at all, the figure for 'Total Pop' being the Registrar General's estimate of the 'average' age and sex structure over the decade which is repeated in other years. The final two 'causes' are catch-all categories:
Total Pop | Cholera | Dis Stom, Liver | Total Deaths | Other Zymotic Dis | Dis Kidneys | Smallpox | Cancer | Dis Generative | Measles | Scrofula, Tabes | Dis Joints | Scarlatina | Phthisis | Dis Skin | Diphtheria | Hydrocephalus | Childbirth, Metria | Whooping Cough | Dis Brain | Suicide | Typhus | Dis Heart, Dropsy | Other Violent | Diarrhoea, Dysntry | Dis Lungs | Other Causes |