Large Insurance Group Statistics - LIG

European Central Bank

@ecb.large_insurance_group_statistics_lig

Table List

1 table(57.45 KB)

Table 1

@ecb.large_insurance_group_statistics_lig.table_1

57.45 KB
5100 rows
31 columns

key KEY	freq FREQ	ref_area REF AREA	ins_bus_type INS BUS TYPE	lig_item LIG ITEM	data_type_lig DATA TYPE LIG	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	decimals DECIMALS	title_compl TITLE COMPL	unit UNIT
LIG.A.D0.L.W00.FQ.A	A	D0	L	W00	FQ	A	2017	-4.18	A	F	P1Y	E	4	EU (changing composition), Life business, Duration of technical provisions, Life excluding unit-linked, First quartile, Annual growth rate	PCPA
LIG.A.D0.L.W00.FQ.A	A	D0	L	W00	FQ	A	2018	-3	A	F	P1Y	E	4	EU (changing composition), Life business, Duration of technical provisions, Life excluding unit-linked, First quartile, Annual growth rate	PCPA
LIG.A.D0.L.W00.FQ.A	A	D0	L	W00	FQ	A	2019	0.01	A	F	P1Y	E	4	EU (changing composition), Life business, Duration of technical provisions, Life excluding unit-linked, First quartile, Annual growth rate	PCPA
LIG.A.D0.L.W00.FQ.A	A	D0	L	W00	FQ	A	2020	-0.37	A	F	P1Y	E	4	EU (changing composition), Life business, Duration of technical provisions, Life excluding unit-linked, First quartile, Annual growth rate	PCPA
LIG.A.D0.L.W00.FQ.A	A	D0	L	W00	FQ	A	2021	-5.45	A	F	P1Y	E	4	EU (changing composition), Life business, Duration of technical provisions, Life excluding unit-linked, First quartile, Annual growth rate	PCPA
LIG.A.D0.L.W00.FQ.A	A	D0	L	W00	FQ	A	2022	-13.49	A	F	P1Y	E	4	EU (changing composition), Life business, Duration of technical provisions, Life excluding unit-linked, First quartile, Annual growth rate	PCPA
LIG.A.D0.L.W00.FQ.A	A	D0	L	W00	FQ	A	2023		A	F	P1Y	E	4	EU (changing composition), Life business, Duration of technical provisions, Life excluding unit-linked, First quartile, Annual growth rate	PCPA
LIG.A.D0.L.W00.FQ.A	A	D0	L	W00	FQ	A	2024	-5.012675	A	F	P1Y	E	4	EU (changing composition), Life business, Duration of technical provisions, Life excluding unit-linked, First quartile, Annual growth rate	PCPA
LIG.A.D0.L.W00.ME.A	A	D0	L	W00	ME	A	2017	-0.76	A	F	P1Y	E	4	EU (changing composition), Life business, Duration of technical provisions, Life excluding unit-linked, Median, Annual growth rate	PCPA
LIG.A.D0.L.W00.ME.A	A	D0	L	W00	ME	A	2018	-0.92	A	F	P1Y	E	4	EU (changing composition), Life business, Duration of technical provisions, Life excluding unit-linked, Median, Annual growth rate	PCPA


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "ins_bus_type" VARCHAR,
  "lig_item" VARCHAR,
  "data_type_lig" 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,
  "unit_index_base" VARCHAR,
  "compilation" VARCHAR,
  "decimals" BIGINT,
  "nat_title" VARCHAR,
  "source_agency" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" BIGINT
);