Name: Causes Of Death - Death By Country Of Residence And Occurrence, Monthly Data
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

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

This Eurostat dataset contains data on causes of death - death by country of residence and occurrence, monthly data, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-03-21T11:00:00+0100

Tables

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

@eurostat.hlth_cd_mro.raw

3.15 MB
44,856 rows
55 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "icd10" VARCHAR,
  "resid" VARCHAR,
  "geo" VARCHAR,
  "n_2019_01" DOUBLE  -- 2019-01,
  "n_2019_02" DOUBLE  -- 2019-02,
  "n_2019_03" DOUBLE  -- 2019-03,
  "n_2019_04" DOUBLE  -- 2019-04,
  "n_2019_05" DOUBLE  -- 2019-05,
  "n_2019_06" DOUBLE  -- 2019-06,
  "n_2019_07" DOUBLE  -- 2019-07,
  "n_2019_08" DOUBLE  -- 2019-08,
  "n_2019_09" DOUBLE  -- 2019-09,
  "n_2019_10" DOUBLE  -- 2019-10,
  "n_2019_11" DOUBLE  -- 2019-11,
  "n_2019_12" DOUBLE  -- 2019-12,
  "n_2020_01" DOUBLE  -- 2020-01,
  "n_2020_02" DOUBLE  -- 2020-02,
  "n_2020_03" DOUBLE  -- 2020-03,
  "n_2020_04" DOUBLE  -- 2020-04,
  "n_2020_05" DOUBLE  -- 2020-05,
  "n_2020_06" DOUBLE  -- 2020-06,
  "n_2020_07" DOUBLE  -- 2020-07,
  "n_2020_08" DOUBLE  -- 2020-08,
  "n_2020_09" DOUBLE  -- 2020-09,
  "n_2020_10" DOUBLE  -- 2020-10,
  "n_2020_11" DOUBLE  -- 2020-11,
  "n_2020_12" DOUBLE  -- 2020-12,
  "n_2021_01" DOUBLE  -- 2021-01,
  "n_2021_02" DOUBLE  -- 2021-02,
  "n_2021_03" DOUBLE  -- 2021-03,
  "n_2021_04" DOUBLE  -- 2021-04,
  "n_2021_05" DOUBLE  -- 2021-05,
  "n_2021_06" DOUBLE  -- 2021-06,
  "n_2021_07" DOUBLE  -- 2021-07,
  "n_2021_08" DOUBLE  -- 2021-08,
  "n_2021_09" DOUBLE  -- 2021-09,
  "n_2021_10" DOUBLE  -- 2021-10,
  "n_2021_11" DOUBLE  -- 2021-11,
  "n_2021_12" DOUBLE  -- 2021-12,
  "n_2022_01" DOUBLE  -- 2022-01,
  "n_2022_02" DOUBLE  -- 2022-02,
  "n_2022_03" DOUBLE  -- 2022-03,
  "n_2022_04" DOUBLE  -- 2022-04,
  "n_2022_05" DOUBLE  -- 2022-05,
  "n_2022_06" DOUBLE  -- 2022-06,
  "n_2022_07" DOUBLE  -- 2022-07,
  "n_2022_08" DOUBLE  -- 2022-08,
  "n_2022_09" DOUBLE  -- 2022-09,
  "n_2022_10" DOUBLE  -- 2022-10,
  "n_2022_11" DOUBLE  -- 2022-11,
  "n_2022_12" DOUBLE  -- 2022-12
);

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

@eurostat.hlth_cd_mro.tidy

3.07 MB
1,758,540 rows
9 columns

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