Baselight

Supply Table At Basic Prices Incl. Transformation Into Purchasers' Prices

Eurostat code: naio_10_cp15 ยท (1990 - 2023)

@eurostat.naio_10_cp15

Supply Table At Basic Prices Incl. Transformation Into Purchasers' Prices - Unpivoted
@eurostat.naio_10_cp15.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.

  • 10.46 MB
  • 4246332 rows
  • 8 columns
freq

Freq

unit

Unit

stk_flow

Stk Flow

ind_impv

Ind Impv

prd_amo

Prd Amo

geo

Geo

time_period

Time Period

value

Value

AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesProducts of agriculture, hunting and related servicesCzechia1990115781
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesProducts of forestry, logging and related servicesCzechia199054
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesFish and other fishing products; aquaculture products; support services to fishingCzechia199055
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesMining and quarryingCzechia199067
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesFood, beverages and tobacco productsCzechia19902104
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesTextiles, wearing apparel, leather and related productsCzechia1990181
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesWood and of products of wood and cork, except furniture; articles of straw and plaiting materialsCzechia1990625
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesPaper and paper productsCzechia199064
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesPrinting and recording servicesCzechia199044
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesCoke and refined petroleum productsCzechia19907

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

Share link

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