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

Eurostat code: ilc_li34 · (2003 - 2024)

@eurostat.ilc_li34

Table List

2 tables(34.26 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.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.

9.07 KB
1515 rows
6 columns

freq Freq	unit Unit	c_birth C Birth	geo Geo	time_period Time Period	value Value
Annual	Percentage	Foreign country	Austria	2003	27.7
Annual	Percentage	Foreign country	Belgium	2003	31.5
Annual	Percentage	Foreign country	Denmark	2003	25.4
Annual	Percentage	Foreign country	Greece	2003	27.8
Annual	Percentage	Foreign country	Ireland	2003	22.3
Annual	Percentage	Foreign country	Luxembourg	2003	21.4
Annual	Percentage	Foreign country	Norway	2003	17.6
Annual	Percentage	Reporting country	Austria	2003	12.2
Annual	Percentage	Reporting country	Belgium	2003	11.5
Annual	Percentage	Reporting country	Denmark	2003	7.1


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.