Baselight

Deaths From Respiratory Disease

Lincolnshire County Council

@ukgov.deaths_from_respiratory_disease

Loading...
Loading...

About this Dataset

Deaths From Respiratory Disease

This data shows premature deaths (Age under 75) from Respiratory Disease, numbers and rates by gender, as 3-year range. Smoking is the major cause of chronic obstructive pulmonary disease (COPD), one of the major Respiratory diseases. COPD (which includes chronic bronchitis and emphysema) results in many hospital admissions. Respiratory diseases can also be caused by environmental factors (such as pollution, or housing conditions) and influenza. Respiratory disease mortality rates show a socio-economic gradient. Directly Age-Standardised Rates (DASR) are shown in the data, where numbers are sufficient, so that death rates can be directly compared between areas. The DASR calculation applies Age-specific rates to a Standard (European) population to cancel out possible effects on crude rates due to different age structures among populations, thus enabling direct comparisons of rates. A limitation on using mortalities as a proxy for prevalence of health conditions is that mortalities may give an incomplete view of health conditions in an area, as ill-health might not lead to premature death. Data source: Office for Health Improvement and Disparities (OHID) Public Health Outcomes Framework (PHOF) indicator 4.07i. This data is updated annually.
Publisher name: Lincolnshire County Council
Last updated: 2025-03-13T04:00:03Z

Tables

Deaths From Respiratory Disease

@ukgov.deaths_from_respiratory_disease.deaths_from_respiratory_disease
  • 16.88 KB
  • 96 rows
  • 17 columns
Loading...

CREATE TABLE deaths_from_respiratory_disease (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" VARCHAR,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "latestdata" VARCHAR,
  "period" VARCHAR,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "persons_number_deathsunder75" DOUBLE,
  "persons_dasr_deathsunder75" DOUBLE,
  "females_number_deathsunder75" DOUBLE,
  "females_dasr_deathsunder75" DOUBLE,
  "males_number_deathsunder75" DOUBLE,
  "males_dasr_deathsunder75" DOUBLE
);

Table 2

@ukgov.deaths_from_respiratory_disease.table_2
  • 11.37 KB
  • 17 rows
  • 12 columns
Loading...

CREATE TABLE table_2 (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR,
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);

Share link

Anyone who has the link will be able to view this.