Business surveys - NACE Rev. 2 activity - Financial services - monthly data - ei_bsbu_m_r2

Data - Eurostat

Structure

Construction Confidence Indicator

France, Germany, Italy, Spain

Code
ei_bsbu_m_r2 |>
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         indic == "BS-CCI-BAL",
         s_adj == "SA") |>
  month_to_date() |>
  filter(date >= as.Date("1990-01-01")) |>
  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(1990, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Construction confidence indicator (balance, pp)") +
  geom_hline(yintercept = 0, linetype = "dashed", color = "black")

France: Factors Limiting Building Activity

Code
ei_bsbu_m_r2 |>
  filter(geo == "FR",
         indic %in% c("BS-FLBA2-PC", "BS-FLBA4-PC", "BS-FLBA5-PC", "BS-FLBA7-PC"),
         s_adj == "NSA") |>
  month_to_date() |>
  filter(date >= as.Date("2000-01-01")) |>
  ggplot() + geom_line(aes(x = date, y = values, color = Indic)) +
  theme_minimal() +
  theme(legend.position = "right", legend.title = element_blank()) +
  scale_x_date(breaks = as.Date(paste0(seq(1990, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Share of respondents citing factor (%)")

Latest Month by Country

Code
latest_m <- ei_bsbu_m_r2 |>
  filter(indic == "BS-CCI-BAL",
         s_adj == "SA",
         geo %in% c("FR", "DE", "IT", "ES", "EA20", "EU27_2020"),
         !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

ei_bsbu_m_r2 |>
  filter(geo %in% c("FR", "DE", "IT", "ES", "EA20", "EU27_2020"),
         s_adj == "SA",
         indic %in% c("BS-CCI-BAL", "BS-CEME-BAL", "BS-COB-BAL", "BS-CPE-BAL", "BS-CTA-BAL"),
         time == latest_m) |>
  select(Indic, Geo, values) |>
  spread(Geo, values) |>
  print_table_conditional()
Indic European Union - 27 countries (from 2020) France Germany Italy Spain
Building activity development over the past 3 months -2.5 -18.2 -10.7 -3.5 -3.3
Construction confidence indicator -6.1 -17.2 -13.2 -2.1 7.0
Employment expectations over the next 3 months - construction 5.4 -1.1 -0.6 6.1 10.5
Evolution of the current overall order books -17.5 -33.3 -25.8 -10.4 3.5
Price expectations over the next 3 months 14.0 -5.6 17.2 13.6 6.7

indic

French

Code
indic <- read_parquet("indic_fr.parquet")
ei_bsbu_m_r2 |>
  
  group_by(indic, Indic) |>
  summarise(Nobs = n()) |>
  arrange(-Nobs) |>
  print_table_conditional()
indic Indic Nobs
BS-CEME-BAL Employment expectations over the next 3 months - construction 28016
BS-COB-BAL Evolution of the current overall order books 27940
BS-CCI-BAL Construction confidence indicator 27908
BS-CTA-BAL Building activity development over the past 3 months 27598
BS-CPE-BAL Price expectations over the next 3 months 26860
BS-FLBA4-PC Factors limiting building activity - shortage of labour 22671
BS-FLBA1-PC Factors limiting building activity - none 22664
BS-FLBA5-PC Factors limiting building activity - shortage of material and/or equipment 22498
BS-FLBA3-PC Factors limiting building activity - weather conditions 22317
BS-FLBA2-PC Factors limiting building activity - insufficient demand 22097
BS-FLBA6-PC Factors limiting building activity - other 21927
BS-FLBA7-PC Factors limiting building activity - financial constraints 19405