Loans (excluding Mortgages On Purchase Of Main Residence) By Risk Of Poverty Threshold

Eurostat code: ilc_odbt03 · (2020 - 2020)

@eurostat.ilc_odbt03

Table List

2 tables(11.67 KB)

Loans (excluding Mortgages On Purchase Of Main Residence) By Risk Of Poverty Threshold - Raw

Loans (excluding Mortgages On Purchase Of Main Residence) By Risk Of Poverty Threshold - Unpivoted

Loans (excluding Mortgages On Purchase Of Main Residence) By Risk Of Poverty Threshold - Unpivoted

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

6.12 KB
99 rows
7 columns

freq Freq	statinfo Statinfo	rskpovth Rskpovth	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Median equivalised income	Above 60%	Percentage	Albania	2020	7
Annual	Median equivalised income	Above 60%	Percentage	Austria	2020	18.8
Annual	Median equivalised income	Above 60%	Percentage	Belgium	2020	27
Annual	Median equivalised income	Above 60%	Percentage	Bulgaria	2020	8.7
Annual	Median equivalised income	Above 60%	Percentage	Switzerland	2020	40.2
Annual	Median equivalised income	Above 60%	Percentage	Cyprus	2020	41.1
Annual	Median equivalised income	Above 60%	Percentage	Czechia	2020	16.6
Annual	Median equivalised income	Above 60%	Percentage	Germany	2020	16.2
Annual	Median equivalised income	Above 60%	Percentage	Denmark	2020	31.5
Annual	Median equivalised income	Above 60%	Percentage	Estonia	2020	42.2


CREATE TABLE tidy (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "rskpovth" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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