Baselight
Sign In

Proportion Of Population By Age Group, Sex And Country Of Birth

Eurostat code: demo_poppcctb ยท (2021 - 2024)

@eurostat.demo_poppcctb

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

  • 53.49 KB
  • 34162 rows
  • 8 columns
freq

Freq

c_birth

C Birth

age

Age

unit

Unit

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualEuropean Free Trade Association except reporting countryTotalPercentageFemalesFrance202154.2
AnnualEuropean Free Trade Association except reporting countryTotalPercentageMalesFrance202145.8
AnnualEuropean Free Trade Association except reporting countryTotalPercentageTotalFrance2021100
AnnualEuropean Free Trade Association except reporting countryFrom 10 to 14 yearsPercentageFemalesFrance20213.5
AnnualEuropean Free Trade Association except reporting countryFrom 10 to 14 yearsPercentageMalesFrance20213.6
AnnualEuropean Free Trade Association except reporting countryFrom 10 to 14 yearsPercentageTotalFrance20217.1
AnnualEuropean Free Trade Association except reporting countryFrom 15 to 19 yearsPercentageFemalesFrance20213
AnnualEuropean Free Trade Association except reporting countryFrom 15 to 19 yearsPercentageMalesFrance20213
AnnualEuropean Free Trade Association except reporting countryFrom 15 to 19 yearsPercentageTotalFrance20216
AnnualEuropean Free Trade Association except reporting countryFrom 15 to 29 yearsPercentageFemalesFrance20218.6

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