Table Of Trade And Transport Margins (previous Years Prices)

Eurostat code: naio_10_pyp1620 · (1993 - 2023)

@eurostat.naio_10_pyp1620

Table List

2 tables(3.55 MB)

Table Of Trade And Transport Margins (previous Years Prices) - Raw

Table Of Trade And Transport Margins (previous Years Prices) - Unpivoted

Table Of Trade And Transport Margins (previous Years Prices) - Unpivoted

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

1.51 MB
1077594 rows
8 columns

freq Freq	unit Unit	stk_flow Stk Flow	ind_use Ind Use	cpa2_1 Cpa2–1	geo Geo	time_period Time Period	value Value
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Products of agriculture, hunting and related services	Czechia	1993	36.99
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Products of forestry, logging and related services	Czechia	1993
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Fish and other fishing products; aquaculture products; support services to fishing	Czechia	1993
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Mining and quarrying	Czechia	1993	1.2
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Food products; beverages; tobacco products	Czechia	1993	71.97
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Textiles; wearing apparel; leather and related products	Czechia	1993	0.44
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Wood and products of wood and cork, except furniture; articles of straw and plaiting materials	Czechia	1993	1.43
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Paper and paper products	Czechia	1993	0.47
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Printing and reproduction services of recorded media	Czechia	1993	0.03
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Coke and refined petroleum products	Czechia	1993	9.95


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "stk_flow" VARCHAR,
  "ind_use" VARCHAR,
  "cpa2_1" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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