Population On 1 January By Broad Age Group, Sex And Other Typologies

Eurostat code: urt_pjanaggr3 · (1990 - 2023)

@eurostat.urt_pjanaggr3

Table List

2 tables(1.18 MB)

Population On 1 January By Broad Age Group, Sex And Other Typologies - Raw

Population On 1 January By Broad Age Group, Sex And Other Typologies - Unpivoted

Population On 1 January By Broad Age Group, Sex And Other Typologies - Unpivoted

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

610.8 KB
108437 rows
7 columns

freq Freq	sex Sex	age Age	terrtypo Terrtypo	geo Geo	time_period Time Period	value Value
Annual	Females	Total	Border regions	Bulgaria	1990	2488410
Annual	Females	Total	Border regions	Switzerland	1990	3130920
Annual	Females	Total	Border regions	Spain	1990	4151854
Annual	Females	Total	Border regions	Finland	1990	670600
Annual	Females	Total	Border regions	Liechtenstein	1990	14533
Annual	Females	Total	Border regions	Luxembourg	1990	193948
Annual	Females	Total	Coastal regions	Bulgaria	1990	580515
Annual	Females	Total	Coastal regions	Cyprus	1990	287064
Annual	Females	Total	Coastal regions	Finland	1990	1565933
Annual	Females	Total	Intermediate regions	Bulgaria	1990	3113526


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

Share link

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