Mean And Median Income Before Social Transfers (pensions Included In Social Transfers) By Age And Sex

Eurostat code: ilc_di13 · (2003 - 2024)

@eurostat.ilc_di13

Table List

2 tables(924.09 KB)

Mean And Median Income Before Social Transfers (pensions Included In Social Transfers) By Age And Sex - Raw

Mean And Median Income Before Social Transfers (pensions Included In Social Transfers) By Age And Sex - Unpivoted

Mean And Median Income Before Social Transfers (pensions Included In Social Transfers) By Age And Sex - Unpivoted

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

386.14 KB
103248 rows
8 columns

freq Freq	unit Unit	indic_il Indic Il	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Euro	Median equivalised net income	Females	Total	Austria	2003	10140
Annual	Euro	Median equivalised net income	Females	Total	Belgium	2003	10704
Annual	Euro	Median equivalised net income	Females	Total	Denmark	2003	16271
Annual	Euro	Median equivalised net income	Females	Total	Greece	2003	5800
Annual	Euro	Median equivalised net income	Females	Total	Ireland	2003	13517
Annual	Euro	Median equivalised net income	Females	Total	Luxembourg	2003	18211
Annual	Euro	Median equivalised net income	Females	Total	Norway	2003	21412
Annual	Euro	Median equivalised net income	Females	From 16 to 64 years	Austria	2003	11980
Annual	Euro	Median equivalised net income	Females	From 16 to 64 years	Belgium	2003	12989
Annual	Euro	Median equivalised net income	Females	From 16 to 64 years	Denmark	2003	19070


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

Share link

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