Macroeconomic Projection Database - MPD

European Central Bank

@ecb.macroeconomic_projection_database_mpd

Table List

1 table(343.64 KB)

Table 1

@ecb.macroeconomic_projection_database_mpd.table_1

343.64 KB
149268 rows
32 columns

key KEY	freq FREQ	ref_area REF AREA	pd_item PD ITEM	series_denom SERIES DENOM	pd_seas_ex PD SEAS EX	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	obs_conf OBS CONF	time_format TIME FORMAT	collection COLLECTION	decimals DECIMALS	title_compl TITLE COMPL	unit UNIT
MPD.A.A1.PCU.A.A01.0000	A	A1	PCU	A	A01	1998	-13.7	A	F	P1Y	A	1	World (all entities) - Price and cost developments - non-energy commodity prices - total - Annual growth rate - December 2001 staff macroeconomic projections	PCCH
MPD.A.A1.PCU.A.A01.0000	A	A1	PCU	A	A01	1999	-7.7	A	F	P1Y	A	1	World (all entities) - Price and cost developments - non-energy commodity prices - total - Annual growth rate - December 2001 staff macroeconomic projections	PCCH
MPD.A.A1.PCU.A.A01.0000	A	A1	PCU	A	A01	2000	2.3	A	F	P1Y	A	1	World (all entities) - Price and cost developments - non-energy commodity prices - total - Annual growth rate - December 2001 staff macroeconomic projections	PCCH
MPD.A.A1.PCU.A.A01.0000	A	A1	PCU	A	A01	2001	-8.7	F	F	P1Y	A	1	World (all entities) - Price and cost developments - non-energy commodity prices - total - Annual growth rate - December 2001 staff macroeconomic projections	PCCH
MPD.A.A1.PCU.A.A01.0000	A	A1	PCU	A	A01	2002	-5.9	F	F	P1Y	A	1	World (all entities) - Price and cost developments - non-energy commodity prices - total - Annual growth rate - December 2001 staff macroeconomic projections	PCCH
MPD.A.A1.PCU.A.A01.0000	A	A1	PCU	A	A01	2003	3	F	F	P1Y	A	1	World (all entities) - Price and cost developments - non-energy commodity prices - total - Annual growth rate - December 2001 staff macroeconomic projections	PCCH
MPD.A.A1.PCU.A.A02.0000	A	A1	PCU	A	A02	1999	-12.7	A	F	P1Y	A	1	World (all entities) - Price and cost developments - non-energy commodity prices - total - Annual growth rate - December 2002 staff macroeconomic projections	PCCH
MPD.A.A1.PCU.A.A02.0000	A	A1	PCU	A	A02	2000	-2.1	A	F	P1Y	A	1	World (all entities) - Price and cost developments - non-energy commodity prices - total - Annual growth rate - December 2002 staff macroeconomic projections	PCCH
MPD.A.A1.PCU.A.A02.0000	A	A1	PCU	A	A02	2001	-16.2	A	F	P1Y	A	1	World (all entities) - Price and cost developments - non-energy commodity prices - total - Annual growth rate - December 2002 staff macroeconomic projections	PCCH
MPD.A.A1.PCU.A.A02.0000	A	A1	PCU	A	A02	2002	4.7	F	F	P1Y	A	1	World (all entities) - Price and cost developments - non-energy commodity prices - total - Annual growth rate - December 2002 staff macroeconomic projections	PCCH


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "pd_item" VARCHAR,
  "series_denom" VARCHAR,
  "pd_seas_ex" VARCHAR,
  "pd_origin" BIGINT,
  "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,
  "diss_org" VARCHAR,
  "dom_ser_ids" VARCHAR,
  "publ_ecb" VARCHAR,
  "publ_mu" VARCHAR,
  "publ_public" VARCHAR,
  "agg_equn" VARCHAR,
  "compilation" VARCHAR,
  "coverage" VARCHAR,
  "decimals" BIGINT,
  "source_agency" VARCHAR,
  "source_detail" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" BIGINT
);