Population On 1 January By Age Group, Sex And Citizenship

Eurostat code: migr_pop1ctz · (1998 - 2024)

@eurostat.migr_pop1ctz

Table List

2 tables(26.99 MB)

Population On 1 January By Age Group, Sex And Citizenship - Raw

Population On 1 January By Age Group, Sex And Citizenship - Unpivoted

Population On 1 January By Age Group, Sex And Citizenship - Unpivoted

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

12.91 MB
8369395 rows
8 columns

freq Freq	citizen Citizen	age Age	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Andorra	Total	Number	Females	Switzerland	1998	8
Annual	Andorra	Total	Number	Females	Germany	1998	31
Annual	Andorra	Total	Number	Females	Denmark	1998
Annual	Andorra	Total	Number	Females	Greece	1998
Annual	Andorra	Total	Number	Females	Finland	1998
Annual	Andorra	Total	Number	Females	Hungary	1998
Annual	Andorra	Total	Number	Females	Iceland	1998
Annual	Andorra	Total	Number	Females	Italy	1998	8
Annual	Andorra	Total	Number	Females	Norway	1998
Annual	Andorra	Total	Number	Females	Portugal	1998


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

Share link

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