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_lon_ann_corr_pkey | Primary key | rec_num |
cause_lon_ann_corr_idx | Unique | x_district, year |
The table has the following associated constraints:
Constraint | Type | Details |
---|---|---|
cause_lon_ann_corr_pkey | Primary Key | See details above for primary key index |
Column | Type | Contents | year | Integer number. | Calendar year to which data relate. | x_district | Text string (max.len.=44). | Name of geographical unit to which data relate. | rd_name | Text string (max.len.=44). | For Sanitary Areas this is the name of the Reg. Dist. that the area lies within. For all other areas it is the same as 'x_district'. | db_name | Text string (max.len.=44). | A GIS standardised version of rd_name as entered by Graham. | segment | Text string (max.len.=14). | The GIS "segment" of London the place is in. | row_type | Text string (max.len.=8). | Type of unit; i.e. Registration Districts up to 1911 and local authority units for later dates: 'RegD'=Registration District, 'MetB'=Metropolitan Borough, 'SanD'=Sanitary District'. | status | Text string (max.len.=8). | Flags that the data have been corrected: 'CORR'=Corrected, null otherwise. | pop | Integer number. | Total Population. | total | Integer number. | Total number of deaths. (Listed for 1860-End). | enteric_2 | Integer number. | Enteric Fever (Listed for 1901-End). | smallpox | Integer number. | Smallpox (Listed for 1860-End). | measles | Integer number. | Measles (Listed for 1860-End). | scarlet_f | Integer number. | Scarlatina/Scarlet Fever (Changed name from Scarlatina to Scarlet Fever in 1869). (Listed for 1860-End). | whooping_c | Integer number. | Whooping Cough (Listed for 1860-End). | diptheria | Integer number. | Diphtheria (Listed for 1860-End). | influenza_1 | Integer number. | Influenza (Listed for 1860-1880). | influenza_2 | Integer number. | Influenza (Listed for 1901-End). | erysipb | Integer number. | Erysipelas (Listed for 1911-End). | phthisis | Integer number. | Phthisis (Originally named Phthisis and Consumption, changed to Phthisis in 1881, and To Pulmonary TB, Phthisis in 1901). (Listed for 1860-End). | tb_meningitis | Integer number. | Tuberculous Meningitis (Listed for 1901-End). | tb_other | Integer number. | Other Tb and Scrofulous Diseases (named All Other TB Diseases from 1901) (Listed for 1881-End). | cancer | Integer number. | Cancer (Named Cancer, Malignant Diseases from 1911) (Listed for 1881-End). | rheumatic_f | Integer number. | Rheumatic Fever, Rheumatism Of The Heart (Named Rheumatic Fever from 1911) (Listed for 1901-End). | mening | Integer number. | Meningitis (Listed for 1911-End). | orgheart | Integer number. | Organic Heart Disease (Listed for 1911-End). | bronchitis | Integer number. | Bronchitis (Listed for 1901-End). | pneumonia | Integer number. | Pneumonia (Named Pneumonia (All Forms) from 1911) (Listed for 1901-End). | othresp | Integer number. | Other Respiratory Diseases (Listed for 1911-End). | diarrhoea_2 | Integer number. | Diarrhoea Etc (Listed for 1911-End). | app_typh | Integer number. | Appendicitis and Typhlitis (Listed for 1911-End). | cirrh | Integer number. | Cirrhosis Of Liver (Listed for 1911-End). | alcohol | Integer number. | Alcoholism (Listed for 1911-End). | neph | Integer number. | Nephritis And Bright's Disease (Listed for 1911-End). | puerb | Integer number. | Puerperal Fever (Listed for 1911-End). | childbirth_3 | Integer number. | Parturition, Excl. Puerperal Fever (Listed for 1911-End). | condeb | Integer number. | Congenital Debility Etc. (Listed for 1911-End). | violb | Integer number. | Violence, Exc. Suicide (Listed for 1911-End). | suicide | Integer number. | Suicide (Listed for 1911-End). | otherdef | Integer number. | Other Defined Diseases (Listed for 1911-End). | illdef | Integer number. | Causes Ill-Defined Or Unknown (Listed for 1911-End). | inquests | Integer number. | Inquests (Listed for 1870-1910). | dis_nerv | Integer number. | Diseases Of Nervous System (Listed for 1881-1900). | dis_circ | Integer number. | Diseases Of Circulatory System (Listed for 1881-1900). | dis_resp | Integer number. | Diseases Of The Respiratory System (Listed for 1860-1900). | dis_digest | Integer number. | Diseases Of Digestive System (Listed for 1881-1900). | dis_urin | Integer number. | Diseases Of Urinary System (Listed for 1881-1900). | dis_gen | Integer number. | Diseases Of Generative System (Listed for 1881-1900). | puerperal_f | Integer number. | Puerperal Fever (Listed for 1881-1900). | erysipelas | Integer number. | Erysipelas (Listed for 1860-1880). | metria | Integer number. | Metria Or Puerperal Fever (Listed for 1860-1880). | dysentery | Integer number. | Dysentery (Combined with Diarrhoea from 1881) (Listed for 1860-1880). | diarrhoea_1 | Integer number. | Diarrhoea (Combined with Dysentery from 1881) (Listed for 1860-1880). | typhus_f | Integer number. | Typhus Fever (Listed for 1869-1900). | typhus_1 | Integer number. | Typhus (Split into Typhus Fever, Enteric or Typhoid Fever and Simple Continued Fever from 1869) (Listed for 1860-1868). | typhus_2 | Integer number. | Typhus (Listed for 1901-1910). | enteric_1 | Integer number. | Enteric Or Typhoid Fever (Listed for 1869-1900). | simp_cont_f | Integer number. | Simple Continued Fever (Listed for 1869-1900). | cholera | Integer number. | Cholera (Listed for 1860-1900). | childbirth_1 | Integer number. | Childbirth (Listed for 1860-1900). | pyrexia | Integer number. | Pyrexia, Of Uncertain Origin (Listed for 1901-1910). | phth_other | Integer number. | Phthisis, Not Otherwise Defined (Listed for 1901-1910). | tb_periton | Integer number. | Tuberculous Peritonitis (Listed for 1901-1910). | tabes_mes | Integer number. | Tabes Mesenterica (Listed for 1901-1910). | diar_dys | Integer number. | Diarrhoea and Dysentery (Listed for 1881-1910). | septic | Integer number. | Septic Diseases (Not Puerperal) (Listed for 1901-1910). | childbirth_2 | Integer number. | Childbirth and Puerperal Septic Diseases (Listed for 1901-1910). | violence | Integer number. | Violence (Listed for 1881-1910). | other | Integer number. | Other Causes (Listed for 1881-1910). | regd_unit | Integer number. | Registriation District g_unit value. | lgd_unit | Integer number. | Metropolitan Borough (including London County Corporate) g_unit value. | sand_unit | Integer number. | Sanitary District g_unit value. | g_unit | Integer number. | g_unit value of the smallest unit. | rec_num | Integer number. | Unique number identifying row in table. |
---|