Causes Of Death - Deaths By Country Of Residence And Occurrence

Eurostat code: hlth_cd_aro · (2011 - 2023)

@eurostat.hlth_cd_aro

Table List

2 tables(21.43 MB)

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

10.6 MB
6796859 rows
9 columns

freq Freq	unit Unit	sex Sex	age Age	icd10 Icd10	resid Resid	geo Geo	time_period Time Period	value Value
Annual	Number	Females	Total	Tuberculosis	All deaths reported in the country	Austria	2011	20
Annual	Number	Females	Total	Tuberculosis	All deaths reported in the country	Belgium	2011	22
Annual	Number	Females	Total	Tuberculosis	All deaths reported in the country	Bulgaria	2011	32
Annual	Number	Females	Total	Tuberculosis	All deaths reported in the country	Switzerland	2011	10
Annual	Number	Females	Total	Tuberculosis	All deaths reported in the country	Cyprus	2011	1
Annual	Number	Females	Total	Tuberculosis	All deaths reported in the country	Czechia	2011	19
Annual	Number	Females	Total	Tuberculosis	All deaths reported in the country	Germany	2011	154
Annual	Number	Females	Total	Tuberculosis	All deaths reported in the country	Denmark	2011	5
Annual	Number	Females	Total	Tuberculosis	All deaths reported in the country	Estonia	2011	6
Annual	Number	Females	Total	Tuberculosis	All deaths reported in the country	Greece	2011	26


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.