Baselight

Distribution Of Households By Household Type Until 2001

Eurostat code: ilc_lvph02h ยท (1997 - 2001)

@eurostat.ilc_lvph02h

Distribution Of Households By Household Type Until 2001 - Unpivoted
@eurostat.ilc_lvph02h.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.

  • 5.75 KB
  • 765 rows
  • 6 columns
freq

Freq

hhtyp

Hhtyp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualSingle personPercentageAustria199730
AnnualSingle personPercentageBelgium199728
AnnualSingle personPercentageGermany199736
AnnualSingle personPercentageDenmark199729
AnnualSingle personPercentageEuro area - 12 countries (2001-2006)199728
AnnualSingle personPercentageGreece199720
AnnualSingle personPercentageSpain199714
AnnualSingle personPercentageEuropean Union - 15 countries (1995-2004)199729
AnnualSingle personPercentageFinland199739
AnnualSingle personPercentageFrance199727

CREATE TABLE tidy (
  "freq" 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.