Baselight

Deaths By Week, Sex, 20-year Age Group And NUTS 3 Region

Eurostat code: demo_r_mwk3_20 · (2000-W01 - 2025-W42)

@eurostat.demo_r_mwk3_20

Loading...
Loading...

About this Dataset

Deaths By Week, Sex, 20-year Age Group And NUTS 3 Region

This Eurostat dataset contains data on deaths by week, sex, 20-year age group and nuts 3 region, 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-10-31T23:00:00+0100

Tables

Deaths By Week, Sex, 20-year Age Group And NUTS 3 Region - Raw

@eurostat.demo_r_mwk3_20.raw
  • 35.13 MB
  • 31,374 rows
  • 1,351 columns
Loading...
CREATE TABLE raw (
  "freq" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2000_w01" DOUBLE  -- 2000-W01,
  "n_2000_w02" DOUBLE  -- 2000-W02,
  "n_2000_w03" DOUBLE  -- 2000-W03,
  "n_2000_w04" DOUBLE  -- 2000-W04,
  "n_2000_w05" DOUBLE  -- 2000-W05,
  "n_2000_w06" DOUBLE  -- 2000-W06,
  "n_2000_w07" DOUBLE  -- 2000-W07,
  "n_2000_w08" DOUBLE  -- 2000-W08,
  "n_2000_w09" DOUBLE  -- 2000-W09,
  "n_2000_w10" DOUBLE  -- 2000-W10,
  "n_2000_w11" DOUBLE  -- 2000-W11,
  "n_2000_w12" DOUBLE  -- 2000-W12,
  "n_2000_w13" DOUBLE  -- 2000-W13,
  "n_2000_w14" DOUBLE  -- 2000-W14,
  "n_2000_w15" DOUBLE  -- 2000-W15,
  "n_2000_w16" DOUBLE  -- 2000-W16,
  "n_2000_w17" DOUBLE  -- 2000-W17,
  "n_2000_w18" DOUBLE  -- 2000-W18,
  "n_2000_w19" DOUBLE  -- 2000-W19,
  "n_2000_w20" DOUBLE  -- 2000-W20,
  "n_2000_w21" DOUBLE  -- 2000-W21,
  "n_2000_w22" DOUBLE  -- 2000-W22,
  "n_2000_w23" DOUBLE  -- 2000-W23,
  "n_2000_w24" DOUBLE  -- 2000-W24,
  "n_2000_w25" DOUBLE  -- 2000-W25,
  "n_2000_w26" DOUBLE  -- 2000-W26,
  "n_2000_w27" DOUBLE  -- 2000-W27,
  "n_2000_w28" DOUBLE  -- 2000-W28,
  "n_2000_w29" DOUBLE  -- 2000-W29,
  "n_2000_w30" DOUBLE  -- 2000-W30,
  "n_2000_w31" DOUBLE  -- 2000-W31,
  "n_2000_w32" DOUBLE  -- 2000-W32,
  "n_2000_w33" DOUBLE  -- 2000-W33,
  "n_2000_w34" DOUBLE  -- 2000-W34,
  "n_2000_w35" DOUBLE  -- 2000-W35,
  "n_2000_w36" DOUBLE  -- 2000-W36,
  "n_2000_w37" DOUBLE  -- 2000-W37,
  "n_2000_w38" DOUBLE  -- 2000-W38,
  "n_2000_w39" DOUBLE  -- 2000-W39,
  "n_2000_w40" DOUBLE  -- 2000-W40,
  "n_2000_w41" DOUBLE  -- 2000-W41,
  "n_2000_w42" DOUBLE  -- 2000-W42,
  "n_2000_w43" DOUBLE  -- 2000-W43,
  "n_2000_w44" DOUBLE  -- 2000-W44,
  "n_2000_w45" DOUBLE  -- 2000-W45,
  "n_2000_w46" DOUBLE  -- 2000-W46,
  "n_2000_w47" DOUBLE  -- 2000-W47,
  "n_2000_w48" DOUBLE  -- 2000-W48,
  "n_2000_w49" DOUBLE  -- 2000-W49,
  "n_2000_w50" DOUBLE  -- 2000-W50,
  "n_2000_w51" DOUBLE  -- 2000-W51,
  "n_2000_w52" DOUBLE  -- 2000-W52,
  "n_2001_w01" DOUBLE  -- 2001-W01,
  "n_2001_w02" DOUBLE  -- 2001-W02,
  "n_2001_w03" DOUBLE  -- 2001-W03,
  "n_2001_w04" DOUBLE  -- 2001-W04,
  "n_2001_w05" DOUBLE  -- 2001-W05,
  "n_2001_w06" DOUBLE  -- 2001-W06,
  "n_2001_w07" DOUBLE  -- 2001-W07,
  "n_2001_w08" DOUBLE  -- 2001-W08,
  "n_2001_w09" DOUBLE  -- 2001-W09,
  "n_2001_w10" DOUBLE  -- 2001-W10,
  "n_2001_w11" DOUBLE  -- 2001-W11,
  "n_2001_w12" DOUBLE  -- 2001-W12,
  "n_2001_w13" DOUBLE  -- 2001-W13,
  "n_2001_w14" DOUBLE  -- 2001-W14,
  "n_2001_w15" DOUBLE  -- 2001-W15,
  "n_2001_w16" DOUBLE  -- 2001-W16,
  "n_2001_w17" DOUBLE  -- 2001-W17,
  "n_2001_w18" DOUBLE  -- 2001-W18,
  "n_2001_w19" DOUBLE  -- 2001-W19,
  "n_2001_w20" DOUBLE  -- 2001-W20,
  "n_2001_w21" DOUBLE  -- 2001-W21,
  "n_2001_w22" DOUBLE  -- 2001-W22,
  "n_2001_w23" DOUBLE  -- 2001-W23,
  "n_2001_w24" DOUBLE  -- 2001-W24,
  "n_2001_w25" DOUBLE  -- 2001-W25,
  "n_2001_w26" DOUBLE  -- 2001-W26,
  "n_2001_w27" DOUBLE  -- 2001-W27,
  "n_2001_w28" DOUBLE  -- 2001-W28,
  "n_2001_w29" DOUBLE  -- 2001-W29,
  "n_2001_w30" DOUBLE  -- 2001-W30,
  "n_2001_w31" DOUBLE  -- 2001-W31,
  "n_2001_w32" DOUBLE  -- 2001-W32,
  "n_2001_w33" DOUBLE  -- 2001-W33,
  "n_2001_w34" DOUBLE  -- 2001-W34,
  "n_2001_w35" DOUBLE  -- 2001-W35,
  "n_2001_w36" DOUBLE  -- 2001-W36,
  "n_2001_w37" DOUBLE  -- 2001-W37,
  "n_2001_w38" DOUBLE  -- 2001-W38,
  "n_2001_w39" DOUBLE  -- 2001-W39,
  "n_2001_w40" DOUBLE  -- 2001-W40,
  "n_2001_w41" DOUBLE  -- 2001-W41,
  "n_2001_w42" DOUBLE  -- 2001-W42,
  "n_2001_w43" DOUBLE  -- 2001-W43
);

Deaths By Week, Sex, 20-year Age Group And NUTS 3 Region - Unpivoted

@eurostat.demo_r_mwk3_20.tidy
  • 49.55 MB
  • 26,892,707 rows
  • 7 columns
Loading...
CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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