FreMTPL - French Motor TPL Insurance Claims Data

French Motor Insurance Claims

@kaggle.karansarpal_fremtpl_french_motor_tpl_insurance_claims

Table List

2 tables(4.06 MB)

Fremtplfreq

@kaggle.karansarpal_fremtpl_french_motor_tpl_insurance_claims.fremtplfreq

3.93 MB
413169 rows
10 columns

policyid PolicyID	exposure Exposure	power Power	carage CarAge	driverage DriverAge	brand Brand	gas Gas	region Region	density Density
1	0.09	g		46	Japanese (except Nissan) or Korean	Diesel	Aquitaine	76
2	0.84	g		46	Japanese (except Nissan) or Korean	Diesel	Aquitaine	76
3	0.52	f	2	38	Japanese (except Nissan) or Korean	Regular	Nord-Pas-de-Calais	3003
4	0.45	f	2	38	Japanese (except Nissan) or Korean	Regular	Nord-Pas-de-Calais	3003
5	0.15	g		41	Japanese (except Nissan) or Korean	Diesel	Pays-de-la-Loire	60
6	0.75	g		41	Japanese (except Nissan) or Korean	Diesel	Pays-de-la-Loire	60
7	0.81	d	1	27	Japanese (except Nissan) or Korean	Regular	Aquitaine	695
8	0.05	d		27	Japanese (except Nissan) or Korean	Regular	Aquitaine	695
9	0.76	d	9	23	Fiat	Regular	Nord-Pas-de-Calais	7887
10	0.34	i		44	Japanese (except Nissan) or Korean	Regular	Ile-de-France	27000


CREATE TABLE fremtplfreq (
  "policyid" BIGINT,
  "claimnb" BIGINT,
  "exposure" DOUBLE,
  "power" VARCHAR,
  "carage" BIGINT,
  "driverage" BIGINT,
  "brand" VARCHAR,
  "gas" VARCHAR,
  "region" VARCHAR,
  "density" BIGINT
);