Use Table At Purchasers' Prices (previous Years Prices)

Eurostat code: naio_10_pyp16 · (1991 - 2023)

@eurostat.naio_10_pyp16

Table List

2 tables(19.92 MB)

Use Table At Purchasers' Prices (previous Years Prices) - Raw

Use Table At Purchasers' Prices (previous Years Prices) - Unpivoted

Use Table At Purchasers' Prices (previous Years Prices) - Unpivoted

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

9.16 MB
2884650 rows
8 columns

freq Freq	unit Unit	stk_flow Stk Flow	ind_use Ind Use	prd_ava Prd Ava	geo Geo	time_period Time Period	value Value
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Value added, gross	Czechia	1991	1384.35
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Products of agriculture, hunting and related services	Czechia	1991	987.91
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Products of forestry, logging and related services	Czechia	1991	2.66
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	1991
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Mining and quarrying	Czechia	1991	25.08
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Food, beverages and tobacco products	Czechia	1991	194.33
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Textiles, wearing apparel, leather and related products	Czechia	1991	2.93
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Wood and of products of wood and cork, except furniture; articles of straw and plaiting materials	Czechia	1991	11.9
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Paper and paper products	Czechia	1991	4.58
Annual	Million euro	Total	Crop and animal production, hunting and related service activities	Printing and recording services	Czechia	1991	0.16


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

Share link

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