House Sales - Value And Index (2015=100), Annual Data

Eurostat code: prc_hpi_hsva · (1998 - 2024)

@eurostat.prc_hpi_hsva

Table List

2 tables(55.83 KB)

House Sales - Value And Index (2015=100), Annual Data - Raw

House Sales - Value And Index (2015=100), Annual Data - Unpivoted

House Sales - Value And Index (2015=100), Annual Data - Unpivoted

@eurostat.prc_hpi_hsva.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.

19.73 KB
2468 rows
6 columns

freq Freq	unit Unit	geo Geo	purchase Purchase	time_period Time Period	value Value
Annual	Euro	France	Total	1998	67500679923
Annual	Quarterly index, 2015=100	France	Total	1998	36.8
Annual	National currency	France	Total	1998	67500679923
Annual	Euro	France	Total	1999	81783073394
Annual	Quarterly index, 2015=100	France	Total	1999	44.58
Annual	National currency	France	Total	1999	81783073394
Annual	Euro	France	Purchases of existing dwellings	2000	76712783322
Annual	Euro	France	Total	2000	91941801836
Annual	Quarterly index, 2015=100	France	Purchases of existing dwellings	2000	49.06
Annual	Quarterly index, 2015=100	France	Total	2000	50.12


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.