Baselight

Gross Value Added - NACE Rev. 2: G-I - Current Prices

Eurostat code: teina420_r2 ยท (2022-Q1 - 2024-Q4)

@eurostat.teina420_r2

Gross Value Added - NACE Rev. 2: G-I - Current Prices - Unpivoted
@eurostat.teina420_r2.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.

  • 12.24 KB
  • 900 rows
  • 7 columns
freq

Freq

na_item

Na Item

nace_r2

Nace R2

unit

Unit

geo

Geo

time_period

Time Period

value

Value

QuarterlyValue added, grossWholesale and retail trade, transport, accommodation and food service activitiesMillion euro (NSA)Albania2022-Q1623.6
QuarterlyValue added, grossWholesale and retail trade, transport, accommodation and food service activitiesMillion euro (NSA)Austria2022-Q120234.8
QuarterlyValue added, grossWholesale and retail trade, transport, accommodation and food service activitiesMillion euro (NSA)Bosnia and Herzegovina2022-Q11017.8
QuarterlyValue added, grossWholesale and retail trade, transport, accommodation and food service activitiesMillion euro (NSA)Belgium2022-Q123159.3
QuarterlyValue added, grossWholesale and retail trade, transport, accommodation and food service activitiesMillion euro (NSA)Bulgaria2022-Q12683
QuarterlyValue added, grossWholesale and retail trade, transport, accommodation and food service activitiesMillion euro (NSA)Switzerland2022-Q135562.8
QuarterlyValue added, grossWholesale and retail trade, transport, accommodation and food service activitiesMillion euro (NSA)Cyprus2022-Q11306.6
QuarterlyValue added, grossWholesale and retail trade, transport, accommodation and food service activitiesMillion euro (NSA)Czechia2022-Q110138.4
QuarterlyValue added, grossWholesale and retail trade, transport, accommodation and food service activitiesMillion euro (NSA)Germany2022-Q1138399
QuarterlyValue added, grossWholesale and retail trade, transport, accommodation and food service activitiesMillion euro (NSA)Denmark2022-Q119343

CREATE TABLE tidy (
  "freq" VARCHAR,
  "na_item" VARCHAR,
  "nace_r2" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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