Causes Of Death - Death By Country Of Residence And Occurrence, Monthly Data

Eurostat code: hlth_cd_mro · (2019-01 - 2022-12)

@eurostat.hlth_cd_mro

Table List

2 tables(5.93 MB)

Causes Of Death - Death By Country Of Residence And Occurrence, Monthly Data - Raw

Causes Of Death - Death By Country Of Residence And Occurrence, Monthly Data - Unpivoted

Causes Of Death - Death By Country Of Residence And Occurrence, Monthly Data - Unpivoted

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

2.93 MB
1758540 rows
9 columns

freq Freq	unit Unit	sex Sex	age Age	icd10 Icd10	resid Resid	geo Geo	time_period Time Period	value Value
Monthly	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	All deaths reported in the country	Austria	2019-01	3942
Monthly	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	All deaths reported in the country	Belgium	2019-01	5331
Monthly	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	All deaths reported in the country	Bulgaria	2019-01	5704
Monthly	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	All deaths reported in the country	Cyprus	2019-01	332
Monthly	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	All deaths reported in the country	Czechia	2019-01	5215
Monthly	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	All deaths reported in the country	Denmark	2019-01	2464
Monthly	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	All deaths reported in the country	Estonia	2019-01	789
Monthly	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	All deaths reported in the country	Greece	2019-01	6575
Monthly	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	All deaths reported in the country	Spain	2019-01	22338
Monthly	Number	Females	Total	All causes of death (A00-Y89) excluding S00-T98	All deaths reported in the country	Finland	2019-01	2558


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.