Population On 1 January By Age Group And Sex

Eurostat code: demo_pjangroup · (1960 - 2024)

@eurostat.demo_pjangroup

Table List

2 tables(2.22 MB)

Population On 1 January By Age Group And Sex - Raw

Population On 1 January By Age Group And Sex - Unpivoted

Population On 1 January By Age Group And Sex - Unpivoted

@eurostat.demo_pjangroup.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.1 MB
165358 rows
7 columns

freq Freq	unit Unit	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Number	Females	Total	Austria	1960	3757167
Annual	Number	Females	Total	Belgium	1960	4650891
Annual	Number	Females	Total	Bulgaria	1960	3921043
Annual	Number	Females	Total	Switzerland	1960	2730400
Annual	Number	Females	Total	Czechia	1960	4941152
Annual	Number	Females	Total	Germany	1960	29345361
Annual	Number	Females	Total	Germany including former GDR	1960	38856574
Annual	Number	Females	Total	Denmark	1960	2300897
Annual	Number	Females	Total	Estonia	1960	674328
Annual	Number	Females	Total	European Free Trade Association	1960	4614773


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.