Baselight
Sign In

Supplementary Indicators To Unemployment By Sex And Country Of Birth

Eurostat code: lfsa_sup_cob · (2006 - 2024)

@eurostat.lfsa_sup_cob

Supplementary Indicators To Unemployment By Sex And Country Of Birth - Unpivoted
@eurostat.lfsa_sup_cob.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.

  • 111.61 KB
  • 38297 rows
  • 9 columns
freq

Freq

wstatus

Wstatus

c_birth

C Birth

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualPersons available to work but not seekingEU27 countries (from 2020) except reporting countryFrom 15 to 74 yearsFemalesThousand personsAustria20068.9
AnnualPersons available to work but not seekingEU27 countries (from 2020) except reporting countryFrom 15 to 74 yearsFemalesThousand personsBelgium20065.3
AnnualPersons available to work but not seekingEU27 countries (from 2020) except reporting countryFrom 15 to 74 yearsFemalesThousand personsSwitzerland200618.4
AnnualPersons available to work but not seekingEU27 countries (from 2020) except reporting countryFrom 15 to 74 yearsFemalesThousand personsCzechia20061.1
AnnualPersons available to work but not seekingEU27 countries (from 2020) except reporting countryFrom 15 to 74 yearsFemalesThousand personsEuro area – 20 countries (from 2023)200695.2
AnnualPersons available to work but not seekingEU27 countries (from 2020) except reporting countryFrom 15 to 74 yearsFemalesThousand personsSpain200618.8
AnnualPersons available to work but not seekingEU27 countries (from 2020) except reporting countryFrom 15 to 74 yearsFemalesThousand personsEuropean Union - 27 countries (from 2020)2006101.9
AnnualPersons available to work but not seekingEU27 countries (from 2020) except reporting countryFrom 15 to 74 yearsFemalesThousand personsFrance200611
AnnualPersons available to work but not seekingEU27 countries (from 2020) except reporting countryFrom 15 to 74 yearsFemalesThousand personsItaly200640.3
AnnualPersons available to work but not seekingEU27 countries (from 2020) except reporting countryFrom 15 to 74 yearsFemalesThousand personsNetherlands20065.6

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

Share link

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