Indices Of Consumer Prices - ICP

European Central Bank

@ecb.indices_of_consumer_prices_icp

Table List

1 table(17.02 MB)

Table 1

@ecb.indices_of_consumer_prices_icp.table_1

17.02 MB
6395984 rows
32 columns

key KEY	freq FREQ	ref_area REF AREA	adjustment ADJUSTMENT	icp_item ICP ITEM	sts_institution STS INSTITUTION	icp_suffix ICP SUFFIX	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	obs_conf OBS CONF	time_format TIME FORMAT	collection COLLECTION	dom_ser_ids DOM SER IDS	unit_index_base UNIT INDEX BASE	decimals DECIMALS	title TITLE	title_compl TITLE COMPL	unit UNIT
ICP.A.AL.N.053120.4.AVR	A	AL	N	053120	4	AVR	2017	-2.5	A	F	P1Y	A	ICPT.A.VAL.HICP.RCH_A_AVG.AL.05312.A		1	HICP - Clothes washing machines, clothes drying machines and dish washing machines	Albania - HICP - Clothes washing machines, clothes drying machines and dish washing machines, Annual average rate of change, Eurostat, Neither seasonally nor working day adjusted	PCCH
ICP.A.AL.N.053120.4.AVR	A	AL	N	053120	4	AVR	2018	0.6	A	F	P1Y	A	ICPT.A.VAL.HICP.RCH_A_AVG.AL.05312.A		1	HICP - Clothes washing machines, clothes drying machines and dish washing machines	Albania - HICP - Clothes washing machines, clothes drying machines and dish washing machines, Annual average rate of change, Eurostat, Neither seasonally nor working day adjusted	PCCH
ICP.A.AL.N.053120.4.AVR	A	AL	N	053120	4	AVR	2019	0.4	A	F	P1Y	A	ICPT.A.VAL.HICP.RCH_A_AVG.AL.05312.A		1	HICP - Clothes washing machines, clothes drying machines and dish washing machines	Albania - HICP - Clothes washing machines, clothes drying machines and dish washing machines, Annual average rate of change, Eurostat, Neither seasonally nor working day adjusted	PCCH
ICP.A.AL.N.053120.4.AVR	A	AL	N	053120	4	AVR	2020	1.1	A	F	P1Y	A	ICPT.A.VAL.HICP.RCH_A_AVG.AL.05312.A		1	HICP - Clothes washing machines, clothes drying machines and dish washing machines	Albania - HICP - Clothes washing machines, clothes drying machines and dish washing machines, Annual average rate of change, Eurostat, Neither seasonally nor working day adjusted	PCCH
ICP.A.AL.N.053120.4.AVR	A	AL	N	053120	4	AVR	2021	1.8	A	F	P1Y	A	ICPT.A.VAL.HICP.RCH_A_AVG.AL.05312.A		1	HICP - Clothes washing machines, clothes drying machines and dish washing machines	Albania - HICP - Clothes washing machines, clothes drying machines and dish washing machines, Annual average rate of change, Eurostat, Neither seasonally nor working day adjusted	PCCH
ICP.A.AL.N.053120.4.AVR	A	AL	N	053120	4	AVR	2022	-0.9	A	F	P1Y	A	ICPT.A.VAL.HICP.RCH_A_AVG.AL.05312.A		1	HICP - Clothes washing machines, clothes drying machines and dish washing machines	Albania - HICP - Clothes washing machines, clothes drying machines and dish washing machines, Annual average rate of change, Eurostat, Neither seasonally nor working day adjusted	PCCH
ICP.A.AT.N.011800.4.INW	A	AT	N	011800	4	INW	1996	11.64	A	F	P1Y	A	ICPT.A.VAL.ITEM.WEIGHT.AT.0118.A	Parts per 1000. HICP total = 1000	2	HICP - Sugar, jam, honey, chocolate and confectionery	Austria - HICP - Sugar, jam, honey, chocolate and confectionery, Sub-index weight, Eurostat, Neither seasonally nor working day adjusted	PURE_NUMB
ICP.A.AT.N.011800.4.INW	A	AT	N	011800	4	INW	1997	11.64	A	F	P1Y	A	ICPT.A.VAL.ITEM.WEIGHT.AT.0118.A	Parts per 1000. HICP total = 1000	2	HICP - Sugar, jam, honey, chocolate and confectionery	Austria - HICP - Sugar, jam, honey, chocolate and confectionery, Sub-index weight, Eurostat, Neither seasonally nor working day adjusted	PURE_NUMB
ICP.A.AT.N.011800.4.INW	A	AT	N	011800	4	INW	1998	11.52	A	F	P1Y	A	ICPT.A.VAL.ITEM.WEIGHT.AT.0118.A	Parts per 1000. HICP total = 1000	2	HICP - Sugar, jam, honey, chocolate and confectionery	Austria - HICP - Sugar, jam, honey, chocolate and confectionery, Sub-index weight, Eurostat, Neither seasonally nor working day adjusted	PURE_NUMB
ICP.A.AT.N.011800.4.INW	A	AT	N	011800	4	INW	1999	11.6	A	F	P1Y	A	ICPT.A.VAL.ITEM.WEIGHT.AT.0118.A	Parts per 1000. HICP total = 1000	2	HICP - Sugar, jam, honey, chocolate and confectionery	Austria - HICP - Sugar, jam, honey, chocolate and confectionery, Sub-index weight, Eurostat, Neither seasonally nor working day adjusted	PURE_NUMB


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "adjustment" VARCHAR,
  "icp_item" VARCHAR,
  "sts_institution" BIGINT,
  "icp_suffix" VARCHAR,
  "time_period" VARCHAR,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "obs_conf" VARCHAR,
  "obs_pre_break" VARCHAR,
  "obs_com" VARCHAR,
  "time_format" VARCHAR,
  "breaks" VARCHAR,
  "collection" VARCHAR,
  "compiling_org" VARCHAR,
  "data_comp" VARCHAR,
  "diss_org" VARCHAR,
  "dom_ser_ids" VARCHAR,
  "publ_ecb" VARCHAR,
  "publ_mu" VARCHAR,
  "publ_public" VARCHAR,
  "unit_index_base" VARCHAR,
  "compilation" VARCHAR,
  "coverage" VARCHAR,
  "decimals" BIGINT,
  "source_agency" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" BIGINT
);