Baselight

Unemployment Benefits Recipients By Sex, Age And Type Of Benefit

Eurostat code: spr_ubr_ben ยท (2018 - 2022)

@eurostat.spr_ubr_ben

Unemployment Benefits Recipients By Sex, Age And Type Of Benefit - Unpivoted
@eurostat.spr_ubr_ben.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.

  • 26.43 KB
  • 3149 rows
  • 9 columns
freq

Freq

spdep

Spdep

sex

Sex

age

Age

indic_sp

Indic Sp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualPeriodic cash benefitsFemalesTotalRecipients over the yearPersonsSwitzerland2018152190
AnnualPeriodic cash benefitsFemalesTotalRecipients over the yearPersonsCzechia2018168521
AnnualPeriodic cash benefitsFemalesTotalRecipients over the yearPersonsMalta20186403
AnnualPeriodic cash benefitsFemalesFrom 15 to 24 yearsRecipients over the yearPersonsSwitzerland201817822
AnnualPeriodic cash benefitsFemalesFrom 15 to 24 yearsRecipients over the yearPersonsCzechia201811136
AnnualPeriodic cash benefitsFemalesFrom 15 to 24 yearsRecipients over the yearPersonsMalta20181265
AnnualPeriodic cash benefitsFemalesFrom 25 to 54 yearsRecipients over the yearPersonsSwitzerland201897277
AnnualPeriodic cash benefitsFemalesFrom 25 to 54 yearsRecipients over the yearPersonsCzechia2018130320
AnnualPeriodic cash benefitsFemalesFrom 25 to 54 yearsRecipients over the yearPersonsMalta20184556
AnnualPeriodic cash benefitsFemalesFrom 55 to 64 yearsRecipients over the yearPersonsSwitzerland201837091

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

Share link

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