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

Eurostat code: ilc_iw02$dv_2665

@eurostat.ilc_iw02_dv_2665

Table List

2 tables(20.32 KB)

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

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

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

@eurostat.ilc_iw02_dv_2665.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.

7 KB
770 rows
6 columns

freq Freq	hhtyp Hhtyp	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Households with dependent children	Percentage	Austria	2015	9.9
Annual	Households with dependent children	Percentage	Belgium	2015	5.4
Annual	Households with dependent children	Percentage	Bulgaria	2015	9.9
Annual	Households with dependent children	Percentage	Switzerland	2015	10.3
Annual	Households with dependent children	Percentage	Cyprus	2015	7.4
Annual	Households with dependent children	Percentage	Czechia	2015	4.9
Annual	Households with dependent children	Percentage	Germany	2015	9.4
Annual	Households with dependent children	Percentage	Denmark	2015	4.9
Annual	Households with dependent children	Percentage	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2015	10.7
Annual	Households with dependent children	Percentage	Euro area - 18 countries (2014)	2015	10.7


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

Share link

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