Business registration and bankruptcy index by NACE Rev.2 activity - quarterly data - sts_rb_q

Data - Eurostat

Info

Last observation: Annual: 2026Q2 (N = 314)

First observation: Annual: 2015Q1 (N = 2,599)

Last data update: 23 jul 2026, 22:27. Last compile: 24 jul 2026, 03:56

Structure

indic_bt

nace_r2

s_adj

unit

geo

Bankruptcy Declarations Index

France, Germany, Italy, Spain

sts_rb_q %>%
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         nace_r2 == "B-S_X_O_S94",
         indic_bt == "BKRT",
         unit == "I21",
         s_adj == "SCA") %>%
  quarter_to_date %>%

  left_join(colors, by = c("Geo" = "country")) %>%
  ggplot + geom_line(aes(x = date, y = values, color = color)) +
  theme_minimal() + scale_color_identity() + add_4flags +
  scale_x_date(breaks = as.Date(paste0(seq(2015, 2100, 1), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Bankruptcy declarations (index, 2021=100)")

France: Registrations vs. Bankruptcies

sts_rb_q %>%
  filter(geo == "FR",
         nace_r2 == "B-S_X_O_S94",
         unit == "I21",
         s_adj == "SCA") %>%
  quarter_to_date %>%
  ggplot + geom_line(aes(x = date, y = values, color = Indic_bt)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(2015, 2100, 1), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Index, 2021=100") +
  theme(legend.position = c(0.25, 0.85), legend.title = element_blank())

Latest Quarter, All Sectors (Index, 2021=100)

latest_q_rb <- sts_rb_q %>%
  filter(nace_r2 == "B-S_X_O_S94",
         unit == "I21",
         s_adj == "SCA",
         geo %in% c("FR", "DE", "IT", "ES"),
         !is.na(values)) %>%
  summarise(m = max(time)) %>%
  pull(m)

sts_rb_q %>%
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         nace_r2 == "B-S_X_O_S94",
         unit == "I21",
         s_adj == "SCA",
         time == latest_q_rb) %>%
  select(indic_bt, Indic_bt, Geo, values) %>%
  spread(Geo, values) %>%
  print_table_conditional()

indic_bt	Indic_bt	France	Germany	Italy	Spain
BKRT	Bankruptcy declarations	255.5	177.9	111.4	138.3
REG	Registrations	118.6	114.3	101.1	134.2