Baselight

Gross Value Added - NACE Rev. 2: A - Current Prices

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

@eurostat.teina404_r2

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

  • 11.43 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, grossAgriculture, forestry and fishingMillion euro (NSA)Albania2022-Q1737.2
QuarterlyValue added, grossAgriculture, forestry and fishingMillion euro (NSA)Austria2022-Q11122.7
QuarterlyValue added, grossAgriculture, forestry and fishingMillion euro (NSA)Bosnia and Herzegovina2022-Q1188
QuarterlyValue added, grossAgriculture, forestry and fishingMillion euro (NSA)Belgium2022-Q1795.8
QuarterlyValue added, grossAgriculture, forestry and fishingMillion euro (NSA)Bulgaria2022-Q1348
QuarterlyValue added, grossAgriculture, forestry and fishingMillion euro (NSA)Switzerland2022-Q11144.2
QuarterlyValue added, grossAgriculture, forestry and fishingMillion euro (NSA)Cyprus2022-Q190
QuarterlyValue added, grossAgriculture, forestry and fishingMillion euro (NSA)Czechia2022-Q1988.9
QuarterlyValue added, grossAgriculture, forestry and fishingMillion euro (NSA)Germany2022-Q18640
QuarterlyValue added, grossAgriculture, forestry and fishingMillion euro (NSA)Denmark2022-Q1562.1

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.