At-risk-of-poverty Thresholds

Eurostat code: ilc_li01 · (1995 - 2024)

@eurostat.ilc_li01

Table List

2 tables(385.9 KB)

At-risk-of-poverty Thresholds - Unpivoted

At-risk-of-poverty Thresholds - Unpivoted

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

172.63 KB
38865 rows
7 columns

freq Freq	hhtyp Hhtyp	indic_il Indic Il	currency Currency	geo Geo	time_period Time Period	value Value
Annual	Single person	At risk of poverty threshold (40% of mean equivalised income)	Euro	Austria	1995	6283
Annual	Single person	At risk of poverty threshold (40% of mean equivalised income)	Euro	Belgium	1995	6006
Annual	Single person	At risk of poverty threshold (40% of mean equivalised income)	Euro	Germany	1995	6014
Annual	Single person	At risk of poverty threshold (40% of mean equivalised income)	Euro	Greece	1995	2472
Annual	Single person	At risk of poverty threshold (40% of mean equivalised income)	Euro	Spain	1995	2978
Annual	Single person	At risk of poverty threshold (40% of mean equivalised income)	Euro	France	1995	5788
Annual	Single person	At risk of poverty threshold (40% of mean equivalised income)	Euro	Ireland	1995	3899
Annual	Single person	At risk of poverty threshold (40% of mean equivalised income)	Euro	Italy	1995	3565
Annual	Single person	At risk of poverty threshold (40% of mean equivalised income)	Euro	Luxembourg	1995	8844
Annual	Single person	At risk of poverty threshold (40% of mean equivalised income)	Euro	Netherlands	1995	5202


CREATE TABLE tidy (
  "freq" VARCHAR,
  "hhtyp" VARCHAR,
  "indic_il" VARCHAR,
  "currency" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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