Mean And Median Income Before Social Transfers (pensions Included In Social Transfers) By Household Type

Eurostat code: ilc_di13b · (2003 - 2024)

@eurostat.ilc_di13b

Table List

2 tables(248.37 KB)

Mean And Median Income Before Social Transfers (pensions Included In Social Transfers) By Household Type - Raw

Mean And Median Income Before Social Transfers (pensions Included In Social Transfers) By Household Type - Unpivoted

Mean And Median Income Before Social Transfers (pensions Included In Social Transfers) By Household Type - Unpivoted

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

114.55 KB
25812 rows
7 columns

freq Freq	unit Unit	hhtyp Hhtyp	indic_il Indic Il	geo Geo	time_period Time Period	value Value
Annual	Euro	Single person with dependent children	Median equivalised net income	Austria	2003	9100
Annual	Euro	Single person with dependent children	Median equivalised net income	Belgium	2003	7678
Annual	Euro	Single person with dependent children	Median equivalised net income	Denmark	2003	12985
Annual	Euro	Single person with dependent children	Median equivalised net income	Greece	2003	5081
Annual	Euro	Single person with dependent children	Median equivalised net income	Ireland	2003	2846
Annual	Euro	Single person with dependent children	Median equivalised net income	Luxembourg	2003	14795
Annual	Euro	Single person with dependent children	Median equivalised net income	Norway	2003	16387
Annual	Euro	Single person with dependent children	Mean equivalised net income	Austria	2003	9949
Annual	Euro	Single person with dependent children	Mean equivalised net income	Belgium	2003	8213
Annual	Euro	Single person with dependent children	Mean equivalised net income	Denmark	2003	11224


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

Share link

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