Population On 1st January By Age, Sex, Type Of Projection And Metropolitan Region

Eurostat code: met_proj_19rp · (2019 - 2100)

@eurostat.met_proj_19rp

Table List

2 tables(989.62 KB)

Population On 1st January By Age, Sex, Type Of Projection And Metropolitan Region - Raw

Population On 1st January By Age, Sex, Type Of Projection And Metropolitan Region - Unpivoted

Population On 1st January By Age, Sex, Type Of Projection And Metropolitan Region - Unpivoted

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

496.6 KB
67650 rows
8 columns

freq Freq	projection Projection	age Age	sex Sex	unit Unit	metroreg Metroreg	time_period Time Period	value Value
Annual	Baseline projections	Total	Females	Person	Wien	2019	1460755
Annual	Baseline projections	Total	Females	Person	Graz	2019	322718
Annual	Baseline projections	Total	Females	Person	Linz	2019	404198
Annual	Baseline projections	Total	Females	Person	Salzburg	2019	188180
Annual	Baseline projections	Total	Females	Person	Innsbruck	2019	158465
Annual	Baseline projections	Total	Females	Person	Non-metropolitan regions in Austria	2019	1967426
Annual	Baseline projections	Total	Females	Person	Bruxelles / Brussel	2019	1301661
Annual	Baseline projections	Total	Females	Person	Antwerpen	2019	530892
Annual	Baseline projections	Total	Females	Person	Gent	2019	325424
Annual	Baseline projections	Total	Females	Person	Charleroi	2019	221763


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

Share link

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