Baselight

Deaths By Week, Sex And NUTS 3 Region

Eurostat code: demo_r_mwk3_ts ยท (2000-W01 - 2025-W19)

@eurostat.demo_r_mwk3_ts

Loading...
Loading...

About this Dataset

Deaths By Week, Sex And NUTS 3 Region

This Eurostat dataset contains data on deaths by week, sex 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-06-05T11:00:00+0200

Tables

Deaths By Week, Sex And NUTS 3 Region - Raw

@eurostat.demo_r_mwk3_ts.raw
  • 8.29 MB
  • 4477 rows
  • 1327 columns
Loading...

CREATE TABLE raw (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2000_w01" DOUBLE,
  "n_2000_w02" DOUBLE,
  "n_2000_w03" DOUBLE,
  "n_2000_w04" DOUBLE,
  "n_2000_w05" DOUBLE,
  "n_2000_w06" DOUBLE,
  "n_2000_w07" DOUBLE,
  "n_2000_w08" DOUBLE,
  "n_2000_w09" DOUBLE,
  "n_2000_w10" DOUBLE,
  "n_2000_w11" DOUBLE,
  "n_2000_w12" DOUBLE,
  "n_2000_w13" DOUBLE,
  "n_2000_w14" DOUBLE,
  "n_2000_w15" DOUBLE,
  "n_2000_w16" DOUBLE,
  "n_2000_w17" DOUBLE,
  "n_2000_w18" DOUBLE,
  "n_2000_w19" DOUBLE,
  "n_2000_w20" DOUBLE,
  "n_2000_w21" DOUBLE,
  "n_2000_w22" DOUBLE,
  "n_2000_w23" DOUBLE,
  "n_2000_w24" DOUBLE,
  "n_2000_w25" DOUBLE,
  "n_2000_w26" DOUBLE,
  "n_2000_w27" DOUBLE,
  "n_2000_w28" DOUBLE,
  "n_2000_w29" DOUBLE,
  "n_2000_w30" DOUBLE,
  "n_2000_w31" DOUBLE,
  "n_2000_w32" DOUBLE,
  "n_2000_w33" DOUBLE,
  "n_2000_w34" DOUBLE,
  "n_2000_w35" DOUBLE,
  "n_2000_w36" DOUBLE,
  "n_2000_w37" DOUBLE,
  "n_2000_w38" DOUBLE,
  "n_2000_w39" DOUBLE,
  "n_2000_w40" DOUBLE,
  "n_2000_w41" DOUBLE,
  "n_2000_w42" DOUBLE,
  "n_2000_w43" DOUBLE,
  "n_2000_w44" DOUBLE,
  "n_2000_w45" DOUBLE,
  "n_2000_w46" DOUBLE,
  "n_2000_w47" DOUBLE,
  "n_2000_w48" DOUBLE,
  "n_2000_w49" DOUBLE,
  "n_2000_w50" DOUBLE,
  "n_2000_w51" DOUBLE,
  "n_2000_w52" DOUBLE,
  "n_2001_w01" DOUBLE,
  "n_2001_w02" DOUBLE,
  "n_2001_w03" DOUBLE,
  "n_2001_w04" DOUBLE,
  "n_2001_w05" DOUBLE,
  "n_2001_w06" DOUBLE,
  "n_2001_w07" DOUBLE,
  "n_2001_w08" DOUBLE,
  "n_2001_w09" DOUBLE,
  "n_2001_w10" DOUBLE,
  "n_2001_w11" DOUBLE,
  "n_2001_w12" DOUBLE,
  "n_2001_w13" DOUBLE,
  "n_2001_w14" DOUBLE,
  "n_2001_w15" DOUBLE,
  "n_2001_w16" DOUBLE,
  "n_2001_w17" DOUBLE,
  "n_2001_w18" DOUBLE,
  "n_2001_w19" DOUBLE,
  "n_2001_w20" DOUBLE,
  "n_2001_w21" DOUBLE,
  "n_2001_w22" DOUBLE,
  "n_2001_w23" DOUBLE,
  "n_2001_w24" DOUBLE,
  "n_2001_w25" DOUBLE,
  "n_2001_w26" DOUBLE,
  "n_2001_w27" DOUBLE,
  "n_2001_w28" DOUBLE,
  "n_2001_w29" DOUBLE,
  "n_2001_w30" DOUBLE,
  "n_2001_w31" DOUBLE,
  "n_2001_w32" DOUBLE,
  "n_2001_w33" DOUBLE,
  "n_2001_w34" DOUBLE,
  "n_2001_w35" DOUBLE,
  "n_2001_w36" DOUBLE,
  "n_2001_w37" DOUBLE,
  "n_2001_w38" DOUBLE,
  "n_2001_w39" DOUBLE,
  "n_2001_w40" DOUBLE,
  "n_2001_w41" DOUBLE,
  "n_2001_w42" DOUBLE,
  "n_2001_w43" DOUBLE,
  "n_2001_w44" DOUBLE
);

Deaths By Week, Sex And NUTS 3 Region - Unpivoted

@eurostat.demo_r_mwk3_ts.tidy
  • 7.68 MB
  • 3817714 rows
  • 6 columns
Loading...

CREATE TABLE tidy (
  "freq" 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.