Baselight
Sign In

House Sales - Number And Index (2015=100), Quarterly Data

Eurostat code: prc_hpi_hsnq ยท (2006-Q1 - 2024-Q4)

@eurostat.prc_hpi_hsnq

House Sales - Number And Index (2015=100), Quarterly Data - Unpivoted
@eurostat.prc_hpi_hsnq.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.

  • 45.46 KB
  • 10394 rows
  • 6 columns
freq

Freq

unit

Unit

geo

Geo

purchase

Purchase

time_period

Time Period

value

Value

QuarterlyQuarterly index, 2015=100FrancePurchases of existing dwellings2006-Q196.61
QuarterlyQuarterly index, 2015=100FrancePurchases of newly built dwellings2006-Q1132.41
QuarterlyQuarterly index, 2015=100FranceTotal2006-Q1101.46
QuarterlyQuarterly index, 2015=100United KingdomTotal2006-Q1108.88
QuarterlyNumberFrancePurchases of existing dwellings2006-Q1193468
QuarterlyNumberFrancePurchases of newly built dwellings2006-Q141571
QuarterlyNumberFranceTotal2006-Q1235039
QuarterlyPercentage in the yearFrancePurchases of existing dwellings2006-Q123.4
QuarterlyPercentage in the yearFrancePurchases of newly built dwellings2006-Q126.1
QuarterlyPercentage in the yearFranceTotal2006-Q123.8

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

Share link

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