Baselight

Mean And Median Income By Group Of Citizenship (population Aged 18 And Over)

Eurostat code: ilc_di15 ยท (2003 - 2024)

@eurostat.ilc_di15

Mean And Median Income By Group Of Citizenship (population Aged 18 And Over) - Unpivoted
@eurostat.ilc_di15.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.

  • 2.12 MB
  • 608480 rows
  • 9 columns
freq

Freq

unit

Unit

indic_il

Indic Il

citizen

Citizen

sex

Sex

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualEuroMedian equivalised net incomeEU27 countries (2007-2013) except reporting countryFemalesFrom 18 to 54 yearsAustria200315731
AnnualEuroMedian equivalised net incomeEU27 countries (2007-2013) except reporting countryFemalesFrom 18 to 54 yearsBelgium200314802
AnnualEuroMedian equivalised net incomeEU27 countries (2007-2013) except reporting countryFemalesFrom 18 to 54 yearsDenmark200320948
AnnualEuroMedian equivalised net incomeEU27 countries (2007-2013) except reporting countryFemalesFrom 18 to 54 yearsGreece20038025
AnnualEuroMedian equivalised net incomeEU27 countries (2007-2013) except reporting countryFemalesFrom 18 to 54 yearsIreland200317131
AnnualEuroMedian equivalised net incomeEU27 countries (2007-2013) except reporting countryFemalesFrom 18 to 54 yearsLuxembourg200324270
AnnualEuroMedian equivalised net incomeEU27 countries (2007-2013) except reporting countryFemalesFrom 18 to 54 yearsNorway200330069
AnnualEuroMedian equivalised net incomeEU27 countries (2007-2013) except reporting countryFemalesFrom 18 to 59 yearsAustria200315731
AnnualEuroMedian equivalised net incomeEU27 countries (2007-2013) except reporting countryFemalesFrom 18 to 59 yearsBelgium200314384
AnnualEuroMedian equivalised net incomeEU27 countries (2007-2013) except reporting countryFemalesFrom 18 to 59 yearsDenmark200321051

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "indic_il" VARCHAR,
  "citizen" 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.