Population On 1 January By Age, Sex And Group Of Country Of Birth

Eurostat code: migr_pop4ctb · (1998 - 2024)

@eurostat.migr_pop4ctb

Table List

2 tables(5.68 MB)

Population On 1 January By Age, Sex And Group Of Country Of Birth - Raw

Population On 1 January By Age, Sex And Group Of Country Of Birth - Unpivoted

Population On 1 January By Age, Sex And Group Of Country Of Birth - Unpivoted

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

2.65 MB
644375 rows
8 columns

freq Freq	age Age	c_birth C Birth	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Total	Total	Number	Females	Denmark	1998	2679191
Annual	Total	Total	Number	Females	Greece	1998	5329741
Annual	Total	Total	Number	Females	Spain	1998	20478881
Annual	Total	Total	Number	Females	Hungary	1998	5362420
Annual	Total	Total	Number	Females	Ireland	1998	1859395
Annual	Total	Total	Number	Females	Norway	1998	2232493
Annual	Total	Total	Number	Females	Portugal	1998	5255612
Annual	Total	Total	Number	Females	Slovenia	1998	1016763
Annual	Total	Total	Number	Females	United Kingdom	1998	29616162
Annual	Total	Total	Number	Males	Denmark	1998	2615669


CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "c_birth" 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.