Population By Sex, Age And Other Typologies

Eurostat code: urt_lfsd3pop · (1999 - 2023)

@eurostat.urt_lfsd3pop

Table List

2 tables(333.28 KB)

Population By Sex, Age And Other Typologies - Raw

Population By Sex, Age And Other Typologies - Unpivoted

Population By Sex, Age And Other Typologies - Unpivoted

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

152.82 KB
27886 rows
8 columns

freq Freq	unit Unit	age Age	sex Sex	terrtypo Terrtypo	geo Geo	time_period Time Period	value Value
Annual	Thousand persons	From 15 to 64 years	Females	Border regions	Austria	1999	2360.6
Annual	Thousand persons	From 15 to 64 years	Females	Border regions	Estonia	1999	234.6
Annual	Thousand persons	From 15 to 64 years	Females	Border regions	Greece	1999	472
Annual	Thousand persons	From 15 to 64 years	Females	Border regions	Spain	1999	3809
Annual	Thousand persons	From 15 to 64 years	Females	Border regions	Hungary	1999	2549.8
Annual	Thousand persons	From 15 to 64 years	Females	Border regions	Ireland	1999	434.2
Annual	Thousand persons	From 15 to 64 years	Females	Border regions	Lithuania	1999	957
Annual	Thousand persons	From 15 to 64 years	Females	Border regions	Luxembourg	1999	141.2
Annual	Thousand persons	From 15 to 64 years	Females	Border regions	Latvia	1999	549.3
Annual	Thousand persons	From 15 to 64 years	Females	Border regions	Romania	1999	3574.7


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

Share link

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