GB Historical DB

CORRECTED annual cause-of-death data for London districts 1860-1920

Table ID:
CAUSE_LON_ANN_CORR     (1246810)
Contents:
CORRECTED annual cause-of-death data for London districts 1860-1920
Approx. number of rows:
2,039
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Geography:
Reporting units are identified by:
   Unspecified District
Chronology:
The data cover the period 1860 to 1920.
Dates and times are identified by:
   Year

Sources:

  1. These data were transcribed from the Annual Reports of the Registrar General, and then corrected for deaths in institutions by Graham Mooney. The data cover all Registration Districts in the County of London from 1860 to 1884, all Sanitary Districts from 1885 to 1900, and all London Boroughs from 1901 to 1920. [MORE DETAIL NEEDED]

Notes:

  1. This table is limited to London, and is based on Graham Mooney's work to re-allocate deaths in hospitals to the areas of prior residence; without this re-allocation, death rates for districts containing hospitals are inflated. Graham describes this work as being based on "a variety of methodologies".
  2. Up to 1910, the disease categories are the same as those appearing in 'cause_ew_reg_ann', only the header data being different. Further work is needed on the naming of those causes of death which are reported only from 1911.
  3. This table holds data for three different types of unit, depending on period, and this is recorded by the values in the row_type column:
    • 1860-84: Registration Districts ('RegD').
    • 1885-1900: Sanitary Districts ('SanD').
    • 1901-11: Metropolitan Boroughs ('MetB').

Checking:

  1. It is unknown what checks were originally run on the data; check with Graham Mooney.
  2. These files have been altered to run on Postgres, but otherwise are exactly the same as they were on the oracle server except for the following issue. The data was not loading because the .dat file had a problem at line 1761. This issue looks like it is related to the dates and affected all rows from 1911 Hackney onwards. All 1911 and later rows were transferred to a separate .dat file "cause_lon_ann_corr_1910s". Reviewing earlier incarnations of this table confirmed no data had been lost.
  3. Matching to the AUO gazetteer has been attempted. The g_unit column gives the final g_unit value for the smallest named unit. The units between 1895 and 1900 are given as sanitary districts in the data and have been matched as such. Most Sanitary Districts were created in 1872 and abolished in 1895 but London was different as it already had the Metropolitan Board of Works established in 1855. The Registration Districts assigned to rows in the data here do not necessarily match those in the AUO, so the matching for the Sanitary District rows has been left as directly to Sanitary Districts and not Registration Districts for now. Only Stepney 1885-1900 and Stoke Newington 1894-1900 have no g_unit value because neither is identified as a Sanitary District in Youngs' and therefore the AUO.

Acknowledgments:


We are extremely grateful to the following:

  1. Graham Mooney: These data were supplied to the database by Graham Mooney. No limits have been placed on access.

Indices:

IndexTypeColumn(s) indexed
cause_lon_ann_corr_pkey Primary key rec_num
cause_lon_ann_corr_idx Unique x_district, year

Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
cause_lon_ann_corr_pkey Primary Key See details above for primary key index


Columns within table:

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