House sales index of value of transactions (2015=100) - annual data - prc_hpi_hsvq

Data - Eurostat

~/data/eurostat/

unit

prc_hpi_hsvq %>%
  left_join(unit, by = "unit") %>%
  group_by(unit, Unit) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}

unit	Unit	Nobs
RCH_Q	Quarterly rate of change	1959
PC_Y	Percentage in the year	1920
INX_Q	Quarterly index	1891
RCH_A	Annual rate of change	1821

geo

prc_hpi_hsvq %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

time

prc_hpi_hsvq %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

Purchase Total

France, Italy, Germany

prc_hpi_hsvq %>%
  filter(geo %in% c("FR", "IT", "DE"),
         unit == "INX_Q") %>%
  quarter_to_date %>%
  left_join(geo, by = "geo") %>%
  ggplot() + geom_line() + theme_minimal() +
  aes(x = date, y = values, color = Geo, linetype = Geo) +
  scale_color_manual(values = viridis(4)[1:3]) +
  scale_x_date(breaks = seq(1920, 2025, 1) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%y")) +
  theme(legend.position = c(0.35, 0.9),
        legend.title = element_blank()) +
  scale_y_log10(breaks = seq(-100, 300, 10)) +
  ylab("House Price Index") + xlab("")

Belgium, Denmark, Finland

prc_hpi_hsvq %>%
  filter(geo %in% c("BE", "DK", "FI"),
         unit == "INX_Q") %>%
  quarter_to_date %>%
  left_join(geo, by = "geo") %>%
  ggplot() + geom_line() + theme_minimal() +
  aes(x = date, y = values, color = Geo, linetype = Geo) +
  scale_color_manual(values = viridis(4)[1:3]) +
  scale_x_date(breaks = seq(1920, 2025, 1) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%y")) +
  theme(legend.position = c(0.1, 0.9),
        legend.title = element_blank()) +
  scale_y_log10(breaks = seq(-100, 300, 10)) +
  ylab("House Price Index") + xlab("")