Number Of Participants In Payments Systems - PSN

European Central Bank

@ecb.number_of_participants_in_payments_systems_psn

Table List

1 table(122.37 KB)

Table 1

@ecb.number_of_participants_in_payments_systems_psn.table_1

122.37 KB
24077 rows
27 columns

key KEY	freq FREQ	ref_area REF AREA	pymnt_systm PYMNT SYSTM	prtcptn PRTCPTN	prtc_insttl_sctr PRTC INSTTL SCTR	unit_measure UNIT MEASURE	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	conf_status CONF STATUS	time_format TIME FORMAT	time_per_collect TIME PER COLLECT	method_ref METHOD REF	title TITLE	title_compl TITLE COMPL	unit UNIT
PSN.A.4F.TRGT2.1.S1.PN	A	4F	TRGT2	1	S1	PN	2022	11	A	F	P1Y	S	<NA>	Payment systems, number of direct participants: T2 component system, institutional sector of participant: total participants	Payment systems, number of direct participants: T2 component system, institutional sector of participant: total participants	PN
PSN.A.4F.TRGT2.1.S1.PN	A	4F	TRGT2	1	S1	PN	2023	10	A	F	P1Y	S	<NA>	Payment systems, number of direct participants: T2 component system, institutional sector of participant: total participants	Payment systems, number of direct participants: T2 component system, institutional sector of participant: total participants	PN
PSN.A.4F.TRGT2.1.S121.PN	A	4F	TRGT2	1	S121	PN	2022	2	A	F	P1Y	S	<NA>	Payment systems, number of direct participants: T2 component system, institutional sector of participant: Central bank	Payment systems, number of direct participants: T2 component system, institutional sector of participant: Central bank	PN
PSN.A.4F.TRGT2.1.S121.PN	A	4F	TRGT2	1	S121	PN	2023	2	A	F	P1Y	S	<NA>	Payment systems, number of direct participants: T2 component system, institutional sector of participant: Central bank	Payment systems, number of direct participants: T2 component system, institutional sector of participant: Central bank	PN
PSN.A.4F.TRGT2.1.S122C.PN	A	4F	TRGT2	1	S122C	PN	2022		A	F	P1Y	S	<NA>	Payment systems, number of direct participants: T2 component system, institutional sector of participant: Credit institutions	Payment systems, number of direct participants: T2 component system, institutional sector of participant: Credit institutions	PN
PSN.A.4F.TRGT2.1.S122C.PN	A	4F	TRGT2	1	S122C	PN	2023		A	F	P1Y	S	<NA>	Payment systems, number of direct participants: T2 component system, institutional sector of participant: Credit institutions	Payment systems, number of direct participants: T2 component system, institutional sector of participant: Credit institutions	PN
PSN.A.4F.TRGT2.1.S125D1.PN	A	4F	TRGT2	1	S125D1	PN	2022	8	A	F	P1Y	S	<NA>	Payment systems, number of direct participants: T2 component system, institutional sector of participant: clearing and settlement organisations	Payment systems, number of direct participants: T2 component system, institutional sector of participant: clearing and settlement organisations	PN
PSN.A.4F.TRGT2.1.S125D1.PN	A	4F	TRGT2	1	S125D1	PN	2023	8	A	F	P1Y	S	<NA>	Payment systems, number of direct participants: T2 component system, institutional sector of participant: clearing and settlement organisations	Payment systems, number of direct participants: T2 component system, institutional sector of participant: clearing and settlement organisations	PN
PSN.A.4F.TRGT2.1.S12P.PN	A	4F	TRGT2	1	S12P	PN	2022		A	F	P1Y	S	<NA>	Payment systems, number of direct participants: T2 component system, institutional sector of participant: other financial institutions	Payment systems, number of direct participants: T2 component system, institutional sector of participant: other financial institutions	PN
PSN.A.4F.TRGT2.1.S12P.PN	A	4F	TRGT2	1	S12P	PN	2023		A	F	P1Y	S	<NA>	Payment systems, number of direct participants: T2 component system, institutional sector of participant: other financial institutions	Payment systems, number of direct participants: T2 component system, institutional sector of participant: other financial institutions	PN


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "pymnt_systm" VARCHAR,
  "prtcptn" VARCHAR,
  "prtc_insttl_sctr" VARCHAR,
  "unit_measure" VARCHAR,
  "time_period" VARCHAR,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "conf_status" VARCHAR,
  "pre_break_value" VARCHAR,
  "comment_obs" VARCHAR,
  "time_format" VARCHAR,
  "breaks" VARCHAR,
  "comment_ts" VARCHAR,
  "compiling_org" VARCHAR,
  "diss_org" VARCHAR,
  "time_per_collect" VARCHAR,
  "coverage" VARCHAR,
  "data_comp" VARCHAR,
  "decimals" BIGINT,
  "method_ref" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" BIGINT
);