Insurance Corporations Operations - ICO

European Central Bank

@ecb.insurance_corporations_operations_ico

Table List

1 table(44.7 KB)

Table 1

@ecb.insurance_corporations_operations_ico.table_1

44.7 KB
1785 rows
31 columns

key KEY	freq FREQ	ref_area REF AREA	reporting_sector REPORTING SECTOR	ico_pay ICO PAY	counterpart_area COUNTERPART AREA	ico_unit ICO UNIT	currency_denom CURRENCY DENOM	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	conf_status CONF STATUS	time_format TIME FORMAT	comment_ts COMMENT TS	decimals DECIMALS	time_per_collect TIME PER COLLECT	title TITLE	unit UNIT	unit_mult UNIT MULT
ICO.A.AT.S128.L.W0.A.EUR	A	AT	S128	L	W0	A	EUR	2017	15074	A	F	P1Y	Claims incurred - Insurance corporations resident in Austria, location of underwriting: World (all entities, including reference area, including IO), All (head office and branches)	2	S	Claims incurred by Austrian insurance corporations underwritten by head office and branches	EUR	6
ICO.A.AT.S128.L.W0.A.EUR	A	AT	S128	L	W0	A	EUR	2018	14556	A	F	P1Y	Claims incurred - Insurance corporations resident in Austria, location of underwriting: World (all entities, including reference area, including IO), All (head office and branches)	2	S	Claims incurred by Austrian insurance corporations underwritten by head office and branches	EUR	6
ICO.A.AT.S128.L.W0.A.EUR	A	AT	S128	L	W0	A	EUR	2019	15384	A	F	P1Y	Claims incurred - Insurance corporations resident in Austria, location of underwriting: World (all entities, including reference area, including IO), All (head office and branches)	2	S	Claims incurred by Austrian insurance corporations underwritten by head office and branches	EUR	6
ICO.A.AT.S128.L.W0.A.EUR	A	AT	S128	L	W0	A	EUR	2020	15963	A	F	P1Y	Claims incurred - Insurance corporations resident in Austria, location of underwriting: World (all entities, including reference area, including IO), All (head office and branches)	2	S	Claims incurred by Austrian insurance corporations underwritten by head office and branches	EUR	6
ICO.A.AT.S128.L.W0.A.EUR	A	AT	S128	L	W0	A	EUR	2021	16555	A	F	P1Y	Claims incurred - Insurance corporations resident in Austria, location of underwriting: World (all entities, including reference area, including IO), All (head office and branches)	2	S	Claims incurred by Austrian insurance corporations underwritten by head office and branches	EUR	6
ICO.A.AT.S128.L.W0.A.EUR	A	AT	S128	L	W0	A	EUR	2022	16935	A	F	P1Y	Claims incurred - Insurance corporations resident in Austria, location of underwriting: World (all entities, including reference area, including IO), All (head office and branches)	2	S	Claims incurred by Austrian insurance corporations underwritten by head office and branches	EUR	6
ICO.A.AT.S128.L.W0.A.EUR	A	AT	S128	L	W0	A	EUR	2023	17776	P	F	P1Y	Claims incurred - Insurance corporations resident in Austria, location of underwriting: World (all entities, including reference area, including IO), All (head office and branches)	2	S	Claims incurred by Austrian insurance corporations underwritten by head office and branches	EUR	6
ICO.A.AT.S128.L.W1.B.EUR	A	AT	S128	L	W1	B	EUR	2017	136	A	F	P1Y	Claims incurred - Insurance corporations resident in Austria, location of underwriting: Rest of the World, Branches	2	S	Claims incurred by Austrian insurance corporations underwritten by branches	EUR	6
ICO.A.AT.S128.L.W1.B.EUR	A	AT	S128	L	W1	B	EUR	2018	140	A	F	P1Y	Claims incurred - Insurance corporations resident in Austria, location of underwriting: Rest of the World, Branches	2	S	Claims incurred by Austrian insurance corporations underwritten by branches	EUR	6
ICO.A.AT.S128.L.W1.B.EUR	A	AT	S128	L	W1	B	EUR	2019	116	A	F	P1Y	Claims incurred - Insurance corporations resident in Austria, location of underwriting: Rest of the World, Branches	2	S	Claims incurred by Austrian insurance corporations underwritten by branches	EUR	6


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "reporting_sector" VARCHAR,
  "ico_pay" VARCHAR,
  "counterpart_area" VARCHAR,
  "ico_unit" VARCHAR,
  "currency_denom" VARCHAR,
  "time_period" BIGINT,
  "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,
  "coverage" VARCHAR,
  "data_comp" VARCHAR,
  "decimals" BIGINT,
  "diss_org" VARCHAR,
  "publ_ecb" VARCHAR,
  "publ_mu" VARCHAR,
  "publ_public" VARCHAR,
  "ref_period_detail" VARCHAR,
  "time_per_collect" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit" VARCHAR,
  "unit_mult" BIGINT
);