Baselight

Persons At Risk Of Monetary Poverty After Social Transfers By Citizenship

Eurostat code: sdg_01_20a ยท (2003 - 2024)

@eurostat.sdg_01_20a

Persons At Risk Of Monetary Poverty After Social Transfers By Citizenship - Unpivoted
@eurostat.sdg_01_20a.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.

  • 10.89 KB
  • 1803 rows
  • 8 columns
freq

Freq

unit

Unit

age

Age

sex

Sex

citizen

Citizen

geo

Geo

time_period

Time Period

value

Value

AnnualPercentage18 years or overTotalReporting countryAustria200311.6
AnnualPercentage18 years or overTotalReporting countryBelgium200313.7
AnnualPercentage18 years or overTotalReporting countryDenmark200311.7
AnnualPercentage18 years or overTotalReporting countryGreece200320.3
AnnualPercentage18 years or overTotalReporting countryIreland200320.1
AnnualPercentage18 years or overTotalReporting countryLuxembourg20037.1
AnnualPercentage18 years or overTotalReporting countryNorway200311.1
AnnualPercentage18 years or overTotalReporting countryAustria200411.2
AnnualPercentage18 years or overTotalReporting countryBelgium200412.8
AnnualPercentage18 years or overTotalReporting countryDenmark200410.8

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

Share link

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