Main Aggregates, National Accounts (International Data Cooperation) - IDCM

European Central Bank

@ecb.main_aggregates_national_accounts_international_cooper_94f61961

Table List

1 table(1.48 MB)

Table 1

@ecb.main_aggregates_national_accounts_international_cooper_94f61961.table_1

1.48 MB
514166 rows
40 columns

key KEY	freq FREQ	adjustment ADJUSTMENT	ref_area REF AREA	counterpart_area COUNTERPART AREA	ref_sector REF SECTOR	counterpart_sector COUNTERPART SECTOR	accounting_entry ACCOUNTING ENTRY	sto STO	instr_asset INSTR ASSET	activity ACTIVITY	expenditure EXPENDITURE	unit_measure UNIT MEASURE	prices PRICES	transformation TRANSFORMATION	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	conf_status CONF STATUS	time_format TIME FORMAT	comment_ts COMMENT TS	compiling_org COMPILING ORG	decimals DECIMALS	diss_org DISS ORG	ref_period_detail REF PERIOD DETAIL	time_per_collect TIME PER COLLECT	title TITLE	unit_mult UNIT MULT
IDCM.A.N.6O.W0.S1.S1.B.B5G._Z._Z._Z.USD.V.N	A	N	6O	W0	S1	S1	B	B5G	_Z	_Z	_Z	USD	V	N	2000	29099689	A	F	P1Y	Balance of primary incomes, gross / National income, gross - OECD (Organisation for Economic Co-operation and Development) - World (all entities, including reference area, including IO), Total economy, US dollar, Current prices, Non transformed data, Neither seasonally adjusted nor calendar adjusted…	6O0	2	6O0	C	S	Balance of primary incomes, gross / National income, gross	6
IDCM.A.N.6O.W0.S1.S1.B.B5G._Z._Z._Z.USD.V.N	A	N	6O	W0	S1	S1	B	B5G	_Z	_Z	_Z	USD	V	N	2001	30272258	A	F	P1Y	Balance of primary incomes, gross / National income, gross - OECD (Organisation for Economic Co-operation and Development) - World (all entities, including reference area, including IO), Total economy, US dollar, Current prices, Non transformed data, Neither seasonally adjusted nor calendar adjusted…	6O0	2	6O0	C	S	Balance of primary incomes, gross / National income, gross	6
IDCM.A.N.6O.W0.S1.S1.B.B5G._Z._Z._Z.USD.V.N	A	N	6O	W0	S1	S1	B	B5G	_Z	_Z	_Z	USD	V	N	2002	31377072	A	F	P1Y	Balance of primary incomes, gross / National income, gross - OECD (Organisation for Economic Co-operation and Development) - World (all entities, including reference area, including IO), Total economy, US dollar, Current prices, Non transformed data, Neither seasonally adjusted nor calendar adjusted…	6O0	2	6O0	C	S	Balance of primary incomes, gross / National income, gross	6
IDCM.A.N.6O.W0.S1.S1.B.B5G._Z._Z._Z.USD.V.N	A	N	6O	W0	S1	S1	B	B5G	_Z	_Z	_Z	USD	V	N	2003	32532831	A	F	P1Y	Balance of primary incomes, gross / National income, gross - OECD (Organisation for Economic Co-operation and Development) - World (all entities, including reference area, including IO), Total economy, US dollar, Current prices, Non transformed data, Neither seasonally adjusted nor calendar adjusted…	6O0	2	6O0	C	S	Balance of primary incomes, gross / National income, gross	6
IDCM.A.N.6O.W0.S1.S1.B.B5G._Z._Z._Z.USD.V.N	A	N	6O	W0	S1	S1	B	B5G	_Z	_Z	_Z	USD	V	N	2004	34578437	A	F	P1Y	Balance of primary incomes, gross / National income, gross - OECD (Organisation for Economic Co-operation and Development) - World (all entities, including reference area, including IO), Total economy, US dollar, Current prices, Non transformed data, Neither seasonally adjusted nor calendar adjusted…	6O0	2	6O0	C	S	Balance of primary incomes, gross / National income, gross	6
IDCM.A.N.6O.W0.S1.S1.B.B5G._Z._Z._Z.USD.V.N	A	N	6O	W0	S1	S1	B	B5G	_Z	_Z	_Z	USD	V	N	2005	36527206	A	F	P1Y	Balance of primary incomes, gross / National income, gross - OECD (Organisation for Economic Co-operation and Development) - World (all entities, including reference area, including IO), Total economy, US dollar, Current prices, Non transformed data, Neither seasonally adjusted nor calendar adjusted…	6O0	2	6O0	C	S	Balance of primary incomes, gross / National income, gross	6
IDCM.A.N.6O.W0.S1.S1.B.B5G._Z._Z._Z.USD.V.N	A	N	6O	W0	S1	S1	B	B5G	_Z	_Z	_Z	USD	V	N	2006	39350893	A	F	P1Y	Balance of primary incomes, gross / National income, gross - OECD (Organisation for Economic Co-operation and Development) - World (all entities, including reference area, including IO), Total economy, US dollar, Current prices, Non transformed data, Neither seasonally adjusted nor calendar adjusted…	6O0	2	6O0	C	S	Balance of primary incomes, gross / National income, gross	6
IDCM.A.N.6O.W0.S1.S1.B.B5G._Z._Z._Z.USD.V.N	A	N	6O	W0	S1	S1	B	B5G	_Z	_Z	_Z	USD	V	N	2007	41307114	A	F	P1Y	Balance of primary incomes, gross / National income, gross - OECD (Organisation for Economic Co-operation and Development) - World (all entities, including reference area, including IO), Total economy, US dollar, Current prices, Non transformed data, Neither seasonally adjusted nor calendar adjusted…	6O0	2	6O0	C	S	Balance of primary incomes, gross / National income, gross	6
IDCM.A.N.6O.W0.S1.S1.B.B5G._Z._Z._Z.USD.V.N	A	N	6O	W0	S1	S1	B	B5G	_Z	_Z	_Z	USD	V	N	2008	42513604	A	F	P1Y	Balance of primary incomes, gross / National income, gross - OECD (Organisation for Economic Co-operation and Development) - World (all entities, including reference area, including IO), Total economy, US dollar, Current prices, Non transformed data, Neither seasonally adjusted nor calendar adjusted…	6O0	2	6O0	C	S	Balance of primary incomes, gross / National income, gross	6
IDCM.A.N.6O.W0.S1.S1.B.B5G._Z._Z._Z.USD.V.N	A	N	6O	W0	S1	S1	B	B5G	_Z	_Z	_Z	USD	V	N	2009	42730290	E	F	P1Y	Balance of primary incomes, gross / National income, gross - OECD (Organisation for Economic Co-operation and Development) - World (all entities, including reference area, including IO), Total economy, US dollar, Current prices, Non transformed data, Neither seasonally adjusted nor calendar adjusted…	6O0	2	6O0	C	S	Balance of primary incomes, gross / National income, gross	6


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "adjustment" VARCHAR,
  "ref_area" VARCHAR,
  "counterpart_area" VARCHAR,
  "ref_sector" VARCHAR,
  "counterpart_sector" VARCHAR,
  "accounting_entry" VARCHAR,
  "sto" VARCHAR,
  "instr_asset" VARCHAR,
  "activity" VARCHAR,
  "expenditure" VARCHAR,
  "unit_measure" VARCHAR,
  "prices" VARCHAR,
  "transformation" VARCHAR,
  "time_period" VARCHAR,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "conf_status" VARCHAR,
  "pre_break_value" VARCHAR,
  "comment_obs" VARCHAR,
  "embargo_date" VARCHAR,
  "time_format" VARCHAR,
  "comment_ts" VARCHAR,
  "compiling_org" VARCHAR,
  "currency" VARCHAR,
  "data_comp" VARCHAR,
  "decimals" BIGINT,
  "diss_org" VARCHAR,
  "last_update" VARCHAR,
  "ref_period_detail" VARCHAR,
  "ref_year_price" DOUBLE,
  "repyearend" VARCHAR,
  "repyearstart" VARCHAR,
  "table_identifier" VARCHAR,
  "time_per_collect" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit_mult" BIGINT,
  "comment_dset" VARCHAR
);