Baselight
Sign In

Owner-occupied Housing Price Index - Country Weights

Eurostat code: prc_hpi_oocow ยท (2010 - 2024)

@eurostat.prc_hpi_oocow

Owner-occupied Housing Price Index - Country Weights - Unpivoted
@eurostat.prc_hpi_oocow.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.

  • 72.18 KB
  • 21989 rows
  • 7 columns
freq

Freq

expend

Expend

statinfo

Statinfo

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAcquisitions of dwellingsCountry weights for the euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Per milleAustria201033.57
AnnualAcquisitions of dwellingsCountry weights for the euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Per milleBelgium201050.2
AnnualAcquisitions of dwellingsCountry weights for the euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Per milleCyprus20104.69
AnnualAcquisitions of dwellingsCountry weights for the euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Per milleGermany2010211.58
AnnualAcquisitions of dwellingsCountry weights for the euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Per milleEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)20101000
AnnualAcquisitions of dwellingsCountry weights for the euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Per milleSpain2010127.12
AnnualAcquisitions of dwellingsCountry weights for the euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Per milleFinland201014.35
AnnualAcquisitions of dwellingsCountry weights for the euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Per milleFrance2010255.65
AnnualAcquisitions of dwellingsCountry weights for the euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Per milleIreland201013.47
AnnualAcquisitions of dwellingsCountry weights for the euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Per milleItaly2010207.47

CREATE TABLE tidy (
  "freq" VARCHAR,
  "expend" VARCHAR,
  "statinfo" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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