Baselight
Sign In

Population On 1 January By Sex And Age Group

Eurostat code: enps_demo_pjangr ยท (2005 - 2023)

@eurostat.enps_demo_pjangr

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

  • 29.87 KB
  • 3470 rows
  • 7 columns
freq

Freq

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesTotalNumberAlgeria200516148003
AnnualFemalesTotalNumberEgypt200534180000
AnnualFemalesTotalNumberIsrael20053476970
AnnualFemalesTotalNumberJordan20052790000
AnnualFemalesTotalNumberMorocco200515209020
AnnualFemalesTotalNumberTunisia20054982679
AnnualFemalesFrom 15 to 19 yearsNumberAlgeria20051862770
AnnualFemalesFrom 15 to 19 yearsNumberEgypt20053612847
AnnualFemalesFrom 15 to 19 yearsNumberIsrael2005278820
AnnualFemalesFrom 15 to 19 yearsNumberJordan2005279395

CREATE TABLE tidy (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);