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

Eurostat code: proj_19rp3 · (2019 - 2100)

@eurostat.proj_19rp3

Table List

2 tables(425.87 MB)

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

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

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

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

226.03 MB
91535616 rows
8 columns

freq Freq	projection Projection	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Baseline projections	Total	Females	Person	Mittelburgenland	2019	19095
Annual	Baseline projections	Total	Females	Person	Nordburgenland	2019	81095
Annual	Baseline projections	Total	Females	Person	Südburgenland	2019	49297
Annual	Baseline projections	Total	Females	Person	Mostviertel-Eisenwurzen	2019	123629
Annual	Baseline projections	Total	Females	Person	Niederösterreich-Süd	2019	132416
Annual	Baseline projections	Total	Females	Person	Sankt Pölten	2019	78783
Annual	Baseline projections	Total	Females	Person	Waldviertel	2019	109644
Annual	Baseline projections	Total	Females	Person	Weinviertel	2019	63085
Annual	Baseline projections	Total	Females	Person	Wiener Umland/Nordteil	2019	168305
Annual	Baseline projections	Total	Females	Person	Wiener Umland/Südteil	2019	175782


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

Share link

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