Baselight
Sign In

Population On 1 January By Age Group, Sex And Citizenship

Eurostat code: migr_pop1ctz$dv_1764

@eurostat.migr_pop1ctz_dv_1764

Population On 1 January By Age Group, Sex And Citizenship - Unpivoted
@eurostat.migr_pop1ctz_dv_1764.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.

  • 474.01 KB
  • 80790 rows
  • 8 columns
freq

Freq

citizen

Citizen

age

Age

unit

Unit

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (from 2020) except reporting countryTotalNumberFemalesHungary201333122
AnnualEU27 countries (from 2020) except reporting countryTotalNumberFemalesItaly2013773020
AnnualEU27 countries (from 2020) except reporting countryTotalNumberFemalesNorway2013107352
AnnualEU27 countries (from 2020) except reporting countryTotalNumberMalesHungary201345007
AnnualEU27 countries (from 2020) except reporting countryTotalNumberMalesItaly2013535251
AnnualEU27 countries (from 2020) except reporting countryTotalNumberMalesNorway2013155806
AnnualEU27 countries (from 2020) except reporting countryTotalNumberTotalHungary201378129
AnnualEU27 countries (from 2020) except reporting countryTotalNumberTotalItaly20131308271
AnnualEU27 countries (from 2020) except reporting countryTotalNumberTotalNorway2013263158
AnnualEU27 countries (from 2020) except reporting countryUnknownNumberFemalesHungary2013

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.