Baselight
Sign In

In-work At-risk-of-poverty Rate By Household Type

Eurostat code: ilc_iw02 ยท (2003 - 2024)

@eurostat.ilc_iw02

In-work At-risk-of-poverty Rate By Household Type - Unpivoted
@eurostat.ilc_iw02.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.

  • 12.8 KB
  • 4711 rows
  • 6 columns
freq

Freq

hhtyp

Hhtyp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualSingle personPercentageAustria200311.1
AnnualSingle personPercentageBelgium200310.3
AnnualSingle personPercentageDenmark200310
AnnualSingle personPercentageGreece20037.2
AnnualSingle personPercentageIreland200317.9
AnnualSingle personPercentageLuxembourg20036.8
AnnualSingle personPercentageNorway200310.9
AnnualSingle person with dependent childrenPercentageAustria200324.1
AnnualSingle person with dependent childrenPercentageBelgium200314
AnnualSingle person with dependent childrenPercentageDenmark20037.3

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