Baselight
Login
Login

Proportion Of Population By Age Group, Sex And Citizenship

Eurostat code: demo_poppcctz ยท (2021 - 2024)

@eurostat.demo_poppcctz

Proportion Of Population By Age Group, Sex And Citizenship - Unpivoted
@eurostat.demo_poppcctz.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.

  • 67.73 KB
  • 46791 rows
  • 8 columns
freq

Freq

citizen

Citizen

age

Age

unit

Unit

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualEuropean Free Trade Association except reporting countryTotalPercentageFemalesFrance202153.8
AnnualEuropean Free Trade Association except reporting countryTotalPercentageMalesFrance202146.2
AnnualEuropean Free Trade Association except reporting countryTotalPercentageTotalFrance2021100
AnnualEuropean Free Trade Association except reporting countryFrom 10 to 14 yearsPercentageFemalesFrance20212.8
AnnualEuropean Free Trade Association except reporting countryFrom 10 to 14 yearsPercentageMalesFrance20212.6
AnnualEuropean Free Trade Association except reporting countryFrom 10 to 14 yearsPercentageTotalFrance20215.4
AnnualEuropean Free Trade Association except reporting countryFrom 15 to 19 yearsPercentageFemalesFrance20212.4
AnnualEuropean Free Trade Association except reporting countryFrom 15 to 19 yearsPercentageMalesFrance20212.2
AnnualEuropean Free Trade Association except reporting countryFrom 15 to 19 yearsPercentageTotalFrance20214.6
AnnualEuropean Free Trade Association except reporting countryFrom 15 to 29 yearsPercentageFemalesFrance20217.6

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.