STEP Data - STP

European Central Bank

@ecb.step_data_stp

Table List

1 table(5.71 MB)

Table 1

@ecb.step_data_stp.table_1

5.71 MB
3151521 rows
37 columns

key KEY	freq FREQ	ref_area REF AREA	sec_issuing_sector SEC ISSUING SECTOR	ir_fv_type IR FV TYPE	floating_rate_base FLOATING RATE BASE	maturity_type MATURITY TYPE	maturity_cat MATURITY CAT	credit_rating CREDIT RATING	data_type_sec DATA TYPE SEC	collateral COLLATERAL	currency_trans CURRENCY TRANS	sec_suffix SEC SUFFIX	time_period TIME PERIOD	obs_status OBS STATUS	obs_conf OBS CONF	time_format TIME FORMAT	collection COLLECTION	coverage COVERAGE	decimals DECIMALS	title TITLE	title_compl TITLE COMPL	unit UNIT	unit_mult UNIT MULT
STP.B.A1.1000.A.XXXX.O.AA.R1.2.A.Z01.E	B	A1	1000	A	XXXX	O	AA	R1	2	A	Z01	E	2009-09-07	A	F	P1D	E	Nominal valuation	4	Gross issues of STEP instruments denominated in all currencies, issued by total economy (rating 1)	World (all entities), issuing sector Total economy, All rates (fixed, variable, zero coupon) rate - Unspecified floating rate base, Original maturity Total, Highest credit ratings, (Gross) issues against cash (flows), All collaterals - All currencies combined - Euro million equivalent	EUR	6
STP.B.A1.1000.A.XXXX.O.AA.R1.2.A.Z01.E	B	A1	1000	A	XXXX	O	AA	R1	2	A	Z01	E	2009-09-08	A	F	P1D	E	Nominal valuation	4	Gross issues of STEP instruments denominated in all currencies, issued by total economy (rating 1)	World (all entities), issuing sector Total economy, All rates (fixed, variable, zero coupon) rate - Unspecified floating rate base, Original maturity Total, Highest credit ratings, (Gross) issues against cash (flows), All collaterals - All currencies combined - Euro million equivalent	EUR	6
STP.B.A1.1000.A.XXXX.O.AA.R1.2.A.Z01.E	B	A1	1000	A	XXXX	O	AA	R1	2	A	Z01	E	2009-09-09	A	F	P1D	E	Nominal valuation	4	Gross issues of STEP instruments denominated in all currencies, issued by total economy (rating 1)	World (all entities), issuing sector Total economy, All rates (fixed, variable, zero coupon) rate - Unspecified floating rate base, Original maturity Total, Highest credit ratings, (Gross) issues against cash (flows), All collaterals - All currencies combined - Euro million equivalent	EUR	6
STP.B.A1.1000.A.XXXX.O.AA.R1.2.A.Z01.E	B	A1	1000	A	XXXX	O	AA	R1	2	A	Z01	E	2009-09-10	A	F	P1D	E	Nominal valuation	4	Gross issues of STEP instruments denominated in all currencies, issued by total economy (rating 1)	World (all entities), issuing sector Total economy, All rates (fixed, variable, zero coupon) rate - Unspecified floating rate base, Original maturity Total, Highest credit ratings, (Gross) issues against cash (flows), All collaterals - All currencies combined - Euro million equivalent	EUR	6
STP.B.A1.1000.A.XXXX.O.AA.R1.2.A.Z01.E	B	A1	1000	A	XXXX	O	AA	R1	2	A	Z01	E	2009-09-11	A	F	P1D	E	Nominal valuation	4	Gross issues of STEP instruments denominated in all currencies, issued by total economy (rating 1)	World (all entities), issuing sector Total economy, All rates (fixed, variable, zero coupon) rate - Unspecified floating rate base, Original maturity Total, Highest credit ratings, (Gross) issues against cash (flows), All collaterals - All currencies combined - Euro million equivalent	EUR	6
STP.B.A1.1000.A.XXXX.O.AA.R1.2.A.Z01.E	B	A1	1000	A	XXXX	O	AA	R1	2	A	Z01	E	2009-09-14	A	F	P1D	E	Nominal valuation	4	Gross issues of STEP instruments denominated in all currencies, issued by total economy (rating 1)	World (all entities), issuing sector Total economy, All rates (fixed, variable, zero coupon) rate - Unspecified floating rate base, Original maturity Total, Highest credit ratings, (Gross) issues against cash (flows), All collaterals - All currencies combined - Euro million equivalent	EUR	6
STP.B.A1.1000.A.XXXX.O.AA.R1.2.A.Z01.E	B	A1	1000	A	XXXX	O	AA	R1	2	A	Z01	E	2009-09-15	A	F	P1D	E	Nominal valuation	4	Gross issues of STEP instruments denominated in all currencies, issued by total economy (rating 1)	World (all entities), issuing sector Total economy, All rates (fixed, variable, zero coupon) rate - Unspecified floating rate base, Original maturity Total, Highest credit ratings, (Gross) issues against cash (flows), All collaterals - All currencies combined - Euro million equivalent	EUR	6
STP.B.A1.1000.A.XXXX.O.AA.R1.2.A.Z01.E	B	A1	1000	A	XXXX	O	AA	R1	2	A	Z01	E	2009-09-16	A	F	P1D	E	Nominal valuation	4	Gross issues of STEP instruments denominated in all currencies, issued by total economy (rating 1)	World (all entities), issuing sector Total economy, All rates (fixed, variable, zero coupon) rate - Unspecified floating rate base, Original maturity Total, Highest credit ratings, (Gross) issues against cash (flows), All collaterals - All currencies combined - Euro million equivalent	EUR	6
STP.B.A1.1000.A.XXXX.O.AA.R1.2.A.Z01.E	B	A1	1000	A	XXXX	O	AA	R1	2	A	Z01	E	2009-09-17	A	F	P1D	E	Nominal valuation	4	Gross issues of STEP instruments denominated in all currencies, issued by total economy (rating 1)	World (all entities), issuing sector Total economy, All rates (fixed, variable, zero coupon) rate - Unspecified floating rate base, Original maturity Total, Highest credit ratings, (Gross) issues against cash (flows), All collaterals - All currencies combined - Euro million equivalent	EUR	6
STP.B.A1.1000.A.XXXX.O.AA.R1.2.A.Z01.E	B	A1	1000	A	XXXX	O	AA	R1	2	A	Z01	E	2009-09-18	A	F	P1D	E	Nominal valuation	4	Gross issues of STEP instruments denominated in all currencies, issued by total economy (rating 1)	World (all entities), issuing sector Total economy, All rates (fixed, variable, zero coupon) rate - Unspecified floating rate base, Original maturity Total, Highest credit ratings, (Gross) issues against cash (flows), All collaterals - All currencies combined - Euro million equivalent	EUR	6


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "sec_issuing_sector" VARCHAR,
  "ir_fv_type" VARCHAR,
  "floating_rate_base" VARCHAR,
  "maturity_type" VARCHAR,
  "maturity_cat" VARCHAR,
  "credit_rating" VARCHAR,
  "data_type_sec" VARCHAR,
  "collateral" VARCHAR,
  "currency_trans" VARCHAR,
  "sec_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,
  "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
);