At-risk-of Poverty Rate For Children By Citizenship Of Their Parents (population Aged 0 To 17 Years)

Eurostat code: ilc_li33$dv_1983

@eurostat.ilc_li33_dv_1983

Table List

2 tables(21.58 KB)

At-risk-of Poverty Rate For Children By Citizenship Of Their Parents (population Aged 0 To 17 Years) - Raw

At-risk-of Poverty Rate For Children By Citizenship Of Their Parents (population Aged 0 To 17 Years) - Unpivoted

At-risk-of Poverty Rate For Children By Citizenship Of Their Parents (population Aged 0 To 17 Years) - Unpivoted

@eurostat.ilc_li33_dv_1983.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.77 KB
731 rows
6 columns

freq Freq	unit Unit	citizen Citizen	geo Geo	time_period Time Period	value Value
Annual	Percentage	Foreign country	Austria	2015	38.6
Annual	Percentage	Foreign country	Belgium	2015	35.3
Annual	Percentage	Foreign country	Switzerland	2015	25.7
Annual	Percentage	Foreign country	Cyprus	2015	30.8
Annual	Percentage	Foreign country	Czechia	2015	21.3
Annual	Percentage	Foreign country	Germany	2015	23.5
Annual	Percentage	Foreign country	Denmark	2015	44.6
Annual	Percentage	Foreign country	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2015	39.9
Annual	Percentage	Foreign country	Euro area - 18 countries (2014)	2015	39.9
Annual	Percentage	Foreign country	Euro area - 19 countries (2015-2022)	2015	39.9


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

Share link

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