Standardised Preventable And Treatable Mortality

Eurostat code: sdg_03_42 · (2011 - 2022)

@eurostat.sdg_03_42

Table List

2 tables(34.43 KB)

Standardised Preventable And Treatable Mortality - Raw

Standardised Preventable And Treatable Mortality - Unpivoted

Standardised Preventable And Treatable Mortality - Unpivoted

@eurostat.sdg_03_42.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

13.86 KB
1269 rows
8 columns

freq Freq	mortalit Mortalit	sex Sex	icd10 Icd10	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Preventable mortality	Total	Total	Rate	Austria	2011	168.77
Annual	Preventable mortality	Total	Total	Rate	Belgium	2011	172.38
Annual	Preventable mortality	Total	Total	Rate	Bulgaria	2011	222.86
Annual	Preventable mortality	Total	Total	Rate	Switzerland	2011	123.41
Annual	Preventable mortality	Total	Total	Rate	Cyprus	2011	108.76
Annual	Preventable mortality	Total	Total	Rate	Czechia	2011	225.72
Annual	Preventable mortality	Total	Total	Rate	Germany	2011	163.45
Annual	Preventable mortality	Total	Total	Rate	Denmark	2011	183.37
Annual	Preventable mortality	Total	Total	Rate	Estonia	2011	301.67
Annual	Preventable mortality	Total	Total	Rate	Greece	2011	148.68


CREATE TABLE tidy (
  "freq" VARCHAR,
  "mortalit" VARCHAR,
  "sex" VARCHAR,
  "icd10" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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