Dataset: Annual Financial Accounts For General Government

About this Dataset

Annual Financial Accounts For General Government

This Eurostat dataset contains data on annual financial accounts for general government, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-04-23T23:00:00+0200

Tables

Annual Financial Accounts For General Government - Raw

@eurostat.gov_10a_ggfa.raw

3.28 MB
91392 rows
39 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "na_item" VARCHAR,
  "sector2" VARCHAR,
  "finpos" VARCHAR,
  "stk_flow" VARCHAR,
  "sector" VARCHAR,
  "co_nco" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);

Annual Financial Accounts For General Government - Unpivoted

@eurostat.gov_10a_ggfa.tidy

3.34 MB
1775024 rows
11 columns


CREATE TABLE tidy (
  "freq" VARCHAR,
  "na_item" VARCHAR,
  "sector2" VARCHAR,
  "finpos" VARCHAR,
  "stk_flow" VARCHAR,
  "sector" VARCHAR,
  "co_nco" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);