Construction - Quarterly Data

Eurostat code: ei_bsbu_q_r2 · (1981-Q1 - 2024-Q2)

@eurostat.ei_bsbu_q_r2

Table List

2 tables(159.3 KB)

Construction - Quarterly Data - Raw

Construction - Quarterly Data - Unpivoted

Construction - Quarterly Data - Raw

@eurostat.ei_bsbu_q_r2.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

143.1 KB
70 rows
179 columns
Only the first 100 columns are shown

freq Freq	indic Indic	s_adj S Adj	unit Unit	geo Geo	n_1981_q1 1981-Q1	n_1981_q2 1981-Q2	n_1981_q3 1981-Q3	n_1981_q4 1981-Q4	n_1982_q1 1982-Q1	n_1982_q2 1982-Q2	n_1982_q3 1982-Q3	n_1982_q4 1982-Q4	n_1983_q1 1983-Q1	n_1983_q2 1983-Q2	n_1983_q3 1983-Q3	n_1983_q4 1983-Q4	n_1984_q1 1984-Q1	n_1984_q2 1984-Q2	n_1984_q3 1984-Q3	n_1984_q4 1984-Q4	n_1985_q1 1985-Q1	n_1985_q2 1985-Q2	n_1985_q3 1985-Q3	n_1985_q4 1985-Q4	n_1986_q1 1986-Q1	n_1986_q2 1986-Q2	n_1986_q3 1986-Q3	n_1986_q4 1986-Q4	n_1987_q1 1987-Q1	n_1987_q2 1987-Q2	n_1987_q3 1987-Q3	n_1987_q4 1987-Q4	n_1988_q1 1988-Q1	n_1988_q2 1988-Q2	n_1988_q3 1988-Q3	n_1988_q4 1988-Q4	n_1989_q1 1989-Q1	n_1989_q2 1989-Q2	n_1989_q3 1989-Q3	n_1989_q4 1989-Q4	n_1990_q1 1990-Q1	n_1990_q2 1990-Q2	n_1990_q3 1990-Q3	n_1990_q4 1990-Q4	n_1991_q1 1991-Q1	n_1991_q2 1991-Q2	n_1991_q3 1991-Q3	n_1991_q4 1991-Q4	n_1992_q1 1992-Q1	n_1992_q2 1992-Q2	n_1992_q3 1992-Q3	n_1992_q4 1992-Q4	n_1993_q1 1993-Q1	n_1993_q2 1993-Q2	n_1993_q3 1993-Q3	n_1993_q4 1993-Q4	n_1994_q1 1994-Q1	n_1994_q2 1994-Q2	n_1994_q3 1994-Q3	n_1994_q4 1994-Q4	n_1995_q1 1995-Q1	n_1995_q2 1995-Q2	n_1995_q3 1995-Q3	n_1995_q4 1995-Q4	n_1996_q1 1996-Q1	n_1996_q2 1996-Q2	n_1996_q3 1996-Q3	n_1996_q4 1996-Q4	n_1997_q1 1997-Q1	n_1997_q2 1997-Q2	n_1997_q3 1997-Q3	n_1997_q4 1997-Q4	n_1998_q1 1998-Q1	n_1998_q2 1998-Q2	n_1998_q3 1998-Q3	n_1998_q4 1998-Q4	n_1999_q1 1999-Q1	n_1999_q2 1999-Q2	n_1999_q3 1999-Q3	n_1999_q4 1999-Q4	n_2000_q1 2000-Q1	n_2000_q2 2000-Q2	n_2000_q3 2000-Q3	n_2000_q4 2000-Q4	n_2001_q1 2001-Q1	n_2001_q2 2001-Q2	n_2001_q3 2001-Q3	n_2001_q4 2001-Q4	n_2002_q1 2002-Q1	n_2002_q2 2002-Q2	n_2002_q3 2002-Q3	n_2002_q4 2002-Q4	n_2003_q1 2003-Q1	n_2003_q2 2003-Q2	n_2003_q3 2003-Q3	n_2003_q4 2003-Q4	n_2004_q1 2004-Q1	n_2004_q2 2004-Q2	n_2004_q3 2004-Q3
Quarterly	Operating time ensured by current backlog, months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Albania
Quarterly	Operating time ensured by current backlog, months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Austria																																																													5.4	5.3	5.6	4.7	8	5.6	5.1	4.3	4.1	4.6	4.9	4.7	4.1	5.9	4.9	4.1	5.2	4.6	4.1	4	4.6	5.2	6.2	6	3.8	3.9	3.8	4.1	4.3	6	5	4.3	4.5	4.3	4.4
Quarterly	Operating time ensured by current backlog, months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Belgium																																			4.7	4.8	4.8	5	4.9	4.8	4.7	7.1	7	6.9	6.7	6.8	6.6	6.5	6.5	6.6	6.5	6.2	6.3	6.7	6.8	6.5	6.7	6.7	6.4	6	5.9	6	6.3	6.3	6.6	5.6	5.4	5.3	5.4	5.6	5.6	5.6	5.7	6.1	6.1	6	5.9	6.2	6.2	6	6	6	5.9	5.7	5.4	5.5	5.5	5.4	5.2	5.4	5.4	5.3	5.4	5.5	5.8
Quarterly	Operating time ensured by current backlog, months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Bulgaria																																																				4.9	4.9	4.7	4.2	4	4.2	4.5	4.5	4.1	4.5	4.7	4.6	3.4	3.9	5.4	4.1	3.6	3.8	4	3.3	3.2	3.2	3.3	3.5	3	4	3.7	3.5	3.7	8.1	7.8	5.7	8.5	7.9	8.7	4.6	5.1	5.2	5.7	6.8	5.1	4.7	7.2	6.3
Quarterly	Operating time ensured by current backlog, months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Cyprus
Quarterly	Operating time ensured by current backlog, months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Czechia																																																																																7.8	7.8	8.8	7.8	7.8	7.8	9.8	8.8	8.8	7.4	8.2	8.3	8.2	7.6	7.8	8.7
Quarterly	Operating time ensured by current backlog, months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Germany	2.6	2.8	2.6	2.3	2	2.2	2.3	2	1.9	2.5	2.6	2.6	2.3	2.2	2.2	2	1.6	1.9	2.2	2.2	1.9	2.2		2.4	1.9	2.2	2.4	2.3	1.9	2.4	2.5	2.5	2.2	2.5	2.8	2.9	2.6	3	3.2	3.1	2.6	2.9	2.9	2.8	2.7	2.8	2.9	2.6	2.5	2.7	2.8	2.7	2.6	2.9	3	2.9	2.5	2.7	2.7	2.5	2.2	2.6	2.6	2.4	2.2	2.5	2.4	2.3	2.1	2.5	2.6	2.5	2.4	2.8	2.8	2.5	2.2	2.4	2.5	2.2	2	2.4	2.6	2.2	2.2	2.3	2.2	2	1.8	2.2	2.3	2.2	2	2.2	2.2
Quarterly	Operating time ensured by current backlog, months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Denmark																																																																					1.6	2.7	3.8	4.9	4.5	5.4	5.2			5.5	5.1	4.7	5.4	5.6	4.9	4.9	4.6	4.9	4.8	4.2	4.3	4.6	4.7	4.1	4.4	5.2	5.5
Quarterly	Operating time ensured by current backlog, months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Euro area – 20 countries (from 2023)	4.4	4.4	4.3	4	4.5	3.8	4.7	3.8	3.4	3.5	3.1	3.3	3.2	3.6	4.2	3.8	3.1	3.7		3.8	3.3	3.8	2.5	3.6	3.2	3.9	3.4	2.8	2.5	4.2	3.8	3.3	5	5.2	5.3	5.1	5.1	5.5	5.5	5.6	4.8	5.2	5.2	4.5	4.9	5.2	4.9	4.4	3.1	4.3	4.9	4.9	4.1	4.1	5.5	4.7	4.6	5	5	6.6	5.1	5.5	5.7	5.1	4.8	5.1	7.2	6.2	6	7	7.3	7.1	7.2	7.1	6.8	6.8	7.4	7.5	7.5	6.8	7.3	8.8	7.6	7.8	7.6	7.9	7.2	7.2	7.8	8	7.8	7.5	7.5	8.2	7.6
Quarterly	Operating time ensured by current backlog, months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Estonia																																																																																3.5	2.6	2.4					3.5	2.8	2.4	2.7	3.5	3.6	2.8	3.6	3.5


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic" VARCHAR,
  "s_adj" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1981_q1" DOUBLE,
  "n_1981_q2" DOUBLE,
  "n_1981_q3" DOUBLE,
  "n_1981_q4" DOUBLE,
  "n_1982_q1" DOUBLE,
  "n_1982_q2" DOUBLE,
  "n_1982_q3" DOUBLE,
  "n_1982_q4" DOUBLE,
  "n_1983_q1" DOUBLE,
  "n_1983_q2" DOUBLE,
  "n_1983_q3" DOUBLE,
  "n_1983_q4" DOUBLE,
  "n_1984_q1" DOUBLE,
  "n_1984_q2" DOUBLE,
  "n_1984_q3" DOUBLE,
  "n_1984_q4" DOUBLE,
  "n_1985_q1" DOUBLE,
  "n_1985_q2" DOUBLE,
  "n_1985_q3" DOUBLE,
  "n_1985_q4" DOUBLE,
  "n_1986_q1" DOUBLE,
  "n_1986_q2" DOUBLE,
  "n_1986_q3" DOUBLE,
  "n_1986_q4" DOUBLE,
  "n_1987_q1" DOUBLE,
  "n_1987_q2" DOUBLE,
  "n_1987_q3" DOUBLE,
  "n_1987_q4" DOUBLE,
  "n_1988_q1" DOUBLE,
  "n_1988_q2" DOUBLE,
  "n_1988_q3" DOUBLE,
  "n_1988_q4" DOUBLE,
  "n_1989_q1" DOUBLE,
  "n_1989_q2" DOUBLE,
  "n_1989_q3" DOUBLE,
  "n_1989_q4" DOUBLE,
  "n_1990_q1" DOUBLE,
  "n_1990_q2" DOUBLE,
  "n_1990_q3" DOUBLE,
  "n_1990_q4" DOUBLE,
  "n_1991_q1" DOUBLE,
  "n_1991_q2" DOUBLE,
  "n_1991_q3" DOUBLE,
  "n_1991_q4" DOUBLE,
  "n_1992_q1" DOUBLE,
  "n_1992_q2" DOUBLE,
  "n_1992_q3" DOUBLE,
  "n_1992_q4" DOUBLE,
  "n_1993_q1" DOUBLE,
  "n_1993_q2" DOUBLE,
  "n_1993_q3" DOUBLE,
  "n_1993_q4" DOUBLE,
  "n_1994_q1" DOUBLE,
  "n_1994_q2" DOUBLE,
  "n_1994_q3" DOUBLE,
  "n_1994_q4" DOUBLE,
  "n_1995_q1" DOUBLE,
  "n_1995_q2" DOUBLE,
  "n_1995_q3" DOUBLE,
  "n_1995_q4" DOUBLE,
  "n_1996_q1" DOUBLE,
  "n_1996_q2" DOUBLE,
  "n_1996_q3" DOUBLE,
  "n_1996_q4" DOUBLE,
  "n_1997_q1" DOUBLE,
  "n_1997_q2" DOUBLE,
  "n_1997_q3" DOUBLE,
  "n_1997_q4" DOUBLE,
  "n_1998_q1" DOUBLE,
  "n_1998_q2" DOUBLE,
  "n_1998_q3" DOUBLE,
  "n_1998_q4" DOUBLE,
  "n_1999_q1" DOUBLE,
  "n_1999_q2" DOUBLE,
  "n_1999_q3" DOUBLE,
  "n_1999_q4" DOUBLE,
  "n_2000_q1" DOUBLE,
  "n_2000_q2" DOUBLE,
  "n_2000_q3" DOUBLE,
  "n_2000_q4" DOUBLE,
  "n_2001_q1" DOUBLE,
  "n_2001_q2" DOUBLE,
  "n_2001_q3" DOUBLE,
  "n_2001_q4" DOUBLE,
  "n_2002_q1" DOUBLE,
  "n_2002_q2" DOUBLE,
  "n_2002_q3" DOUBLE,
  "n_2002_q4" DOUBLE,
  "n_2003_q1" DOUBLE,
  "n_2003_q2" DOUBLE,
  "n_2003_q3" DOUBLE,
  "n_2003_q4" DOUBLE,
  "n_2004_q1" DOUBLE,
  "n_2004_q2" DOUBLE,
  "n_2004_q3" DOUBLE
);