Demographic Balances And Indicators By Type Of Projection And NUTS 3 Region

Eurostat code: proj_19rdbi3 · (2019 - 2100)

@eurostat.proj_19rdbi3

Table List

2 tables(27.95 MB)

Demographic Balances And Indicators By Type Of Projection And NUTS 3 Region - Raw

Demographic Balances And Indicators By Type Of Projection And NUTS 3 Region - Unpivoted

Demographic Balances And Indicators By Type Of Projection And NUTS 3 Region - Unpivoted

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

14.61 MB
5783296 rows
6 columns

freq Freq	projection Projection	indic_de Indic De	geo Geo	time_period Time Period	value Value
Annual	Baseline projections	Deaths - total	Mittelburgenland	2019	489
Annual	Baseline projections	Deaths - total	Nordburgenland	2019	1626
Annual	Baseline projections	Deaths - total	Südburgenland	2019	1184
Annual	Baseline projections	Deaths - total	Mostviertel-Eisenwurzen	2019	2431
Annual	Baseline projections	Deaths - total	Niederösterreich-Süd	2019	2807
Annual	Baseline projections	Deaths - total	Sankt Pölten	2019	1554
Annual	Baseline projections	Deaths - total	Waldviertel	2019	2454
Annual	Baseline projections	Deaths - total	Weinviertel	2019	1577
Annual	Baseline projections	Deaths - total	Wiener Umland/Nordteil	2019	3233
Annual	Baseline projections	Deaths - total	Wiener Umland/Südteil	2019	3446


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.