Baselight

Symmetric Input-output Table At Basic Prices (product By Product)

Eurostat code: naio_10_cp1700 ยท (1990 - 2022)

@eurostat.naio_10_cp1700

Symmetric Input-output Table At Basic Prices (product By Product) - Unpivoted
@eurostat.naio_10_cp1700.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.

  • 25.45 MB
  • 6870212 rows
  • 8 columns
freq

Freq

unit

Unit

stk_flow

Stk Flow

prd_use

Prd Use

prd_ava

Prd Ava

geo

Geo

time_period

Time Period

value

Value

AnnualMillion units of national currencyDomesticProducts of agriculture, hunting and related servicesValue added, grossCzechia199047109
AnnualMillion units of national currencyDomesticProducts of agriculture, hunting and related servicesOperating surplus and mixed income, grossCzechia199047103
AnnualMillion units of national currencyDomesticProducts of agriculture, hunting and related servicesOperating surplus and mixed income, netCzechia199037512
AnnualMillion units of national currencyDomesticProducts of agriculture, hunting and related servicesProducts of agriculture, hunting and related servicesCzechia199032273
AnnualMillion units of national currencyDomesticProducts of agriculture, hunting and related servicesProducts of forestry, logging and related servicesCzechia19901
AnnualMillion units of national currencyDomesticProducts of agriculture, hunting and related servicesFish and other fishing products; aquaculture products; support services to fishingCzechia19903
AnnualMillion units of national currencyDomesticProducts of agriculture, hunting and related servicesMining and quarryingCzechia1990598
AnnualMillion units of national currencyDomesticProducts of agriculture, hunting and related servicesFood, beverages and tobacco productsCzechia19904335
AnnualMillion units of national currencyDomesticProducts of agriculture, hunting and related servicesTextiles, wearing apparel, leather and related productsCzechia199030
AnnualMillion units of national currencyDomesticProducts of agriculture, hunting and related servicesWood and of products of wood and cork, except furniture; articles of straw and plaiting materialsCzechia1990220

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