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

Eurostat code: ilc_li33 · (2003 - 2024)

@eurostat.ilc_li33

Table List

2 tables(34.33 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.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.25 KB
1476 rows
6 columns

freq Freq	unit Unit	citizen Citizen	geo Geo	time_period Time Period	value Value
Annual	Percentage	Foreign country	Austria	2003	23.9
Annual	Percentage	Foreign country	Belgium	2003	32.8
Annual	Percentage	Foreign country	Denmark	2003	25.4
Annual	Percentage	Foreign country	Greece	2003	28.8
Annual	Percentage	Foreign country	Ireland	2003	28.7
Annual	Percentage	Foreign country	Luxembourg	2003	22.4
Annual	Percentage	Foreign country	Norway	2003	16
Annual	Percentage	Reporting country	Austria	2003	14
Annual	Percentage	Reporting country	Belgium	2003	13.7
Annual	Percentage	Reporting country	Denmark	2003	7.1


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.