Other Financial Intermediaries - OFI

European Central Bank

@ecb.other_financial_intermediaries_ofi

Table List

1 table(242.88 KB)

Table 1

@ecb.other_financial_intermediaries_ofi.table_1

242.88 KB
30449 rows
36 columns

key KEY	freq FREQ	ref_area REF AREA	adjustment ADJUSTMENT	ofi_rep_sector OFI REP SECTOR	ofi_item OFI ITEM	maturity_orig MATURITY ORIG	data_type DATA TYPE	count_area COUNT AREA	currency_trans CURRENCY TRANS	series_denom SERIES DENOM	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	obs_conf OBS CONF	time_format TIME FORMAT	collection COLLECTION	title_compl TITLE COMPL	unit UNIT	unit_mult UNIT MULT
OFI.A.U2.N.30.A20.A.1.A1.0000.Z01.E	A	U2	N	30	A20	A	1	A1	Z01	E	2010	552707.79735	A	F	P1Y	E	Euro area (changing composition), Outstanding amounts at the end of the period (stocks), Financial corporations engaged in lending to households and non-financial corporations reporting sector - Loans, Total maturity, All currencies combined - World (all entities) counterpart, Unspecified counterpar…	EUR	6
OFI.A.U2.N.30.A20.A.1.A1.0000.Z01.E	A	U2	N	30	A20	A	1	A1	Z01	E	2011	515404.2564	A	F	P1Y	E	Euro area (changing composition), Outstanding amounts at the end of the period (stocks), Financial corporations engaged in lending to households and non-financial corporations reporting sector - Loans, Total maturity, All currencies combined - World (all entities) counterpart, Unspecified counterpar…	EUR	6
OFI.A.U2.N.30.A20.A.1.A1.0000.Z01.E	A	U2	N	30	A20	A	1	A1	Z01	E	2012	488589.872	A	F	P1Y	E	Euro area (changing composition), Outstanding amounts at the end of the period (stocks), Financial corporations engaged in lending to households and non-financial corporations reporting sector - Loans, Total maturity, All currencies combined - World (all entities) counterpart, Unspecified counterpar…	EUR	6
OFI.A.U2.N.30.A20.A.1.A1.0000.Z01.E	A	U2	N	30	A20	A	1	A1	Z01	E	2013	460195.024383	A	F	P1Y	E	Euro area (changing composition), Outstanding amounts at the end of the period (stocks), Financial corporations engaged in lending to households and non-financial corporations reporting sector - Loans, Total maturity, All currencies combined - World (all entities) counterpart, Unspecified counterpar…	EUR	6
OFI.A.U2.N.30.A20.A.1.A1.0000.Z01.E	A	U2	N	30	A20	A	1	A1	Z01	E	2014	383478.7361763358	A	F	P1Y	E	Euro area (changing composition), Outstanding amounts at the end of the period (stocks), Financial corporations engaged in lending to households and non-financial corporations reporting sector - Loans, Total maturity, All currencies combined - World (all entities) counterpart, Unspecified counterpar…	EUR	6
OFI.A.U2.N.30.A20.A.1.A1.0000.Z01.E	A	U2	N	30	A20	A	1	A1	Z01	E	2015	353069.732135	A	F	P1Y	E	Euro area (changing composition), Outstanding amounts at the end of the period (stocks), Financial corporations engaged in lending to households and non-financial corporations reporting sector - Loans, Total maturity, All currencies combined - World (all entities) counterpart, Unspecified counterpar…	EUR	6
OFI.A.U2.N.30.A20.A.1.A1.0000.Z01.E	A	U2	N	30	A20	A	1	A1	Z01	E	2016	354467.47552959993	A	F	P1Y	E	Euro area (changing composition), Outstanding amounts at the end of the period (stocks), Financial corporations engaged in lending to households and non-financial corporations reporting sector - Loans, Total maturity, All currencies combined - World (all entities) counterpart, Unspecified counterpar…	EUR	6
OFI.A.U2.N.30.A20.A.1.A1.0000.Z01.E	A	U2	N	30	A20	A	1	A1	Z01	E	2017	364585.6584548	A	F	P1Y	E	Euro area (changing composition), Outstanding amounts at the end of the period (stocks), Financial corporations engaged in lending to households and non-financial corporations reporting sector - Loans, Total maturity, All currencies combined - World (all entities) counterpart, Unspecified counterpar…	EUR	6
OFI.A.U2.N.30.A20.A.1.A1.0000.Z01.E	A	U2	N	30	A20	A	1	A1	Z01	E	2018	374984.1317207	A	F	P1Y	E	Euro area (changing composition), Outstanding amounts at the end of the period (stocks), Financial corporations engaged in lending to households and non-financial corporations reporting sector - Loans, Total maturity, All currencies combined - World (all entities) counterpart, Unspecified counterpar…	EUR	6
OFI.A.U2.N.30.A20.A.1.A1.0000.Z01.E	A	U2	N	30	A20	A	1	A1	Z01	E	2019	394085.2406138	A	F	P1Y	E	Euro area (changing composition), Outstanding amounts at the end of the period (stocks), Financial corporations engaged in lending to households and non-financial corporations reporting sector - Loans, Total maturity, All currencies combined - World (all entities) counterpart, Unspecified counterpar…	EUR	6


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "adjustment" VARCHAR,
  "ofi_rep_sector" VARCHAR,
  "ofi_item" VARCHAR,
  "maturity_orig" VARCHAR,
  "data_type" BIGINT,
  "count_area" VARCHAR,
  "bs_count_sector" BIGINT,
  "currency_trans" VARCHAR,
  "series_denom" 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,
  "diss_org" VARCHAR,
  "dom_ser_ids" VARCHAR,
  "publ_ecb" VARCHAR,
  "publ_mu" VARCHAR,
  "publ_public" VARCHAR,
  "compilation" VARCHAR,
  "coverage" VARCHAR,
  "decimals" BIGINT,
  "nat_title" VARCHAR,
  "source_agency" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" BIGINT
);