EU Inter-country Use Table At Basic Prices (2020 And Onwards)

Eurostat code: naio_10_fcp_u3 · (2020 - 2022)

@eurostat.naio_10_fcp_u3

Table List

2 tables(74.23 MB)

EU Inter-country Use Table At Basic Prices (2020 And Onwards) - Raw

EU Inter-country Use Table At Basic Prices (2020 And Onwards) - Unpivoted

EU Inter-country Use Table At Basic Prices (2020 And Onwards) - Unpivoted

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

37.95 MB
28089900 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	2020	25667.981
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Austria	Million euro	Domestic country	2020	4155.402
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Australia	Million euro	Domestic country	2020	31632.487
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Belgium	Million euro	Domestic country	2020	2733.903
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Bulgaria	Million euro	Domestic country	2020	2510.56
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Brazil	Million euro	Domestic country	2020	34244.868
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Canada	Million euro	Domestic country	2020	15515.135
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Switzerland	Million euro	Domestic country	2020	4278.623
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	China	Million euro	Domestic country	2020	656407.503
Annual	Crop and animal production, hunting and related service activities	Operating surplus and mixed income, gross	Cyprus	Million euro	Domestic country	2020	293.469


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.