Treatable And Preventable Mortality Of Residents By Cause And Sex

Eurostat code: hlth_cd_apr$dv_2102

@eurostat.hlth_cd_apr_dv_2102

Table List

2 tables(97.21 KB)

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

45.93 KB
6318 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	Total	Number	Austria	2013	3730
Annual	Preventable mortality	Females	Total	Number	Belgium	2013	4832.5
Annual	Preventable mortality	Females	Total	Number	Bulgaria	2013	4496
Annual	Preventable mortality	Females	Total	Number	Switzerland	2013	2632
Annual	Preventable mortality	Females	Total	Number	Cyprus	2013	160
Annual	Preventable mortality	Females	Total	Number	Czechia	2013	6135
Annual	Preventable mortality	Females	Total	Number	Germany	2013	38266
Annual	Preventable mortality	Females	Total	Number	Denmark	2013	3156
Annual	Preventable mortality	Females	Total	Number	Estonia	2013	894.5
Annual	Preventable mortality	Females	Total	Number	Greece	2013	3373.5


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.