Baselight

Assumptions For Mortality Rates By Age, Sex And Type Of Projection

Eurostat code: proj_23naasmr ยท (2022 - 2100)

@eurostat.proj_23naasmr

Assumptions For Mortality Rates By Age, Sex And Type Of Projection - Unpivoted
@eurostat.proj_23naasmr.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.55 MB
  • 957480 rows
  • 8 columns
freq

Freq

projection

Projection

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualBaseline projectionsFemales1 yearNumberAustria20220.0003
AnnualBaseline projectionsFemales1 yearNumberBelgium20220.00047
AnnualBaseline projectionsFemales1 yearNumberBulgaria20220.00107
AnnualBaseline projectionsFemales1 yearNumberSwitzerland20220.00031
AnnualBaseline projectionsFemales1 yearNumberCyprus20220.00044
AnnualBaseline projectionsFemales1 yearNumberCzechia20220.00039
AnnualBaseline projectionsFemales1 yearNumberGermany20220.00041
AnnualBaseline projectionsFemales1 yearNumberDenmark20220.00036
AnnualBaseline projectionsFemales1 yearNumberEstonia20220.00024
AnnualBaseline projectionsFemales1 yearNumberGreece20220.00059

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

Share link

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