Baselight
Sign In

Annual Population By Sex, Age, Degree Of Urbanisation And Labour Status (1–000)

Eurostat code: lfsa_pgauws · (1983 - 2024)

@eurostat.lfsa_pgauws

Annual Population By Sex, Age, Degree Of Urbanisation And Labour Status (1–000) - Unpivoted
@eurostat.lfsa_pgauws.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.

  • 5.82 MB
  • 1788548 rows
  • 9 columns
freq

Freq

unit

Unit

sex

Sex

deg_urb

Deg Urb

age

Age

wstatus

Wstatus

geo

Geo

time_period

Time Period

value

Value

AnnualThousand personsFemalesNo responseFrom 15 to 19 yearsPersons in the labour forceBelgium198366.3
AnnualThousand personsFemalesNo responseFrom 15 to 19 yearsPersons in the labour forceGermany1983992.8
AnnualThousand personsFemalesNo responseFrom 15 to 19 yearsPersons in the labour forceDenmark198388.2
AnnualThousand personsFemalesNo responseFrom 15 to 19 yearsPersons in the labour forceGreece198390.1
AnnualThousand personsFemalesNo responseFrom 15 to 19 yearsPersons in the labour forceFrance1983473.3
AnnualThousand personsFemalesNo responseFrom 15 to 19 yearsPersons in the labour forceIreland198356.2
AnnualThousand personsFemalesNo responseFrom 15 to 19 yearsPersons in the labour forceItaly1983666
AnnualThousand personsFemalesNo responseFrom 15 to 19 yearsPersons in the labour forceLuxembourg19836.1
AnnualThousand personsFemalesNo responseFrom 15 to 19 yearsPersons in the labour forceNetherlands1983155.1
AnnualThousand personsFemalesNo responseFrom 15 to 19 yearsPersons in the labour forceUnited Kingdom19831103

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

Share link

Anyone who has the link will be able to view this.