Baselight

High-tech Trade By High-tech Group Of Products In Million Euro (from 2007, SITC Rev. 4)

Eurostat code: htec_trd_group4 ยท (2007 - 2022)

@eurostat.htec_trd_group4

High-tech Trade By High-tech Group Of Products In Million Euro (from 2007, SITC Rev. 4) - Unpivoted
@eurostat.htec_trd_group4.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.

  • 220.97 KB
  • 29545 rows
  • 8 columns
freq

Freq

stk_flow

Stk Flow

sitc06

Sitc06

currency

Currency

partner

Partner

geo

Geo

time_period

Time Period

value

Value

AnnualExportsAerospaceMillion euroExtra-EU27 (from 2020)Austria2007310.185
AnnualExportsAerospaceMillion euroExtra-EU27 (from 2020)Belgium2007206.314
AnnualExportsAerospaceMillion euroExtra-EU27 (from 2020)Bulgaria200711.952
AnnualExportsAerospaceMillion euroExtra-EU27 (from 2020)Switzerland2007649.15
AnnualExportsAerospaceMillion euroExtra-EU27 (from 2020)Cyprus20070.014
AnnualExportsAerospaceMillion euroExtra-EU27 (from 2020)Czechia2007500.841
AnnualExportsAerospaceMillion euroExtra-EU27 (from 2020)Germany20078107.96
AnnualExportsAerospaceMillion euroExtra-EU27 (from 2020)Denmark200782.897
AnnualExportsAerospaceMillion euroExtra-EU27 (from 2020)Estonia20072.947
AnnualExportsAerospaceMillion euroExtra-EU27 (from 2020)Greece200728.98

CREATE TABLE tidy (
  "freq" VARCHAR,
  "stk_flow" VARCHAR,
  "sitc06" VARCHAR,
  "currency" VARCHAR,
  "partner" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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