Baselight

EU Inter-country Input-output Table At Basic Prices, Product By Product (2015-2019)

Eurostat code: naio_10_fcp_ip2 ยท (2015 - 2019)

@eurostat.naio_10_fcp_ip2

EU Inter-country Input-output Table At Basic Prices, Product By Product (2015-2019) - Unpivoted
@eurostat.naio_10_fcp_ip2.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.

  • 65.14 MB
  • 46816500 rows
  • 8 columns
freq

Freq

prd_use

Prd Use

prd_ava

Prd Ava

c_dest

C Dest

unit

Unit

c_orig

C Orig

time_period

Time Period

value

Value

AnnualProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossArgentinaMillion euroDomestic country201532441.557
AnnualProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossAustriaMillion euroDomestic country20152885.818
AnnualProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossAustraliaMillion euroDomestic country201521100.897
AnnualProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossBelgiumMillion euroDomestic country20152734.662
AnnualProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossBulgariaMillion euroDomestic country20152077.511
AnnualProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossBrazilMillion euroDomestic country201532984.924
AnnualProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossCanadaMillion euroDomestic country201514248.948
AnnualProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossSwitzerlandMillion euroDomestic country20154067.437
AnnualProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossChinaMillion euroDomestic country2015498720.178
AnnualProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossCyprusMillion euroDomestic country2015256.639

CREATE TABLE tidy (
  "freq" VARCHAR,
  "prd_use" VARCHAR,
  "prd_ava" VARCHAR,
  "c_dest" VARCHAR,
  "unit" VARCHAR,
  "c_orig" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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