FreMTPL2 - French Motor TPL Insurance Claims Data

French Motor Insurance Claims

@kaggle.karansarpal_fremtpl2_french_motor_tpl_insurance_claims

Table List

2 tables(7.64 MB)

Fremtpl2freq

@kaggle.karansarpal_fremtpl2_french_motor_tpl_insurance_claims.fremtpl2freq

7.38 MB
678013 rows
12 columns

idpol IDpol	claimnb ClaimNb	exposure Exposure	vehpower VehPower	vehage VehAge	drivage DrivAge	bonusmalus BonusMalus	vehbrand VehBrand	vehgas VehGas	area Area	density Density	region Region
1	1	0.1	5		55	50	B12	Regular	D	1217	Rhone-Alpes
3	1	0.77	5		55	50	B12	Regular	D	1217	Rhone-Alpes
5	1	0.75	6	2	52	50	B12	Diesel	B	54	Picardie
10	1	0.09	7		46	50	B12	Diesel	B	76	Aquitaine
11	1	0.84	7		46	50	B12	Diesel	B	76	Aquitaine
13	1	0.52	6	2	38	50	B12	Regular	E	3003	Nord-Pas-de-Calais
15	1	0.45	6	2	38	50	B12	Regular	E	3003	Nord-Pas-de-Calais
17	1	0.27	7		33	68	B12	Diesel	C	137	Languedoc-Roussillon
18	1	0.71	7		33	68	B12	Diesel	C	137	Languedoc-Roussillon
21	1	0.15	7		41	50	B12	Diesel	B	60	Pays-de-la-Loire


CREATE TABLE fremtpl2freq (
  "idpol" DOUBLE,
  "claimnb" BIGINT,
  "exposure" DOUBLE,
  "vehpower" BIGINT,
  "vehage" BIGINT,
  "drivage" BIGINT,
  "bonusmalus" BIGINT,
  "vehbrand" VARCHAR,
  "vehgas" VARCHAR,
  "area" VARCHAR,
  "density" BIGINT,
  "region" VARCHAR
);