Baselight
Sign In

Gross Value Added - NACE Rev. 2: O-Q - Volumes

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

@eurostat.teina442_r2

Gross Value Added - NACE Rev. 2: O-Q - Volumes - Unpivoted
@eurostat.teina442_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.

  • 8.38 KB
  • 1320 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, grossPublic administration, defence, education, human health and social work activitiesPercentage change q/q-1 (SCA)Albania2022-Q13.5
QuarterlyValue added, grossPublic administration, defence, education, human health and social work activitiesPercentage change q/q-1 (SCA)Austria2022-Q10.1
QuarterlyValue added, grossPublic administration, defence, education, human health and social work activitiesPercentage change q/q-1 (SCA)Belgium2022-Q11
QuarterlyValue added, grossPublic administration, defence, education, human health and social work activitiesPercentage change q/q-1 (SCA)Bulgaria2022-Q12.9
QuarterlyValue added, grossPublic administration, defence, education, human health and social work activitiesPercentage change q/q-1 (SCA)Switzerland2022-Q10.8
QuarterlyValue added, grossPublic administration, defence, education, human health and social work activitiesPercentage change q/q-1 (SCA)Cyprus2022-Q12
QuarterlyValue added, grossPublic administration, defence, education, human health and social work activitiesPercentage change q/q-1 (SCA)Czechia2022-Q1-0.2
QuarterlyValue added, grossPublic administration, defence, education, human health and social work activitiesPercentage change q/q-1 (SCA)Germany2022-Q13.1
QuarterlyValue added, grossPublic administration, defence, education, human health and social work activitiesPercentage change q/q-1 (SCA)Denmark2022-Q1-2
QuarterlyValue added, grossPublic administration, defence, education, human health and social work activitiesPercentage change q/q-1 (SCA)Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)2022-Q11.4

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.