Quarterly Non-financial Accounts For General Government

Eurostat code: gov_10q_ggnfa · (1995-Q1 - 2024-Q3)

@eurostat.gov_10q_ggnfa

Table List

2 tables(7.53 MB)

Quarterly Non-financial Accounts For General Government - Raw

Quarterly Non-financial Accounts For General Government - Unpivoted

Quarterly Non-financial Accounts For General Government - Unpivoted

@eurostat.gov_10q_ggnfa.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.6 MB
1191274 rows
8 columns

freq Freq	unit Unit	s_adj S Adj	sector Sector	na_item Na Item	geo Geo	time_period Time Period	value Value
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	General government	Value added, gross	Belgium	1995-Q1	7515.8
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	General government	Value added, gross	Spain	1995-Q1	13831.8
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	General government	Value added, gross	France	1995-Q1	52244.5
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	General government	Value added, gross	Romania	1995-Q1	382.7
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	General government	Value added, gross	Sweden	1995-Q1	9923.2
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	General government	Saving, gross	Belgium	1995-Q1	-3508.7
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	General government	Saving, gross	Cyprus	1995-Q1	72.7
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	General government	Saving, gross	Spain	1995-Q1	-3379.6
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	General government	Saving, gross	France	1995-Q1	-4092.2
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	General government	Saving, gross	Romania	1995-Q1	326.9


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "s_adj" 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.