Baselight

Government Revenue, Expenditure And Main Aggregates

Eurostat code: gov_10a_main ยท (1975 - 2023)

@eurostat.gov_10a_main

Government Revenue, Expenditure And Main Aggregates - Unpivoted
@eurostat.gov_10a_main.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.

  • 3.17 MB
  • 1056886 rows
  • 7 columns
freq

Freq

unit

Unit

sector

Sector

na_item

Na Item

geo

Geo

time_period

Time Period

value

Value

AnnualMillion units of national currencyTotal economySubsidies, revenue from the EU institutionsFinland1975
AnnualMillion units of national currencyTotal economyCurrent international cooperation, revenue from the EU institutionsFinland1975
AnnualMillion units of national currencyTotal economyOther current transfers, revenue, from the institutions and bodies of the European UnionFinland1975
AnnualMillion units of national currencyTotal economyCapital transfers, expenditure, to the institutions and bodies of the EUFinland1975
AnnualMillion units of national currencyTotal economyCapital transfers, revenue from the institutions and bodies of the EUFinland1975
AnnualMillion units of national currencyGeneral governmentValue added, grossFinland19752513
AnnualMillion units of national currencyGeneral governmentValue added, netFinland19752181
AnnualMillion units of national currencyGeneral governmentNet operating surplusFinland197515
AnnualMillion units of national currencyGeneral governmentBalance of primary incomes/national income, netFinland19751833
AnnualMillion units of national currencyGeneral governmentDisposable income, netFinland19754706

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

Share link

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