Baselight
Sign In

Population On 1 January By Age Group, Sex And Level Of Human Development Of The Country Of Citizenship

Eurostat code: migr_pop7ctz ยท (2014 - 2024)

@eurostat.migr_pop7ctz

Population On 1 January By Age Group, Sex And Level Of Human Development Of The Country Of Citizenship - Unpivoted
@eurostat.migr_pop7ctz.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.

  • 1.29 MB
  • 365663 rows
  • 8 columns
freq

Freq

citizen

Citizen

age

Age

unit

Unit

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualCandidate countries in 2013 (5 countries) except reporting country and IcelandTotalNumberFemalesAustria2014120300
AnnualCandidate countries in 2013 (5 countries) except reporting country and IcelandTotalNumberFemalesBelgium201423199
AnnualCandidate countries in 2013 (5 countries) except reporting country and IcelandTotalNumberFemalesSwitzerland2014108672
AnnualCandidate countries in 2013 (5 countries) except reporting country and IcelandTotalNumberFemalesCyprus2014225
AnnualCandidate countries in 2013 (5 countries) except reporting country and IcelandTotalNumberFemalesCzechia20141787
AnnualCandidate countries in 2013 (5 countries) except reporting country and IcelandTotalNumberFemalesGermany2014804424
AnnualCandidate countries in 2013 (5 countries) except reporting country and IcelandTotalNumberFemalesDenmark201416410
AnnualCandidate countries in 2013 (5 countries) except reporting country and IcelandTotalNumberFemalesEstonia201431
AnnualCandidate countries in 2013 (5 countries) except reporting country and IcelandTotalNumberFemalesGreece20145728
AnnualCandidate countries in 2013 (5 countries) except reporting country and IcelandTotalNumberFemalesSpain20142901

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.