Foreign Value Added In Domestic Final Use (FIGARO Application)

Eurostat code: naio_10_fgfd · (2010 - 2022)

@eurostat.naio_10_fgfd

Table List

2 tables(20.93 MB)

Foreign Value Added In Domestic Final Use (FIGARO Application) - Raw

Foreign Value Added In Domestic Final Use (FIGARO Application) - Unpivoted

Foreign Value Added In Domestic Final Use (FIGARO Application) - Unpivoted

@eurostat.naio_10_fgfd.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.

10.54 MB
1328860 rows
7 columns

freq Freq	nace_r2 Nace R2	c_orig C Orig	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Agriculture, forestry and fishing	Argentina	Thousand euro	Austria	2010	15541.188
Annual	Agriculture, forestry and fishing	Argentina	Thousand euro	Belgium	2010	32781.146
Annual	Agriculture, forestry and fishing	Argentina	Thousand euro	Bulgaria	2010	4435.897
Annual	Agriculture, forestry and fishing	Argentina	Thousand euro	Cyprus	2010	8671.621
Annual	Agriculture, forestry and fishing	Argentina	Thousand euro	Czechia	2010	12271.012
Annual	Agriculture, forestry and fishing	Argentina	Thousand euro	Germany	2010	237422.278
Annual	Agriculture, forestry and fishing	Argentina	Thousand euro	Denmark	2010	43235.846
Annual	Agriculture, forestry and fishing	Argentina	Thousand euro	Estonia	2010	1856.134
Annual	Agriculture, forestry and fishing	Argentina	Thousand euro	Greece	2010	37057.311
Annual	Agriculture, forestry and fishing	Argentina	Thousand euro	Spain	2010	316869.532


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "c_orig" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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