Baselight
Sign In

Use Table At Purchasers' Prices

Eurostat code: naio_10_cp16 ยท (1990 - 2023)

@eurostat.naio_10_cp16

Use Table At Purchasers' Prices - Unpivoted
@eurostat.naio_10_cp16.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.

  • 15.53 MB
  • 4665660 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

AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesValue added, grossCzechia199048950
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesOperating surplus and mixed income, grossCzechia199044348
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesOperating surplus and mixed income, netCzechia199039359
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesMixed income, grossCzechia1990
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesProducts of agriculture, hunting and related servicesCzechia199040238
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesProducts of forestry, logging and related servicesCzechia1990105
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesFish and other fishing products; aquaculture products; support services to fishingCzechia1990
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesMining and quarryingCzechia19901203
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesFood, beverages and tobacco productsCzechia19907219
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesTextiles, wearing apparel, leather and related productsCzechia1990181

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.