Baselight

EU27 (from 2020) International Trade - Monthly Data

Eurostat code: ei_eteu27_2020_m · (2002-01 - 2025-01)

@eurostat.ei_eteu27_2020_m

EU27 (from 2020) International Trade - Monthly Data - Unpivoted
@eurostat.ei_eteu27_2020_m.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
  • 6083928 rows
  • 8 columns
freq

Freq

stk_flow

Stk Flow

unit

Unit

partner

Partner

indic

Indic

geo

Geo

time_period

Time Period

value

Value

MonthlyBalance for values/ratio for indicesVolume index (2021=100) - not seasonally adjustedEuro area – 20 countries (from 2023)Capital goodsAustria2002-01102.3
MonthlyBalance for values/ratio for indicesVolume index (2021=100) - not seasonally adjustedEuro area – 20 countries (from 2023)Capital goodsBelgium2002-01107.2
MonthlyBalance for values/ratio for indicesVolume index (2021=100) - not seasonally adjustedEuro area – 20 countries (from 2023)Capital goodsBulgaria2002-0126.5
MonthlyBalance for values/ratio for indicesVolume index (2021=100) - not seasonally adjustedEuro area – 20 countries (from 2023)Capital goodsCyprus2002-0111.2
MonthlyBalance for values/ratio for indicesVolume index (2021=100) - not seasonally adjustedEuro area – 20 countries (from 2023)Capital goodsCzechia2002-0147.2
MonthlyBalance for values/ratio for indicesVolume index (2021=100) - not seasonally adjustedEuro area – 20 countries (from 2023)Capital goodsGermany2002-01161.1
MonthlyBalance for values/ratio for indicesVolume index (2021=100) - not seasonally adjustedEuro area – 20 countries (from 2023)Capital goodsDenmark2002-01154.4
MonthlyBalance for values/ratio for indicesVolume index (2021=100) - not seasonally adjustedEuro area – 20 countries (from 2023)Capital goodsEstonia2002-0155.5
MonthlyBalance for values/ratio for indicesVolume index (2021=100) - not seasonally adjustedEuro area – 20 countries (from 2023)Capital goodsGreece2002-0123.6
MonthlyBalance for values/ratio for indicesVolume index (2021=100) - not seasonally adjustedEuro area – 20 countries (from 2023)Capital goodsSpain2002-0153.9

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

Share link

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