Persons At Risk Of Monetary Poverty After Social Transfers - EU-SILC And ECHP Surveys

Eurostat code: sdg_01_20 · (2000 - 2024)

@eurostat.sdg_01_20

Table List

2 tables(42.5 KB)

Persons At Risk Of Monetary Poverty After Social Transfers - EU-SILC And ECHP Surveys - Raw

Persons At Risk Of Monetary Poverty After Social Transfers - EU-SILC And ECHP Surveys - Unpivoted

Persons At Risk Of Monetary Poverty After Social Transfers - EU-SILC And ECHP Surveys - Unpivoted

@eurostat.sdg_01_20.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.

12.8 KB
1560 rows
8 columns

freq Freq	age Age	indic_il Indic Il	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	At risk of poverty rate (cut-off point: 60% of median equivalised income after social transfers)	Total	Percentage	Austria	2000	12
Annual	Total	At risk of poverty rate (cut-off point: 60% of median equivalised income after social transfers)	Total	Percentage	Belgium	2000	13
Annual	Total	At risk of poverty rate (cut-off point: 60% of median equivalised income after social transfers)	Total	Percentage	Bulgaria	2000	14
Annual	Total	At risk of poverty rate (cut-off point: 60% of median equivalised income after social transfers)	Total	Percentage	Germany	2000	10
Annual	Total	At risk of poverty rate (cut-off point: 60% of median equivalised income after social transfers)	Total	Percentage	Estonia	2000	18
Annual	Total	At risk of poverty rate (cut-off point: 60% of median equivalised income after social transfers)	Total	Percentage	Greece	2000	20
Annual	Total	At risk of poverty rate (cut-off point: 60% of median equivalised income after social transfers)	Total	Percentage	Spain	2000	18
Annual	Total	At risk of poverty rate (cut-off point: 60% of median equivalised income after social transfers)	Total	Percentage	Finland	2000	11
Annual	Total	At risk of poverty rate (cut-off point: 60% of median equivalised income after social transfers)	Total	Percentage	France	2000	16
Annual	Total	At risk of poverty rate (cut-off point: 60% of median equivalised income after social transfers)	Total	Percentage	Hungary	2000	11


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

Share link

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