House price index, deflated - annual data - tipsho10

Data - Eurostat

Structure

France, Germany, Italy, Spain, Netherlands

Percent

Code
tipsho10 |>
  filter(geo %in% c("FR", "DE", "NL", "ES", "IT"),
         unit == "RCH_A_AVG") |>
  year_to_date() |>
  
  add_flag_color("Geo") |>
  mutate(values = values/100) |>
  ggplot() + geom_line(aes(x = date, y = values, color = color)) + theme_minimal() +
  scale_color_identity() + add_flags +
  scale_x_date(breaks = as.Date(paste0(seq(1960, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("House price index, deflated - annual data") +
  scale_y_continuous(breaks = 0.01*seq(-300, 200, 5),
                     labels = scales::percent_format(accuracy = 1)) +
  geom_hline(yintercept = 0.06, linetype = "dashed")

Index Level (2015 = 100)

Code
tipsho10 |>
  filter(geo %in% c("FR", "DE", "NL", "ES", "IT"),
         unit == "I15_A_AVG") |>
  year_to_date() |>

  add_flag_color("Geo") |>
  ggplot() + geom_line(aes(x = date, y = values, color = color)) + theme_minimal() +
  scale_color_identity() + add_flags +
  scale_x_date(breaks = as.Date(paste0(seq(1960, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Deflated house price index (2015 = 100)") +
  geom_hline(yintercept = 100, linetype = "dashed", color = "black")

Portugal, Poland, Sweden

Code
tipsho10 |>
  filter(geo %in% c("PT", "PL", "SE"),
         unit == "RCH_A_AVG") |>
  year_to_date() |>

  add_flag_color("Geo") |>
  mutate(values = values/100) |>
  ggplot() + geom_line(aes(x = date, y = values, color = color)) + theme_minimal() +
  scale_color_identity() + add_flags +
  scale_x_date(breaks = as.Date(paste0(seq(1960, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("House price index, deflated - annual rate of change") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 1)) +
  geom_hline(yintercept = 0, linetype = "dashed", color = "black")

Latest Year: Ranking by Country

Code
latest_y <- tipsho10 |>
  filter(geo == "FR",
         unit == "RCH_A_AVG",
         !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

tipsho10 |>
  filter(unit == "RCH_A_AVG",
         time == latest_y,
         !is.na(values)) |>
  mutate(values = values/100) |>
  select(Geo, values) |>
  arrange(-values) |>
  print_table_conditional()
Geo values
Portugal 0.146
Hungary 0.113
Spain 0.100
Bulgaria 0.099
Croatia 0.094
Slovakia 0.076
Czechia 0.071
Malta 0.065
Lithuania 0.059
Ireland 0.057
Netherlands 0.057
Slovenia 0.054
Denmark 0.049
Greece 0.047
Cyprus 0.042
Latvia 0.039
Euro area – 21 countries (from 2026) 0.032
Euro area – 20 countries (2023-2025) 0.031
European Union - 27 countries (from 2020) 0.030
Italy 0.025
Estonia 0.020
Poland 0.015
Belgium 0.007
Germany 0.007
Austria -0.002
France -0.002
Luxembourg -0.008
Sweden -0.016
Romania -0.018
Finland -0.035