EU Inter-country Use Table At Basic Prices (2015-2019)

Eurostat code: naio_10_fcp_u2 · (2015 - 2019)

@eurostat.naio_10_fcp_u2

Table List

2 tables(118.58 MB)

EU Inter-country Use Table At Basic Prices (2015-2019) - Raw

EU Inter-country Use Table At Basic Prices (2015-2019) - Unpivoted

EU Inter-country Use Table At Basic Prices (2015-2019) - Unpivoted

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

60.97 MB
46816500 rows
8 columns

freq Freq	ind_use Ind Use	prd_ava Prd Ava	c_dest C Dest	unit Unit	c_orig C Orig	time_period Time Period	value Value
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Argentina	Million euro	Domestic country	2015	33719.072
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Austria	Million euro	Domestic country	2015	3359.942
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Australia	Million euro	Domestic country	2015	22111.226
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Belgium	Million euro	Domestic country	2015	2761.641
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Bulgaria	Million euro	Domestic country	2015	2233.675
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Brazil	Million euro	Domestic country	2015	34289.268
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Canada	Million euro	Domestic country	2015	14299.767
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Switzerland	Million euro	Domestic country	2015	4026.657
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	China	Million euro	Domestic country	2015	498720.178
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Cyprus	Million euro	Domestic country	2015	271.885


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