Children At Risk Of Poverty Or Social Exclusion

Eurostat code: tespm040 · (2009 - 2020)

@eurostat.tespm040

Table List

2 tables(21.43 KB)

Children At Risk Of Poverty Or Social Exclusion - Raw

Children At Risk Of Poverty Or Social Exclusion - Unpivoted

Children At Risk Of Poverty Or Social Exclusion - Unpivoted

@eurostat.tespm040.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.27 KB
463 rows
7 columns

freq Freq	unit Unit	age Age	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Percentage	Less than 18 years	Total	Austria	2009	20.8
Annual	Percentage	Less than 18 years	Total	Belgium	2009	20.5
Annual	Percentage	Less than 18 years	Total	Bulgaria	2009	47.3
Annual	Percentage	Less than 18 years	Total	Switzerland	2009	20.4
Annual	Percentage	Less than 18 years	Total	Cyprus	2009	20.2
Annual	Percentage	Less than 18 years	Total	Czechia	2009	17.2
Annual	Percentage	Less than 18 years	Total	Germany	2009	20.4
Annual	Percentage	Less than 18 years	Total	Denmark	2009	14
Annual	Percentage	Less than 18 years	Total	Euro area - 19 countries (2015-2022)	2009	24.3
Annual	Percentage	Less than 18 years	Total	Estonia	2009	24.5


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

Share link

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