Brazilian Insurance Market Data

Insurance data compiled by SUSEP, the brazilian insurance market regulator

@kaggle.ex0ticone_brazilian_insurance_market_data

Table List

1 table(70.93 MB)

Insurance Dataset

@kaggle.ex0ticone_brazilian_insurance_market_data.insurance_dataset

70.93 MB
8338214 rows
8 columns

company_code Company Code	company_name Company Name	year_month Year Month	product Product	state State	premiums Premiums	claims Claims	claim_premium_ratio Claim Premium Ratio
6785	BRASILSEG COMPANHIA DE SEGUROS	Sat Nov 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	0435 - Aeronáuticos	RN
6921	KOVR SEGURADORA S.A.	Fri Jul 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	0553 - R. C. Facultativa Veículos - RCFV	MG		239.86
8737	AIG SEGUROS BRASIL S.A.	Tue Nov 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	1066 - Seg.Habit.Sist.Financ. da Habitação	SC
6785	BRASILSEG COMPANHIA DE SEGUROS	Sat Jan 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	0977 - Prestamista (exceto Habit e Rural)	TO	55553.86	-60000	-1.08
6785	BRASILSEG COMPANHIA DE SEGUROS	Fri Dec 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	0980 - Educacional	MS
6785	BRASILSEG COMPANHIA DE SEGUROS	Sun Jul 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	0638 - R.C.Trans. Ferroviário CargaRCTF-C	GO
6602	MITSUI SUMITOMO SEGUROS S.A.	Wed Sep 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	0740 - Garantia de Obrigações Privadas	SP
6688	COMPANHIA DE SEGUROS DO ESTADO DE SÃO PAULO - COSESP	Thu Jun 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	1164 - Seguros Animais	CE
6688	COMPANHIA DE SEGUROS DO ESTADO DE SÃO PAULO - COSESP	Sat Mar 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	0627 - Resp. Civil do Transp. Intermodal	MS
6106	KIRTON SEGUROS S.A.	Sun May 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	0969 - Viagem	SC	2068.02	1111.46	0.5375


CREATE TABLE insurance_dataset (
  "company_code" BIGINT,
  "company_name" VARCHAR,
  "year_month" TIMESTAMP,
  "product" VARCHAR,
  "state" VARCHAR,
  "premiums" DOUBLE,
  "claims" DOUBLE,
  "claim_premium_ratio" DOUBLE
);