Construction Producer Prices Or Costs, New Residential Buildings - Quarterly Data
Eurostat code: sts_copi_q ยท (1953-Q4 - 2025-Q3)
@eurostat.sts_copi_q
Eurostat code: sts_copi_q ยท (1953-Q4 - 2025-Q3)
@eurostat.sts_copi_q
This Eurostat dataset contains data on construction producer prices or costs, new residential buildings - quarterly data, as collected and published by the Statistical Office of the European Union.
raw
: Original table as downloaded from Eurostat.tidy
: A cleaned and transformed version of the raw
table, where time period values appear as rows instead of columns (unpivoted format).Last updated: 2025-10-16T11:00:00+0200
CREATE TABLE raw (
"freq" VARCHAR,
"indic_bt" VARCHAR,
"cpa2_1" VARCHAR,
"s_adj" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"n_1953_q4" DOUBLE -- 1953-Q4,
"n_1954_q1" DOUBLE -- 1954-Q1,
"n_1954_q2" DOUBLE -- 1954-Q2,
"n_1954_q3" DOUBLE -- 1954-Q3,
"n_1954_q4" DOUBLE -- 1954-Q4,
"n_1955_q1" DOUBLE -- 1955-Q1,
"n_1955_q2" DOUBLE -- 1955-Q2,
"n_1955_q3" DOUBLE -- 1955-Q3,
"n_1955_q4" DOUBLE -- 1955-Q4,
"n_1956_q1" DOUBLE -- 1956-Q1,
"n_1956_q2" DOUBLE -- 1956-Q2,
"n_1956_q3" DOUBLE -- 1956-Q3,
"n_1956_q4" DOUBLE -- 1956-Q4,
"n_1957_q1" DOUBLE -- 1957-Q1,
"n_1957_q2" DOUBLE -- 1957-Q2,
"n_1957_q3" DOUBLE -- 1957-Q3,
"n_1957_q4" DOUBLE -- 1957-Q4,
"n_1958_q1" DOUBLE -- 1958-Q1,
"n_1958_q2" DOUBLE -- 1958-Q2,
"n_1958_q3" DOUBLE -- 1958-Q3,
"n_1958_q4" DOUBLE -- 1958-Q4,
"n_1959_q1" DOUBLE -- 1959-Q1,
"n_1959_q2" DOUBLE -- 1959-Q2,
"n_1959_q3" DOUBLE -- 1959-Q3,
"n_1959_q4" DOUBLE -- 1959-Q4,
"n_1960_q1" DOUBLE -- 1960-Q1,
"n_1960_q2" DOUBLE -- 1960-Q2,
"n_1960_q3" DOUBLE -- 1960-Q3,
"n_1960_q4" DOUBLE -- 1960-Q4,
"n_1961_q1" DOUBLE -- 1961-Q1,
"n_1961_q2" DOUBLE -- 1961-Q2,
"n_1961_q3" DOUBLE -- 1961-Q3,
"n_1961_q4" DOUBLE -- 1961-Q4,
"n_1962_q1" DOUBLE -- 1962-Q1,
"n_1962_q2" DOUBLE -- 1962-Q2,
"n_1962_q3" DOUBLE -- 1962-Q3,
"n_1962_q4" DOUBLE -- 1962-Q4,
"n_1963_q1" DOUBLE -- 1963-Q1,
"n_1963_q2" DOUBLE -- 1963-Q2,
"n_1963_q3" DOUBLE -- 1963-Q3,
"n_1963_q4" DOUBLE -- 1963-Q4,
"n_1964_q1" DOUBLE -- 1964-Q1,
"n_1964_q2" DOUBLE -- 1964-Q2,
"n_1964_q3" DOUBLE -- 1964-Q3,
"n_1964_q4" DOUBLE -- 1964-Q4,
"n_1965_q1" DOUBLE -- 1965-Q1,
"n_1965_q2" DOUBLE -- 1965-Q2,
"n_1965_q3" DOUBLE -- 1965-Q3,
"n_1965_q4" DOUBLE -- 1965-Q4,
"n_1966_q1" DOUBLE -- 1966-Q1,
"n_1966_q2" DOUBLE -- 1966-Q2,
"n_1966_q3" DOUBLE -- 1966-Q3,
"n_1966_q4" DOUBLE -- 1966-Q4,
"n_1967_q1" DOUBLE -- 1967-Q1,
"n_1967_q2" DOUBLE -- 1967-Q2,
"n_1967_q3" DOUBLE -- 1967-Q3,
"n_1967_q4" DOUBLE -- 1967-Q4,
"n_1968_q1" DOUBLE -- 1968-Q1,
"n_1968_q2" DOUBLE -- 1968-Q2,
"n_1968_q3" DOUBLE -- 1968-Q3,
"n_1968_q4" DOUBLE -- 1968-Q4,
"n_1969_q1" DOUBLE -- 1969-Q1,
"n_1969_q2" DOUBLE -- 1969-Q2,
"n_1969_q3" DOUBLE -- 1969-Q3,
"n_1969_q4" DOUBLE -- 1969-Q4,
"n_1970_q1" DOUBLE -- 1970-Q1,
"n_1970_q2" DOUBLE -- 1970-Q2,
"n_1970_q3" DOUBLE -- 1970-Q3,
"n_1970_q4" DOUBLE -- 1970-Q4,
"n_1971_q1" DOUBLE -- 1971-Q1,
"n_1971_q2" DOUBLE -- 1971-Q2,
"n_1971_q3" DOUBLE -- 1971-Q3,
"n_1971_q4" DOUBLE -- 1971-Q4,
"n_1972_q1" DOUBLE -- 1972-Q1,
"n_1972_q2" DOUBLE -- 1972-Q2,
"n_1972_q3" DOUBLE -- 1972-Q3,
"n_1972_q4" DOUBLE -- 1972-Q4,
"n_1973_q1" DOUBLE -- 1973-Q1,
"n_1973_q2" DOUBLE -- 1973-Q2,
"n_1973_q3" DOUBLE -- 1973-Q3,
"n_1973_q4" DOUBLE -- 1973-Q4,
"n_1974_q1" DOUBLE -- 1974-Q1,
"n_1974_q2" DOUBLE -- 1974-Q2,
"n_1974_q3" DOUBLE -- 1974-Q3,
"n_1974_q4" DOUBLE -- 1974-Q4,
"n_1975_q1" DOUBLE -- 1975-Q1,
"n_1975_q2" DOUBLE -- 1975-Q2,
"n_1975_q3" DOUBLE -- 1975-Q3,
"n_1975_q4" DOUBLE -- 1975-Q4,
"n_1976_q1" DOUBLE -- 1976-Q1,
"n_1976_q2" DOUBLE -- 1976-Q2,
"n_1976_q3" DOUBLE -- 1976-Q3,
"n_1976_q4" DOUBLE -- 1976-Q4,
"n_1977_q1" DOUBLE -- 1977-Q1
);
CREATE TABLE tidy (
"freq" VARCHAR,
"indic_bt" VARCHAR,
"cpa2_1" VARCHAR,
"s_adj" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);
Anyone who has the link will be able to view this.