Causes Of Death - Deaths By NUTS 2 Region Of Residence And Occurrence, 3 Year Average

Eurostat code: hlth_cd_yro · (2013 - 2022)

@eurostat.hlth_cd_yro

Table List

2 tables(232.52 MB)

Causes Of Death - Deaths By NUTS 2 Region Of Residence And Occurrence, 3 Year Average - Raw

Causes Of Death - Deaths By NUTS 2 Region Of Residence And Occurrence, 3 Year Average - Unpivoted

Causes Of Death - Deaths By NUTS 2 Region Of Residence And Occurrence, 3 Year Average - Unpivoted

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

131.47 MB
110518845 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	All causes of death (A00-Y89) excluding S00-T98	Deaths of non-residents in the reporting country	Austria	2013	241
Annual	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	Deaths of non-residents in the reporting country	Ostösterreich	2013	58
Annual	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	Deaths of non-residents in the reporting country	Burgenland	2013	4
Annual	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	Deaths of non-residents in the reporting country	Niederösterreich	2013	18
Annual	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	Deaths of non-residents in the reporting country	Wien	2013	37
Annual	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	Deaths of non-residents in the reporting country	Südösterreich	2013	32
Annual	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	Deaths of non-residents in the reporting country	Kärnten	2013	22
Annual	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	Deaths of non-residents in the reporting country	Steiermark	2013	10
Annual	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	Deaths of non-residents in the reporting country	Westösterreich	2013	151
Annual	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	Deaths of non-residents in the reporting country	Oberösterreich	2013	23


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.