General Government Expenditure By Function (COFOG)

Eurostat code: gov_10a_exp · (1990 - 2023)

@eurostat.gov_10a_exp

Table List

2 tables(49.9 MB)

General Government Expenditure By Function (COFOG) - Raw

General Government Expenditure By Function (COFOG) - Unpivoted

General Government Expenditure By Function (COFOG) - Unpivoted

@eurostat.gov_10a_exp.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

24.61 MB
21149987 rows
8 columns

freq Freq	unit Unit	sector Sector	cofog99 Cofog99	na_item Na Item	geo Geo	time_period Time Period	value Value
Annual	Million euro	General government	General public services	Compensation of employees	Finland	1990	1810.1
Annual	Million euro	General government	General public services	Other taxes on production; current taxes on income, wealth, etc; adjustment for the change in pension entitlements	Finland	1990	7.3
Annual	Million euro	General government	General public services	Subsidies	Finland	1990	19.6
Annual	Million euro	General government	General public services	Property income	Finland	1990	1530.8
Annual	Million euro	General government	General public services	Social benefits other than social transfers in kind	Finland	1990	1.2
Annual	Million euro	General government	General public services	Social benefits other than social transfers in kind and social transfers in kind - purchased market production	Finland	1990	1.2
Annual	Million euro	General government	General public services	Social transfers in kind - purchased market production	Finland	1990
Annual	Million euro	General government	General public services	Other current transfers	Finland	1990	564.6
Annual	Million euro	General government	General public services	Capital transfers	Finland	1990
Annual	Million euro	General government	General public services	Investment grants	Finland	1990


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sector" VARCHAR,
  "cofog99" VARCHAR,
  "na_item" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.