Population On 1 January By Broad Age Group, Sex And Metropolitan Region

Eurostat code: met_pjanaggr3 · (1990 - 2023)

@eurostat.met_pjanaggr3

Table List

2 tables(1.4 MB)

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

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

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

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

729.43 KB
124574 rows
6 columns

freq Freq	sex Sex	age Age	metroreg Metroreg	time_period Time Period	value Value
Annual	Females	Total	Austria	1990	3989903
Annual	Females	Total	Belgium	1990	5087683
Annual	Females	Total	Bulgaria	1990	4443535
Annual	Females	Total	Sofia	1990	863940
Annual	Females	Total	Plovdiv	1990	384136
Annual	Females	Total	Varna	1990	233266
Annual	Females	Total	Burgas	1990	223612
Annual	Females	Total	Non-metropolitan regions in Bulgaria	1990	2738581
Annual	Females	Total	Switzerland	1990	3416313
Annual	Females	Total	Zürich	1990	588263


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

Share link

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