Baselight

Household Characteristics By Degree Of Urbanisation

Eurostat code: hbs_car_t315 ยท (1988 - 2020)

@eurostat.hbs_car_t315

Household Characteristics By Degree Of Urbanisation - Unpivoted
@eurostat.hbs_car_t315.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.

  • 15.84 KB
  • 2750 rows
  • 6 columns
freq

Freq

hhcaract

Hhcaract

deg_urb

Deg Urb

geo

Geo

time_period

Time Period

value

Value

AnnualAverage number of adult equivalents in the householdCitiesBelgium19881.79
AnnualAverage number of adult equivalents in the householdCitiesGermany19881.67
AnnualAverage number of adult equivalents in the householdCitiesGreece19881.85
AnnualAverage number of adult equivalents in the householdCitiesFrance19881.79
AnnualAverage number of adult equivalents in the householdCitiesItaly19881.81
AnnualAverage number of adult equivalents in the householdCitiesLuxembourg19881.69
AnnualAverage number of adult equivalents in the householdCitiesPortugal19881.96
AnnualAverage number of adult equivalents in the householdCitiesUnited Kingdom19881.59
AnnualAverage number of adult equivalents in the householdTowns and suburbsBelgium19881.67
AnnualAverage number of adult equivalents in the householdTowns and suburbsGermany19881.54

CREATE TABLE tidy (
  "freq" VARCHAR,
  "hhcaract" VARCHAR,
  "deg_urb" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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