Population On 1 January By Age, Sex And NUTS 2 Region

Eurostat code: demo_r_d2jan · (1990 - 2024)

@eurostat.demo_r_d2jan

Table List

2 tables(37.17 MB)

Population On 1 January By Age, Sex And NUTS 2 Region - Raw

Population On 1 January By Age, Sex And NUTS 2 Region - Unpivoted

Population On 1 January By Age, Sex And NUTS 2 Region - Unpivoted

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

18.41 MB
4543029 rows
7 columns

freq Freq	unit Unit	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Number	Females	Total	Austria	1990	3989903
Annual	Number	Females	Total	Ostösterreich	1990	1700829
Annual	Number	Females	Total	Burgenland	1990	139775
Annual	Number	Females	Total	Niederösterreich	1990	752424
Annual	Number	Females	Total	Wien	1990	808630
Annual	Number	Females	Total	Südösterreich	1990	889103
Annual	Number	Females	Total	Kärnten	1990	281917
Annual	Number	Females	Total	Steiermark	1990	607186
Annual	Number	Females	Total	Westösterreich	1990	1399971
Annual	Number	Females	Total	Oberösterreich	1990	670153


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

Share link

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