Construction Index By NACE Rev. 2 Activity - Quarterly Data
Eurostat code: ei_isbu_q ยท (1980-Q1 - 2025-Q1)
@eurostat.ei_isbu_q
Construction Index By NACE Rev. 2 Activity - Quarterly Data - Unpivoted
@eurostat.ei_isbu_q.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.
- 155.75 KB
- 76137 rows
- 8 columns
freqFreq | unitUnit | s_adjS Adj | indicIndic | nace_r2Nace R2 | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|---|
| Quarterly | Index, 2015=100 | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Cost index (input price index) - new residential buildings | Residential buildings, except residences for communities | Spain | 1980-Q1 | 21.4 |
| Quarterly | Index, 2021=100 | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Cost index (input price index) - new residential buildings | Residential buildings, except residences for communities | Spain | 1980-Q1 | 19.1 |
| Quarterly | Index, 2015=100 | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Cost index (input price index) - new residential buildings | Residential buildings, except residences for communities | Spain | 1980-Q2 | 22.3 |
| Quarterly | Index, 2021=100 | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Cost index (input price index) - new residential buildings | Residential buildings, except residences for communities | Spain | 1980-Q2 | 19.8 |
| Quarterly | Index, 2015=100 | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Cost index (input price index) - new residential buildings | Residential buildings, except residences for communities | Spain | 1980-Q3 | 22.8 |
| Quarterly | Index, 2021=100 | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Cost index (input price index) - new residential buildings | Residential buildings, except residences for communities | Spain | 1980-Q3 | 20.3 |
| Quarterly | Index, 2015=100 | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Cost index (input price index) - new residential buildings | Residential buildings, except residences for communities | Spain | 1980-Q4 | 23.2 |
| Quarterly | Index, 2021=100 | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Cost index (input price index) - new residential buildings | Residential buildings, except residences for communities | Spain | 1980-Q4 | 20.7 |
| Quarterly | Index, 2015=100 | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Cost index (input price index) - new residential buildings | Residential buildings, except residences for communities | Spain | 1981-Q1 | 24.5 |
| Quarterly | Index, 2021=100 | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Cost index (input price index) - new residential buildings | Residential buildings, except residences for communities | Spain | 1981-Q1 | 21.8 |
CREATE TABLE tidy (
"freq" VARCHAR,
"unit" VARCHAR,
"s_adj" VARCHAR,
"indic" VARCHAR,
"nace_r2" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);