Baselight

Symmetric Input-output Table At Basic Prices (industry By Industry)

Eurostat code: naio_10_cp1750 ยท (1990 - 2022)

@eurostat.naio_10_cp1750

Symmetric Input-output Table At Basic Prices (industry By Industry) - Unpivoted
@eurostat.naio_10_cp1750.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.

  • 13.8 MB
  • 3664072 rows
  • 8 columns
freq

Freq

unit

Unit

ind_ava

Ind Ava

ind_use

Ind Use

stk_flow

Stk Flow

geo

Geo

time_period

Time Period

value

Value

AnnualMillion units of national currencyCrop and animal production, hunting and related service activitiesCrop and animal production, hunting and related service activitiesDomesticCzechia199035716
AnnualMillion units of national currencyCrop and animal production, hunting and related service activitiesCrop and animal production, hunting and related service activitiesImportsCzechia19902886
AnnualMillion units of national currencyCrop and animal production, hunting and related service activitiesCrop and animal production, hunting and related service activitiesTotalCzechia199038602
AnnualMillion units of national currencyCrop and animal production, hunting and related service activitiesForestry and loggingDomesticCzechia1990714
AnnualMillion units of national currencyCrop and animal production, hunting and related service activitiesForestry and loggingImportsCzechia199056
AnnualMillion units of national currencyCrop and animal production, hunting and related service activitiesForestry and loggingTotalCzechia1990770
AnnualMillion units of national currencyCrop and animal production, hunting and related service activitiesFishing and aquacultureDomesticCzechia1990152
AnnualMillion units of national currencyCrop and animal production, hunting and related service activitiesFishing and aquacultureImportsCzechia199013
AnnualMillion units of national currencyCrop and animal production, hunting and related service activitiesFishing and aquacultureTotalCzechia1990165
AnnualMillion units of national currencyCrop and animal production, hunting and related service activitiesMining and quarryingDomesticCzechia1990308

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

Share link

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