Baselight

General Government Expenditure By Function (COFOG)

Eurostat code: gov_10a_exp$dv_578

@eurostat.gov_10a_exp_dv_578

General Government Expenditure By Function (COFOG) - Unpivoted
@eurostat.gov_10a_exp_dv_578.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.

  • 44.67 KB
  • 13200 rows
  • 8 columns
freq

Freq

unit

Unit

sector

Sector

cofog99

Cofog99

na_item

Na Item

geo

Geo

time_period

Time Period

value

Value

AnnualMillion euroGeneral governmentCultural servicesTotal general government expenditureAustria20141890.5
AnnualMillion euroGeneral governmentCultural servicesTotal general government expenditureBelgium20142000.9
AnnualMillion euroGeneral governmentCultural servicesTotal general government expenditureBulgaria2014263.8
AnnualMillion euroGeneral governmentCultural servicesTotal general government expenditureSwitzerland20142224.8
AnnualMillion euroGeneral governmentCultural servicesTotal general government expenditureCyprus201443.6
AnnualMillion euroGeneral governmentCultural servicesTotal general government expenditureCzechia2014908.4
AnnualMillion euroGeneral governmentCultural servicesTotal general government expenditureGermany201411458
AnnualMillion euroGeneral governmentCultural servicesTotal general government expenditureDenmark20141819.5
AnnualMillion euroGeneral governmentCultural servicesTotal general government expenditureEuro area - 19 countries (2015-2022)201448442.3
AnnualMillion euroGeneral governmentCultural servicesTotal general government expenditureEuro area – 20 countries (from 2023)201448764.5

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.