Baselight

Imports By Industry (FIGARO Application)

Eurostat code: naio_10_fgti ยท (2010 - 2022)

@eurostat.naio_10_fgti

Imports By Industry (FIGARO Application) - Unpivoted
@eurostat.naio_10_fgti.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.

  • 6.31 MB
  • 1425684 rows
  • 7 columns
freq

Freq

nace_r2

Nace R2

c_exp

C Exp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAgriculture, forestry and fishingArgentinaMillion euroAustria20104.011
AnnualAgriculture, forestry and fishingArgentinaMillion euroBelgium201017.056
AnnualAgriculture, forestry and fishingArgentinaMillion euroBulgaria20102.742
AnnualAgriculture, forestry and fishingArgentinaMillion euroCyprus20101.617
AnnualAgriculture, forestry and fishingArgentinaMillion euroCzechia20108.903
AnnualAgriculture, forestry and fishingArgentinaMillion euroGermany201098.542
AnnualAgriculture, forestry and fishingArgentinaMillion euroDenmark20109.06
AnnualAgriculture, forestry and fishingArgentinaMillion euroEstonia20100.379
AnnualAgriculture, forestry and fishingArgentinaMillion euroGreece201016.714
AnnualAgriculture, forestry and fishingArgentinaMillion euroSpain2010104.706

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

Share link

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