Gross Value Added - NACE Rev. 2: F - Volumes
Eurostat code: teina418_r2 ยท (2022-Q2 - 2025-Q1)
@eurostat.teina418_r2
Table List
- 2 tables(25.91 KB)
Gross Value Added - NACE Rev. 2: F - Volumes - Unpivoted
@eurostat.teina418_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.55 KB
- 1221 rows
- 7 columns
freqFreq | na_itemNa Item | nace_r2Nace R2 | unitUnit | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|
| Quarterly | Value added, gross | Construction | Percentage change q/q-1 (SCA) | Albania | 2022-Q2 | -8.5 |
| Quarterly | Value added, gross | Construction | Percentage change q/q-1 (SCA) | Austria | 2022-Q2 | -1.3 |
| Quarterly | Value added, gross | Construction | Percentage change q/q-1 (SCA) | Belgium | 2022-Q2 | -0.9 |
| Quarterly | Value added, gross | Construction | Percentage change q/q-1 (SCA) | Bulgaria | 2022-Q2 | 1.4 |
| Quarterly | Value added, gross | Construction | Percentage change q/q-1 (SCA) | Switzerland | 2022-Q2 | -1.7 |
| Quarterly | Value added, gross | Construction | Percentage change q/q-1 (SCA) | Cyprus | 2022-Q2 | -2.3 |
| Quarterly | Value added, gross | Construction | Percentage change q/q-1 (SCA) | Czechia | 2022-Q2 | -2.5 |
| Quarterly | Value added, gross | Construction | Percentage change q/q-1 (SCA) | Germany | 2022-Q2 | -3.6 |
| Quarterly | Value added, gross | Construction | Percentage change q/q-1 (SCA) | Denmark | 2022-Q2 | 0.4 |
| Quarterly | Value added, gross | Construction | Percentage 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-Q2 | -0.7 |
CREATE TABLE tidy (
"freq" VARCHAR,
"na_item" VARCHAR,
"nace_r2" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);