Demographic Balances And Indicators By Type Of Projection

Eurostat code: proj_19ndbi · (2019 - 2100)

@eurostat.proj_19ndbi

Table List

2 tables(1.96 MB)

Demographic Balances And Indicators By Type Of Projection - Raw

Demographic Balances And Indicators By Type Of Projection - Unpivoted

Demographic Balances And Indicators By Type Of Projection - Unpivoted

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

932.76 KB
318488 rows
6 columns

freq Freq	projection Projection	indic_de Indic De	geo Geo	time_period Time Period	value Value
Annual	Baseline projections	Deaths - total	Austria	2019	83431
Annual	Baseline projections	Deaths - total	Belgium	2019	108745
Annual	Baseline projections	Deaths - total	Bulgaria	2019	108083
Annual	Baseline projections	Deaths - total	Switzerland	2019	67745
Annual	Baseline projections	Deaths - total	Cyprus	2019	6000
Annual	Baseline projections	Deaths - total	Czechia	2019	112362
Annual	Baseline projections	Deaths - total	Germany	2019	939536
Annual	Baseline projections	Deaths - total	Denmark	2019	53958
Annual	Baseline projections	Deaths - total	Euro area - 19 countries (2015-2022)	2019	3438529
Annual	Baseline projections	Deaths - total	Euro area – 20 countries (from 2023)	2019	3490856


CREATE TABLE tidy (
  "freq" VARCHAR,
  "projection" VARCHAR,
  "indic_de" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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