Dataset: FreMTPL2 - French Motor TPL Insurance Claims Data

About this Dataset

FreMTPL2 - French Motor TPL Insurance Claims Data

Description

In the two datasets freMTPL2freq and freMTPL2sev, risk features are collected for 677,991 motor third-party liability policies (observed mostly on one year), in addition to claim numbers by policy as well as their corresponding claim amounts. freMTPL2freq contains the risk features and claim counts, while freMTPL2sev contains claim amounts. Both tables can be linked together via the corresponding policy ID.

Additional information can be found at http://cas.uqam.ca/pub/web/CASdatasets-manual.pdf.

Tables

Fremtpl2freq

@kaggle.karansarpal_fremtpl2_french_motor_tpl_insurance_claims.fremtpl2freq

7.38 MB
678013 rows
12 columns


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
);

Fremtpl2sev

@kaggle.karansarpal_fremtpl2_french_motor_tpl_insurance_claims.fremtpl2sev

261.92 KB
26639 rows
2 columns


CREATE TABLE fremtpl2sev (
  "idpol" BIGINT,
  "claimamount" DOUBLE
);