EU Inter-country Use Table At Basic Prices (2010-2014)

Eurostat code: naio_10_fcp_u1 · (2010 - 2014)

@eurostat.naio_10_fcp_u1

Table List

2 tables(113.97 MB)

EU Inter-country Use Table At Basic Prices (2010-2014) - Raw

EU Inter-country Use Table At Basic Prices (2010-2014) - Unpivoted

EU Inter-country Use Table At Basic Prices (2010-2014) - Unpivoted

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

58.7 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	2010	22642.44
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Austria	Million euro	Domestic country	2010	3929.181
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Australia	Million euro	Domestic country	2010	18954.028
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Belgium	Million euro	Domestic country	2010	1031.474
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Bulgaria	Million euro	Domestic country	2010	1634.726
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Brazil	Million euro	Domestic country	2010	28365.474
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Canada	Million euro	Domestic country	2010	9793.845
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Switzerland	Million euro	Domestic country	2010	3430.074
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	China	Million euro	Domestic country	2010	263032.806
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Cyprus	Million euro	Domestic country	2010	304.477


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.