Annual financial accounts for general government - gov_10a_ggfa

Data - Eurostat

Author

François Geerolf

Info

DOWNLOAD_TIME

Code 
tibble(DOWNLOAD_TIME = as.Date(file.info("~/iCloud/website/data/eurostat/gov_10a_ggfa.RData")$mtime)) %>%
  print_table_conditional()
DOWNLOAD_TIME
2025-10-11

Last

Code 
gov_10a_ggfa %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  head(1) %>%
  print_table_conditional()
time Nobs
2024 89859

unit

Code 
gov_10a_ggfa %>%
  left_join(unit, by = "unit") %>%
  group_by(unit, Unit) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
unit Unit Nobs
MIO_EUR Million euro 814924
MIO_NAC Million units of national currency 814893
PC_GDP Percentage of gross domestic product (GDP) 810112

sector

Code 
gov_10a_ggfa %>%
  left_join(sector, by = "sector") %>%
  group_by(sector, Sector) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
sector Sector Nobs
S13 General government 599555
S1314 Social security funds 521076
S1311 Central government 509292
S1312 State government 449814
S1313 Local government 360192

na_item

All

Code 
gov_10a_ggfa %>%
  left_join(na_item, by = "na_item") %>%
  group_by(na_item, Na_item) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

geo

Code 
gov_10a_ggfa %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  mutate(Flag = gsub(" ", "-", str_to_lower(Geo)),
         Flag = paste0('<img src="../../bib/flags/vsmall/', Flag, '.png" alt="Flag">')) %>%
  select(Flag, everything()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}

time

Code 
gov_10a_ggfa %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  print_table_conditional()
time Nobs
2024 89859
2023 91911
2022 91911
2021 91911
2020 91911
2019 91911
2018 91215
2017 91215
2016 91215
2015 91215
2014 91215
2013 91215
2012 91215
2011 91185
2010 91188
2009 91176
2008 91176
2007 90576
2006 90576
2005 90576
2004 90576
2003 90576
2002 90576
2001 90576
2000 90612
1999 88981
1998 22991
1997 19444
1996 19442
1995 11783