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_lgd_ann_pkey | Primary key | rec_num |
cause_ew_lgd_ann_idx | Unique | adm_cnty, lg_dist, lg_type, sex, year |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
cause_ew_lgd_ann_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | year | Integer number. | Calendar year to which data relate. | adm_cnty | Text string (max.len.=44). | Name of Administrative County. | lg_dist | Text string (max.len.=54). | Name of Local Government District. | lg_type | Text string (max.len.=14). | Type of District: ('MB'=Municipal Borough, etc). The 1911 data include several rows with a value of 'CP', as this is how the districts were listed in the source, although these were treated as RDs when matching to the AUO. | sex | Text string (max.len.=5). | M=Male, F=Female, T=Total. Note that for London districts only totals are held, and for other districts the totals have been inserted by us based on summing M+F. | total | Integer number. | Total number of deaths. Only included for London. | entericb | Integer number. | Enteric Fever (Listed for 1911-1920). | smallpox | Integer number. | Smallpox (Listed for 1911-1920). | measles | Integer number. | Measles (Listed for 1911-1920). | sca | Integer number. | Scarlatina/Scarlet Fever (Changed name from Scarlatina to Scarlet Fever in 1869). (Listed for 1911-1920). | whoo | Integer number. | Whooping Cough (Listed for 1911-1920). | dip | Integer number. | Diphtheria (Listed for 1911-1920). | influb | Integer number. | Influenza (Listed for 1911-1920). | erysipb | Integer number. | Erysipelas (Listed for 1911-End). | phth | Integer number. | Phthisis (Originally named Phthisis and Consumption, changed to Phthisis in 1881, and To Pulmonary TB, Phthisis in 1901). (Listed for 1911-1920). | tubmen | Integer number. | Tuberculous Meningitis (Listed for 1911-1920). | othertb | Integer number. | Other Tb and Scrofulous Diseases (named All Other TB Diseases from 1901) (Listed for 1911-1920). | cancer | Integer number. | Cancer (Named Cancer) (Listed for 1911-1920). | rheum | Integer number. | Rheumatic Fever, Rheumatism Of The Heart (Listed for 1911-1920). | mening | Integer number. | Meningitis (Listed for 1911-1920). | orgheart | Integer number. | Organic Heart Disease (Listed for 1911-1920). | bron | Integer number. | Bronchitis (Listed for 1911-1920). | pneum | Integer number. | Pneumonia (Listed for 1911-1920). | othresp | Integer number. | Other Respiratory Diseases (Listed for 1911-1920). | diarb | Integer number. | Diarrhoea Etc. (Listed for 1911-1920). | app_typh | Integer number. | Appendicitis and Typhlitis (Listed for 1911-1920). | cirrh | Integer number. | Cirrhosis Of Liver (Listed for 1911-1920). | alcohol | Integer number. | Alcoholism (Listed for 1911-1920). | neph | Integer number. | Nephritis And Bright's Disease (Listed for 1911-1920). | puerb | Integer number. | Puerperal Fever (Listed for 1911-1920). | birthc | Integer number. | Parturition, Excl. Puerperal Fever (Listed for 1911-1920). | condeb | Integer number. | Congenital Debility Etc.(Listed for 1911-1920). | violb | Integer number. | Violence, Exc. Suicide (Listed for 1911-1920). | suicide | Integer number. | Suicide (Listed for 1911-1920). | otherdef | Integer number. | Other Defined Diseases (Listed for 1911-1920). | illdef | Integer number. | Causes Ill-Defined Or Unknown (Listed for 1911-1920). | notes | Text string (max.len.=254). | Notes either taken from the original table or added during digitisation. | adm_cnty_unit | Integer number. | Unique identifier for the Administrative County, as defined in the GBH GIS Administrative Unit Ontology. | lg_dist_unit | Integer number. | Unique identifier for the Local Government District, as defined in the GBH GIS Administrative Unit Ontology. | rec_num | Integer number. | Unique number identifying row in table. |
---|