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
2026-01-31

Last

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

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 836816
MIO_NAC Million units of national currency 836785
PC_GDP Percentage of gross domestic product (GDP) 831278

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 619040
S1314 Social security funds 530199
S1311 Central government 524439
S1312 State government 458913
S1313 Local government 372288

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 91641
2023 93585
2022 93585
2021 93585
2020 93585
2019 93585
2018 93585
2017 93585
2016 93585
2015 93585
2014 93585
2013 93585
2012 93585
2011 93555
2010 93585
2009 93585
2008 93585
2007 92985
2006 92985
2005 92985
2004 92985
2003 92985
2002 92982
2001 92985
2000 93021
1999 91150
1998 25442
1997 21026
1996 21024
1995 13353