Deaths Related To Infectious Diseases

Eurostat code: hlth_cd_ido · (2011 - 2023)

@eurostat.hlth_cd_ido

Table List

2 tables(66.73 KB)

Deaths Related To Infectious Diseases - Unpivoted

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

26.25 KB
5307 rows
7 columns

freq Freq	unit Unit	sex Sex	icd10 Icd10	geo Geo	time_period Time Period	value Value
Annual	Number	Females	Other sepsis	Austria	2011	47
Annual	Number	Females	Other sepsis	Belgium	2011	593
Annual	Number	Females	Other sepsis	Bulgaria	2011	106
Annual	Number	Females	Other sepsis	Switzerland	2011	95
Annual	Number	Females	Other sepsis	Cyprus	2011	15
Annual	Number	Females	Other sepsis	Czechia	2011	390
Annual	Number	Females	Other sepsis	Germany	2011	3864
Annual	Number	Females	Other sepsis	Denmark	2011	123
Annual	Number	Females	Other sepsis	Estonia	2011	2
Annual	Number	Females	Other sepsis	Greece	2011	1965


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

Share link

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