Baselight

Distribution Of Households By Household Type And Income Level

Eurostat code: ilc_lvph04 ยท (2003 - 2024)

@eurostat.ilc_lvph04

Distribution Of Households By Household Type And Income Level - Unpivoted
@eurostat.ilc_lvph04.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.

  • 60.49 KB
  • 39270 rows
  • 7 columns
freq

Freq

incgrp

Incgrp

hhtyp

Hhtyp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAbove 60% of median equivalised incomeSingle personPercentageAustria200324.6
AnnualAbove 60% of median equivalised incomeSingle personPercentageBelgium200325.6
AnnualAbove 60% of median equivalised incomeSingle personPercentageDenmark200332.2
AnnualAbove 60% of median equivalised incomeSingle personPercentageGreece200314.4
AnnualAbove 60% of median equivalised incomeSingle personPercentageIreland20039.6
AnnualAbove 60% of median equivalised incomeSingle personPercentageLuxembourg200325.7
AnnualAbove 60% of median equivalised incomeSingle personPercentageNorway200328.3
AnnualAbove 60% of median equivalised incomeSingle femalePercentageAustria200314.1
AnnualAbove 60% of median equivalised incomeSingle femalePercentageBelgium200314
AnnualAbove 60% of median equivalised incomeSingle femalePercentageDenmark200316.6

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

Share link

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