Demographic Balances And Indicators By Type Of Projection And Metropolitan Region

Eurostat code: met_proj_19rdbi · (2019 - 2100)

@eurostat.met_proj_19rdbi

Table List

2 tables(1.4 MB)

Demographic Balances And Indicators By Type Of Projection And Metropolitan Region - Raw

Demographic Balances And Indicators By Type Of Projection And Metropolitan Region - Unpivoted

Demographic Balances And Indicators By Type Of Projection And Metropolitan Region - Unpivoted

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

596.99 KB
135300 rows
7 columns

freq Freq	projection Projection	indic_de Indic De	unit Unit	metroreg Metroreg	time_period Time Period	value Value
Annual	Baseline projections	Deaths - total	Number	Wien	2019	26484
Annual	Baseline projections	Deaths - total	Number	Graz	2019	5762
Annual	Baseline projections	Deaths - total	Number	Linz	2019	7116
Annual	Baseline projections	Deaths - total	Number	Salzburg	2019	3029
Annual	Baseline projections	Deaths - total	Number	Innsbruck	2019	2499
Annual	Baseline projections	Deaths - total	Number	Non-metropolitan regions in Austria	2019	38541
Annual	Baseline projections	Deaths - total	Number	Bruxelles / Brussel	2019	20888
Annual	Baseline projections	Deaths - total	Number	Antwerpen	2019	9893
Annual	Baseline projections	Deaths - total	Number	Gent	2019	5888
Annual	Baseline projections	Deaths - total	Number	Charleroi	2019	4694


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

Share link

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