Baselight

Inactive Population By Sex, Age And Citizenship (1–000)

Eurostat code: lfsa_igan · (1995 - 2024)

@eurostat.lfsa_igan

Inactive Population By Sex, Age And Citizenship (1–000) - Unpivoted
@eurostat.lfsa_igan.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.

  • 1.23 MB
  • 398367 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

citizen

Citizen

geo

Geo

time_period

Time Period

value

Value

AnnualThousand personsFemalesFrom 15 to 19 yearsEU27 countries (from 2020) except reporting countryBelgium19959.7
AnnualThousand personsFemalesFrom 15 to 19 yearsEU27 countries (from 2020) except reporting countryGermany199541.9
AnnualThousand personsFemalesFrom 15 to 19 yearsEU27 countries (from 2020) except reporting countryFrance199515.8
AnnualThousand personsFemalesFrom 15 to 19 yearsEU27 countries (from 2020) except reporting countryLuxembourg19953.1
AnnualThousand personsFemalesFrom 15 to 19 yearsForeign countryAustria199511.9
AnnualThousand personsFemalesFrom 15 to 19 yearsForeign countryBelgium199524.2
AnnualThousand personsFemalesFrom 15 to 19 yearsForeign countryGermany1995177.7
AnnualThousand personsFemalesFrom 15 to 19 yearsForeign countryGreece19953
AnnualThousand personsFemalesFrom 15 to 19 yearsForeign countrySpain19954.2
AnnualThousand personsFemalesFrom 15 to 19 yearsForeign countryFrance199590.9

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

Share link

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