Causes Of Death - Deaths By Country Of Residence And Occurrence

Eurostat code: hlth_cd_aro$dv_2641

@eurostat.hlth_cd_aro_dv_2641

Table List

2 tables(31.51 KB)

Causes Of Death - Deaths By Country Of Residence And Occurrence - Raw

Causes Of Death - Deaths By Country Of Residence And Occurrence - Unpivoted

Causes Of Death - Deaths By Country Of Residence And Occurrence - Unpivoted

@eurostat.hlth_cd_aro_dv_2641.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.18 KB
8328 rows
9 columns

freq Freq	unit Unit	sex Sex	age Age	icd10 Icd10	resid Resid	geo Geo	time_period Time Period
Annual	Number	Females	From 1 to 4 years	Intentional self-harm	All deaths reported in the country	Austria	2014
Annual	Number	Females	From 1 to 4 years	Intentional self-harm	All deaths reported in the country	Belgium	2014
Annual	Number	Females	From 1 to 4 years	Intentional self-harm	All deaths reported in the country	Bulgaria	2014
Annual	Number	Females	From 1 to 4 years	Intentional self-harm	All deaths reported in the country	Switzerland	2014
Annual	Number	Females	From 1 to 4 years	Intentional self-harm	All deaths reported in the country	Czechia	2014
Annual	Number	Females	From 1 to 4 years	Intentional self-harm	All deaths reported in the country	Germany	2014
Annual	Number	Females	From 1 to 4 years	Intentional self-harm	All deaths reported in the country	Denmark	2014
Annual	Number	Females	From 1 to 4 years	Intentional self-harm	All deaths reported in the country	Greece	2014
Annual	Number	Females	From 1 to 4 years	Intentional self-harm	All deaths reported in the country	Spain	2014
Annual	Number	Females	From 1 to 4 years	Intentional self-harm	All deaths reported in the country	European Union - 27 countries (from 2020)	2014


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

Share link

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