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-05-18

Last

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

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 814673
MIO_NAC Million units of national currency 814642
PC_GDP Percentage of gross domestic product (GDP) 809861

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 598172
S1314 Social security funds 521301
S1311 Central government 516909
S1312 State government 435306
S1313 Local government 367488

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 89151
2023 91341
2022 91353
2021 91353
2020 91353
2019 91353
2018 91353
2017 91353
2016 91353
2015 91353
2014 91353
2013 91353
2012 91353
2011 91323
2010 91326
2009 91314
2008 91314
2007 90714
2006 90714
2005 90714
2004 90714
2003 90714
2002 90711
2001 90714
2000 90750
1999 89119
1998 22991
1997 19444
1996 19442
1995 11783