Population On 1 January By Broad Age Group And Sex

Eurostat code: demo_pjanbroad · (1960 - 2024)

@eurostat.demo_pjanbroad

Table List

2 tables(527.37 KB)

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

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

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

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

250.62 KB
39075 rows
7 columns

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


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

Share link

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