Commercial Property Prices - RESC

European Central Bank

@ecb.commercial_property_prices_resc

Table List

1 table(25.53 KB)

Table 1

@ecb.commercial_property_prices_resc.table_1

25.53 KB
306 rows
35 columns

key KEY	freq FREQ	ref_area REF AREA	region REGION	adjustment ADJUSTMENT	property_type PROPERTY TYPE	indicator INDICATOR	data_provider DATA PROVIDER	price_type PRICE TYPE	transformation TRANSFORMATION	unit_measure UNIT MEASURE	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	conf_status CONF STATUS	time_format TIME FORMAT	decimals DECIMALS	time_per_collect TIME PER COLLECT	title TITLE	title_compl TITLE COMPL	unit_index_base UNIT INDEX BASE
RESC.Q.B6._T.N._TC.TVAL.4F0.TH.N.IX	Q	B6	_T	N	_TC	TVAL	4F0	TH	N	IX	1999-Q1	74.99310830011943	A	F	P3M	2	A	Commercial property price indicator	EU27 (fixed composition) as of 31 January 2020 (brexit); Whole country; Transaction value; Commercial property, All types	2011 = 100
RESC.Q.B6._T.N._TC.TVAL.4F0.TH.N.IX	Q	B6	_T	N	_TC	TVAL	4F0	TH	N	IX	1999-Q2	74.99310830011943	A	F	P3M	2	A	Commercial property price indicator	EU27 (fixed composition) as of 31 January 2020 (brexit); Whole country; Transaction value; Commercial property, All types	2011 = 100
RESC.Q.B6._T.N._TC.TVAL.4F0.TH.N.IX	Q	B6	_T	N	_TC	TVAL	4F0	TH	N	IX	1999-Q3	74.99310830011943	A	F	P3M	2	A	Commercial property price indicator	EU27 (fixed composition) as of 31 January 2020 (brexit); Whole country; Transaction value; Commercial property, All types	2011 = 100
RESC.Q.B6._T.N._TC.TVAL.4F0.TH.N.IX	Q	B6	_T	N	_TC	TVAL	4F0	TH	N	IX	1999-Q4	74.99310830011943	A	F	P3M	2	A	Commercial property price indicator	EU27 (fixed composition) as of 31 January 2020 (brexit); Whole country; Transaction value; Commercial property, All types	2011 = 100
RESC.Q.B6._T.N._TC.TVAL.4F0.TH.N.IX	Q	B6	_T	N	_TC	TVAL	4F0	TH	N	IX	2000-Q1	75.99445489716673	A	F	P3M	2	A	Commercial property price indicator	EU27 (fixed composition) as of 31 January 2020 (brexit); Whole country; Transaction value; Commercial property, All types	2011 = 100
RESC.Q.B6._T.N._TC.TVAL.4F0.TH.N.IX	Q	B6	_T	N	_TC	TVAL	4F0	TH	N	IX	2000-Q2	78.63119396789938	A	F	P3M	2	A	Commercial property price indicator	EU27 (fixed composition) as of 31 January 2020 (brexit); Whole country; Transaction value; Commercial property, All types	2011 = 100
RESC.Q.B6._T.N._TC.TVAL.4F0.TH.N.IX	Q	B6	_T	N	_TC	TVAL	4F0	TH	N	IX	2000-Q3	79.03724050149307	A	F	P3M	2	A	Commercial property price indicator	EU27 (fixed composition) as of 31 January 2020 (brexit); Whole country; Transaction value; Commercial property, All types	2011 = 100
RESC.Q.B6._T.N._TC.TVAL.4F0.TH.N.IX	Q	B6	_T	N	_TC	TVAL	4F0	TH	N	IX	2000-Q4	80.4032827313333	A	F	P3M	2	A	Commercial property price indicator	EU27 (fixed composition) as of 31 January 2020 (brexit); Whole country; Transaction value; Commercial property, All types	2011 = 100
RESC.Q.B6._T.N._TC.TVAL.4F0.TH.N.IX	Q	B6	_T	N	_TC	TVAL	4F0	TH	N	IX	2001-Q1	81.08248297574491	A	F	P3M	2	A	Commercial property price indicator	EU27 (fixed composition) as of 31 January 2020 (brexit); Whole country; Transaction value; Commercial property, All types	2011 = 100
RESC.Q.B6._T.N._TC.TVAL.4F0.TH.N.IX	Q	B6	_T	N	_TC	TVAL	4F0	TH	N	IX	2001-Q2	82.21738055657733	A	F	P3M	2	A	Commercial property price indicator	EU27 (fixed composition) as of 31 January 2020 (brexit); Whole country; Transaction value; Commercial property, All types	2011 = 100


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "region" VARCHAR,
  "adjustment" VARCHAR,
  "property_type" VARCHAR,
  "indicator" VARCHAR,
  "data_provider" VARCHAR,
  "price_type" VARCHAR,
  "transformation" VARCHAR,
  "unit_measure" VARCHAR,
  "time_period" VARCHAR,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "conf_status" VARCHAR,
  "pre_break_value" VARCHAR,
  "comment_obs" VARCHAR,
  "embargo_time" VARCHAR,
  "time_format" VARCHAR,
  "adju_detail" VARCHAR,
  "breaks" VARCHAR,
  "comment_ts" VARCHAR,
  "compiling_org" VARCHAR,
  "coverage" VARCHAR,
  "data_comp" VARCHAR,
  "decimals" BIGINT,
  "diss_org" VARCHAR,
  "dom_ser_ids" VARCHAR,
  "time_per_collect" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit_index_base" VARCHAR,
  "unit_mult" BIGINT,
  "update_status" VARCHAR,
  "comment_dset" VARCHAR
);