Baselight

Distribution Of Population By Degree Of Urbanisation, Dwelling Type And Income Group

Eurostat code: ilc_lvho01 ยท (2003 - 2024)

@eurostat.ilc_lvho01

Distribution Of Population By Degree Of Urbanisation, Dwelling Type And Income Group - Unpivoted
@eurostat.ilc_lvho01.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.

  • 99.72 KB
  • 70472 rows
  • 8 columns
freq

Freq

incgrp

Incgrp

building

Building

deg_urb

Deg Urb

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAbove 60% of median equivalised incomeFlatCitiesPercentageAustria20038.7
AnnualAbove 60% of median equivalised incomeFlatCitiesPercentageBelgium200311.7
AnnualAbove 60% of median equivalised incomeFlatCitiesPercentageDenmark200314.3
AnnualAbove 60% of median equivalised incomeFlatCitiesPercentageGreece200329.2
AnnualAbove 60% of median equivalised incomeFlatCitiesPercentageIreland20031.5
AnnualAbove 60% of median equivalised incomeFlatCitiesPercentageLuxembourg200312.8
AnnualAbove 60% of median equivalised incomeFlatTowns and suburbsPercentageAustria20036.4
AnnualAbove 60% of median equivalised incomeFlatTowns and suburbsPercentageBelgium20031.8
AnnualAbove 60% of median equivalised incomeFlatTowns and suburbsPercentageDenmark20036.1
AnnualAbove 60% of median equivalised incomeFlatTowns and suburbsPercentageGreece20037.4

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

Share link

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