Baselight

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

Eurostat code: naio_10_pyp1700 ยท (2011 - 2021)

@eurostat.naio_10_pyp1700

Symmetric Input-output Table At Basic Prices (product By Product) (previous Years Prices) - Unpivoted
@eurostat.naio_10_pyp1700.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.5 MB
  • 597058 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 euroTotalProducts of agriculture, hunting and related servicesValue added, grossFrance201126283.6
AnnualMillion euroTotalProducts of agriculture, hunting and related servicesProducts of agriculture, hunting and related servicesFrance201110675.28
AnnualMillion euroTotalProducts of agriculture, hunting and related servicesProducts of forestry, logging and related servicesFrance2011
AnnualMillion euroTotalProducts of agriculture, hunting and related servicesFish and other fishing products; aquaculture products; support services to fishingFrance2011
AnnualMillion euroTotalProducts of agriculture, hunting and related servicesMining and quarryingFrance2011109.37
AnnualMillion euroTotalProducts of agriculture, hunting and related servicesFood, beverages and tobacco productsFrance20115112.29
AnnualMillion euroTotalProducts of agriculture, hunting and related servicesTextiles, wearing apparel, leather and related productsFrance2011137.71
AnnualMillion euroTotalProducts of agriculture, hunting and related servicesWood and of products of wood and cork, except furniture; articles of straw and plaiting materialsFrance2011483.36
AnnualMillion euroTotalProducts of agriculture, hunting and related servicesPaper and paper productsFrance2011130.64
AnnualMillion euroTotalProducts of agriculture, hunting and related servicesPrinting and recording servicesFrance20110.14

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.