House Sales - Value And Index (2015=100), Quarterly Data

Eurostat code: prc_hpi_hsvq · (2006-Q1 - 2024-Q4)

@eurostat.prc_hpi_hsvq

Table List

2 tables(180.54 KB)

House Sales - Value And Index (2015=100), Quarterly Data - Raw

House Sales - Value And Index (2015=100), Quarterly Data - Unpivoted

House Sales - Value And Index (2015=100), Quarterly Data - Raw

@eurostat.prc_hpi_hsvq.raw

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

123.3 KB
250 rows
80 columns

freq Freq	unit Unit	geo Geo	purchase Purchase	n_2010_q1 2010-Q1	n_2010_q2 2010-Q2	n_2010_q3 2010-Q3	n_2010_q4 2010-Q4	n_2011_q1 2011-Q1	n_2011_q2 2011-Q2	n_2011_q3 2011-Q3	n_2011_q4 2011-Q4	n_2012_q1 2012-Q1	n_2012_q2 2012-Q2	n_2012_q3 2012-Q3	n_2012_q4 2012-Q4	n_2013_q1 2013-Q1	n_2013_q2 2013-Q2	n_2013_q3 2013-Q3	n_2013_q4 2013-Q4	n_2014_q1 2014-Q1	n_2014_q2 2014-Q2	n_2014_q3 2014-Q3	n_2014_q4 2014-Q4	n_2015_q1 2015-Q1	n_2015_q2 2015-Q2	n_2015_q3 2015-Q3	n_2015_q4 2015-Q4	n_2016_q1 2016-Q1	n_2016_q2 2016-Q2	n_2016_q3 2016-Q3	n_2016_q4 2016-Q4	n_2017_q1 2017-Q1	n_2017_q2 2017-Q2	n_2017_q3 2017-Q3	n_2017_q4 2017-Q4	n_2018_q1 2018-Q1	n_2018_q2 2018-Q2	n_2018_q3 2018-Q3	n_2018_q4 2018-Q4	n_2019_q1 2019-Q1	n_2019_q2 2019-Q2	n_2019_q3 2019-Q3	n_2019_q4 2019-Q4	n_2020_q1 2020-Q1	n_2020_q2 2020-Q2	n_2020_q3 2020-Q3	n_2020_q4 2020-Q4	n_2021_q1 2021-Q1	n_2021_q2 2021-Q2	n_2021_q3 2021-Q3	n_2021_q4 2021-Q4	n_2022_q1 2022-Q1	n_2022_q2 2022-Q2	n_2022_q3 2022-Q3	n_2022_q4 2022-Q4	n_2023_q1 2023-Q1	n_2023_q2 2023-Q2	n_2023_q3 2023-Q3	n_2023_q4 2023-Q4	n_2024_q1 2024-Q1	n_2024_q2 2024-Q2	n_2024_q3 2024-Q3	n_2024_q4 2024-Q4
Quarterly	Euro	Austria	Purchases of existing dwellings																					1681011507	2215666987	2157440119	2677414251	1689633290	2237518493	2071614277	2348852763	2037833701	2444627165	2252850819	2559686269	2173578404	2511692712	2414843949	2884548877	2338406315	2793118234	2782077402	3166116903	2402275197	2680747483	3388313535	3709081992	3292483679	3836471466	3363892284	4004982163	3414497605	3805982874	3251288228	3075267375	2511840841	2698042276	2569355191	2791319869	2364248371	3359599807	3050074961	3129775285
Quarterly	Euro	Austria	Purchases of newly built dwellings																					783287442	830691305	744817140	872283532	790250556	890502108	853024636	924351179	838060167	956516779	952103238	1000120973	914005330	1046262871	962862836	1148505746	1085058153	1382008983	1370709288	1539835296	1294357901	1432995502	1728916040	2018826035	1811517996	2008634249	1983086278	1795632675	1856736076	1872178014	1407606303	976235070	750679207	750138481	685762332	727992374	608893320	915883393	891988198	808320446
Quarterly	Euro	Austria	Total																					2464298949	3046358291	2902257259	3549697782	2479883846	3128020601	2924638913	3273203941	2875893868	3401143943	3204954056	3559807242	3087583735	3557955584	3377706786	4033054623	3423464468	4175127217	4152786689	4705952199	3696633098	4113742985	5117229575	5727908027	5104001675	5845105716	5346978562	5800614838	5271233681	5678160888	4658894531	4051502444	3262520048	3448180757	3255117523	3519312244	2973141691	4275483200	3942063159	3938095731
Quarterly	Euro	Belgium	Purchases of existing dwellings	4973695281	5528413097	5539786298	5530804741	5488060670	6092867059	6143108700	6812422844	5011627408	6260519555	6253134005	6797442882	5817493314	6223323070	6228531518	5958580948	5327828683	6410507212	6119209431	9549619954	4318725475	5232243100	5537167073	6744400854	5501389329	6901648788	7060525053	7516127294	7230260879	7484639008	7109244273	7830373618	7486007921	7527821969	8206752975	8949681210	7844302249	8780294327	8998642967	13282066888	5773877464	7689616119	8139029168	12121260229	9809127989	11262513386	11431957645	10650916237	12475860532	11531926562	10981714851	11510698393	9830438543	9403929607	9585530747	10876627213	8648280130	9711575996	10696204960	11125618553
Quarterly	Euro	Belgium	Total	4973695281	5528413097	5539786298	5530804741	5488060670	6092867059	6143108700	6812422844	5011627408	6260519555	6253134005	6797442882	5817493314	6223323070	6228531518	5958580948	5327828683	6410507212	6119209431	9549619954	4318725475	5232243100	5537167073	6744400854	5501389329	6901648788	7060525053	7516127294	7230260879	7484639008	7109244273	7830373618	7486007921	7527821969	8206752975	8949681210	7844302249	8780294327	8998642967	13282066888	5773877464	7689616119	8139029168	12121260229	9809127989	11262513386	11431957645	10650916237	12475860532	11531926562	10981714851	11510698393	9830438543	9403929607	9585530747	10876627213	8648280130	9711575996	10696204960	11125618553
Quarterly	Euro	Bulgaria	Purchases of existing dwellings																													233750900	346948965	340264508	408118565	278916940	364137000	387692064	428529108	296796497	405745806	436386769	485302204	317871858	255716783	397582352	464797756	353138619	538106847	618490219	818922027	533294415	746202858	703460683	660358871	536191645	728166408	719712411	866811553	695134121	893690120	897530248	1053653572
Quarterly	Euro	Bulgaria	Purchases of newly built dwellings																													128277612	184577899	183516764	263495454	164306786	200283205	204832518	246126038	181381482	237198342	222100885	332053093	184451884	242790934	248666034	342283836	258201955	349896175	339593101	442965344	338754002	478883122	426336694	453106052	289365568	420832270	392953002	543163072	469041829	602469528	596498167	641936587
Quarterly	Euro	Bulgaria	Total																					311037852	422473360	430713961	525357271	350087198	475512913	484788083	591313417	362028511	531526863	523781272	671614019	443223726	564420205	592524581	674655146	478177979	642944148	658487654	817355297	502323742	498507717	646248386	807081592	611340575	888003022	958083321	1261887371	872048417	1225085980	1129797377	1113464923	825557213	1148998678	1112665414	1409974625	1164175950	1496159648	1494028415	1695590158
Quarterly	Euro	Denmark	Purchases of existing dwellings													2446575223	3088151382	2955667063	2803870656	2846956279	3492188213	3523625033	3402268016	4062335369	4875605218	4204856151	3000800474	3710434869	4859619147	4578172002	4345011549	4640394676	5536235363	5408531732	4963041223	4751366094	5630071276	5354941058	4934282593	4734585817	5783479111	5784727099	5540424166	5338839137	6831241698	7477339801	8016448060	9267037423	8746552111	7158507612	6927056938	6978370773	6513332302	5015012210	1401426044	5003428882	6350373418	6337544935	6694526608	5442864202	6973363427	7220367277	6796407677
Quarterly	Euro	Denmark	Total													2446575223	3088151382	2955667063	2803870656	2846956279	3492188213	3523625033	3402268016	4062335369	4875605218	4204856151	3000800474	3710434869	4859619147	4578172002	4345011549	4640394676	5536235363	5408531732	4963041223	4751366094	5630071276	5354941058	4934282593	4734585817	5783479111	5784727099	5540424166	5338839137	6831241698	7477339801	8016448060	9267037423	8746552111	7158507612	6927056938	6978370773	6513332302	5015012210	1401426044	5003428882	6350373418	6337544935	6694526608	5442864202	6973363427	7220367277	6796407677


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "purchase" VARCHAR,
  "n_2006_q1" DOUBLE,
  "n_2006_q2" DOUBLE,
  "n_2006_q3" DOUBLE,
  "n_2006_q4" DOUBLE,
  "n_2007_q1" DOUBLE,
  "n_2007_q2" DOUBLE,
  "n_2007_q3" DOUBLE,
  "n_2007_q4" DOUBLE,
  "n_2008_q1" DOUBLE,
  "n_2008_q2" DOUBLE,
  "n_2008_q3" DOUBLE,
  "n_2008_q4" DOUBLE,
  "n_2009_q1" DOUBLE,
  "n_2009_q2" DOUBLE,
  "n_2009_q3" DOUBLE,
  "n_2009_q4" DOUBLE,
  "n_2010_q1" DOUBLE,
  "n_2010_q2" DOUBLE,
  "n_2010_q3" DOUBLE,
  "n_2010_q4" DOUBLE,
  "n_2011_q1" DOUBLE,
  "n_2011_q2" DOUBLE,
  "n_2011_q3" DOUBLE,
  "n_2011_q4" DOUBLE,
  "n_2012_q1" DOUBLE,
  "n_2012_q2" DOUBLE,
  "n_2012_q3" DOUBLE,
  "n_2012_q4" DOUBLE,
  "n_2013_q1" DOUBLE,
  "n_2013_q2" DOUBLE,
  "n_2013_q3" DOUBLE,
  "n_2013_q4" DOUBLE,
  "n_2014_q1" DOUBLE,
  "n_2014_q2" DOUBLE,
  "n_2014_q3" DOUBLE,
  "n_2014_q4" DOUBLE,
  "n_2015_q1" DOUBLE,
  "n_2015_q2" DOUBLE,
  "n_2015_q3" DOUBLE,
  "n_2015_q4" DOUBLE,
  "n_2016_q1" DOUBLE,
  "n_2016_q2" DOUBLE,
  "n_2016_q3" DOUBLE,
  "n_2016_q4" DOUBLE,
  "n_2017_q1" DOUBLE,
  "n_2017_q2" DOUBLE,
  "n_2017_q3" DOUBLE,
  "n_2017_q4" DOUBLE,
  "n_2018_q1" DOUBLE,
  "n_2018_q2" DOUBLE,
  "n_2018_q3" DOUBLE,
  "n_2018_q4" DOUBLE,
  "n_2019_q1" DOUBLE,
  "n_2019_q2" DOUBLE,
  "n_2019_q3" DOUBLE,
  "n_2019_q4" DOUBLE,
  "n_2020_q1" DOUBLE,
  "n_2020_q2" DOUBLE,
  "n_2020_q3" DOUBLE,
  "n_2020_q4" DOUBLE,
  "n_2021_q1" DOUBLE,
  "n_2021_q2" DOUBLE,
  "n_2021_q3" DOUBLE,
  "n_2021_q4" DOUBLE,
  "n_2022_q1" DOUBLE,
  "n_2022_q2" DOUBLE,
  "n_2022_q3" DOUBLE,
  "n_2022_q4" DOUBLE,
  "n_2023_q1" DOUBLE,
  "n_2023_q2" DOUBLE,
  "n_2023_q3" DOUBLE,
  "n_2023_q4" DOUBLE,
  "n_2024_q1" DOUBLE,
  "n_2024_q2" DOUBLE,
  "n_2024_q3" DOUBLE,
  "n_2024_q4" DOUBLE
);