Treatable And Preventable Mortality Of Residents By Cause And Sex

Eurostat code: hlth_cd_apr · (2011 - 2022)

@eurostat.hlth_cd_apr

Table List

2 tables(1.54 MB)

Treatable And Preventable Mortality Of Residents By Cause And Sex - Raw

Treatable And Preventable Mortality Of Residents By Cause And Sex - Unpivoted

Treatable And Preventable Mortality Of Residents By Cause And Sex - Unpivoted

@eurostat.hlth_cd_apr.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.

864.38 KB
515574 rows
8 columns

freq Freq	mortalit Mortalit	sex Sex	icd10 Icd10	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Preventable mortality	Females	Intestinal infectious diseases	Number	Austria	2011	7
Annual	Preventable mortality	Females	Intestinal infectious diseases	Number	Belgium	2011	25
Annual	Preventable mortality	Females	Intestinal infectious diseases	Number	Bulgaria	2011	5
Annual	Preventable mortality	Females	Intestinal infectious diseases	Number	Switzerland	2011	14
Annual	Preventable mortality	Females	Intestinal infectious diseases	Number	Cyprus	2011	6
Annual	Preventable mortality	Females	Intestinal infectious diseases	Number	Czechia	2011	43
Annual	Preventable mortality	Females	Intestinal infectious diseases	Number	Germany	2011	353
Annual	Preventable mortality	Females	Intestinal infectious diseases	Number	Denmark	2011	23
Annual	Preventable mortality	Females	Intestinal infectious diseases	Number	Estonia	2011	1
Annual	Preventable mortality	Females	Intestinal infectious diseases	Number	Greece	2011


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.