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

Eurostat code: urt_pjangrp3 · (2014 - 2023)

@eurostat.urt_pjangrp3

Table List

2 tables(2.68 MB)

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

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

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

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

1.32 MB
226496 rows
8 columns

freq Freq	unit Unit	sex Sex	age Age	terrtypo Terrtypo	geo Geo	time_period Time Period	value Value
Annual	Number	Females	Total	Border regions	Albania	2014	597512
Annual	Number	Females	Total	Border regions	Austria	2014	2228363
Annual	Number	Females	Total	Border regions	Belgium	2014	3581891
Annual	Number	Females	Total	Border regions	Bulgaria	2014	1696146
Annual	Number	Females	Total	Border regions	Switzerland	2014	3051852
Annual	Number	Females	Total	Border regions	Czechia	2014	3792931
Annual	Number	Females	Total	Border regions	Germany	2014	6850426
Annual	Number	Females	Total	Border regions	Denmark	2014	999866
Annual	Number	Females	Total	Border regions	Greece	2014	601062
Annual	Number	Females	Total	Border regions	Spain	2014	3198057


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" 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.