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

Eurostat code: ilc_li34$dv_1982

@eurostat.ilc_li34_dv_1982

Table List

2 tables(21.53 KB)

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

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

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

@eurostat.ilc_li34_dv_1982.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.64 KB
745 rows
6 columns

freq Freq	unit Unit	c_birth C Birth	geo Geo	time_period Time Period	value Value
Annual	Percentage	Foreign country	Austria	2015	34.6
Annual	Percentage	Foreign country	Belgium	2015	33
Annual	Percentage	Foreign country	Switzerland	2015	23.9
Annual	Percentage	Foreign country	Cyprus	2015	27.4
Annual	Percentage	Foreign country	Czechia	2015	28.9
Annual	Percentage	Foreign country	Germany	2015	20
Annual	Percentage	Foreign country	Denmark	2015	33.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	34.5
Annual	Percentage	Foreign country	Euro area - 18 countries (2014)	2015	34.5
Annual	Percentage	Foreign country	Euro area - 19 countries (2015-2022)	2015	34.5


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

Share link

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