Baselight
Sign In

Table Of Trade And Transport Margins

Eurostat code: naio_10_cp1620 · (1990 - 2023)

@eurostat.naio_10_cp1620

Table Of Trade And Transport Margins - Unpivoted
@eurostat.naio_10_cp1620.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.

  • 3.52 MB
  • 2345527 rows
  • 8 columns
freq

Freq

unit

Unit

stk_flow

Stk Flow

ind_use

Ind Use

cpa2_1

Cpa2–1

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 servicesCzechia19903269
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesProducts of forestry, logging and related servicesCzechia1990
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 quarryingCzechia1990138
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesFood products; beverages; tobacco productsCzechia1990705
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesTextiles; wearing apparel; leather and related productsCzechia199015
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesWood and products of wood and cork, except furniture; articles of straw and plaiting materialsCzechia199079
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesPaper and paper productsCzechia199021
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesPrinting and reproduction services of recorded mediaCzechia19902
AnnualMillion units of national currencyTotalCrop and animal production, hunting and related service activitiesCoke and refined petroleum productsCzechia1990744

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

Share link

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