Home Insurance

2007-2012 polices of a Home Insurance company

@kaggle.ycanario_home_insurance

Table List

1 table(8.9 MB)

Home Insurance

@kaggle.ycanario_home_insurance.home_insurance

8.9 MB
256136 rows
66 columns

quote_date QUOTE DATE	cover_start COVER START	claim3years CLAIM3YEARS	p1_emp_status P1 EMP STATUS	p1_pt_emp_status P1 PT EMP STATUS	bus_use BUS USE	clerical CLERICAL	ad_buildings AD BUILDINGS	risk_rated_area_b RISK RATED AREA B	sum_insured_buildings SUM INSURED BUILDINGS	ncd_granted_years_b NCD GRANTED YEARS B	ad_contents AD CONTENTS	risk_rated_area_c RISK RATED AREA C	sum_insured_contents SUM INSURED CONTENTS	ncd_granted_years_c NCD GRANTED YEARS C	contents_cover CONTENTS COVER	buildings_cover BUILDINGS COVER	spec_sum_insured SPEC SUM INSURED	spec_item_prem SPEC ITEM PREM	unspec_hrp_prem UNSPEC HRP PREM	p1_dob P1 DOB	p1_mar_status P1 MAR STATUS	p1_policy_refused P1 POLICY REFUSED	p1_sex P1 SEX	appr_alarm APPR ALARM	appr_locks APPR LOCKS	bedrooms BEDROOMS	roof_construction ROOF CONSTRUCTION	wall_construction WALL CONSTRUCTION	flooding FLOODING	listed LISTED	neigh_watch NEIGH WATCH	occ_status OCC STATUS	ownership_type OWNERSHIP TYPE	prop_type PROP TYPE	safe_installed SAFE INSTALLED	sec_disc_req SEC DISC REQ	subsidence SUBSIDENCE	yearbuilt YEARBUILT	payment_method PAYMENT METHOD	legal_addon_pre_ren LEGAL ADDON PRE REN	legal_addon_post_ren LEGAL ADDON POST REN	home_em_addon_pre_ren HOME EM ADDON PRE REN	home_em_addon_post_ren HOME EM ADDON POST REN	garden_addon_pre_ren GARDEN ADDON PRE REN	garden_addon_post_ren GARDEN ADDON POST REN	keycare_addon_pre_ren KEYCARE ADDON PRE REN	keycare_addon_post_ren KEYCARE ADDON POST REN	hp1_addon_pre_ren HP1 ADDON PRE REN	hp1_addon_post_ren HP1 ADDON POST REN	hp2_addon_pre_ren HP2 ADDON PRE REN	hp2_addon_post_ren HP2 ADDON POST REN	hp3_addon_pre_ren HP3 ADDON PRE REN	hp3_addon_post_ren HP3 ADDON POST REN	mta_flag MTA FLAG	mta_fap MTA FAP	mta_aprp MTA APRP	mta_date MTA DATE	last_ann_prem_gross LAST ANN PREM GROSS	pol_status POL STATUS	i I	police Police
Thu Nov 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	N	R	nan	N	nan	Y	19	1000000	7	Y	6	50000	7	Y	Y	7500	44.42	12.45	Thu Jun 15 1939 00:00:00 GMT+0000 (Coordinated Universal Time)	O	N	M	N	Y	3	11	15	Y	3	N	PH	8	10	Y	Y	N	1960	PureDD	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N				274.81	Lapsed	1	P000001
Thu Nov 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	N	E	nan	Y	N	Y	25	1000000	6	Y	9	50000	7	Y	Y			24.6	Wed May 20 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	M	N	M	N	N	3	11	15	Y	3	N	PH	3	2	N	N	N	1960	PureDD	Y	Y	N	N	N	N	N	N	N	N	N	N	N	N	Y	308.83	-9.27		308.83	Live	2	P000002
Fri Nov 23 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 23 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	N	E	nan	N	nan	N				Y	12	50000	7	N	Y				Tue Jun 10 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	S	N	M	Y	Y	2	11	15	Y	3	Y	PH	8	9	N	Y	N	1946	PureDD	Y	Y	N	N	N	N	N	N	N	N	N	N	N	N	Y	52.65	52.65	Wed Nov 03 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	52.65	Live	3	P000003
Fri Nov 23 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	N	R	nan	N	nan	N				Y	14	50000	7	N	Y				Wed Dec 16 1925 00:00:00 GMT+0000 (Coordinated Universal Time)	W	N	F	N	Y	2	11	15	Y	3	N	PH	18	19	N	Y	N	1870	NonDD	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N				54.23	Live	4	P000004
Thu Nov 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	N	R	nan	N	nan	Y	5	1000000	7	Y	10	50000	7	Y	Y			19.82	Tue Feb 11 1936 00:00:00 GMT+0000 (Coordinated Universal Time)	M	N	M	Y	Y	3	11	15	Y	3	N	PH	8	1	N	Y	N	1960	DD-Other	Y	Y	N	N	Y	Y	N	N	N	N	N	N	N	N	N				244.58	Live	5	P000005
Thu Nov 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	N	R	nan	N	nan	N				Y	8	50000	7	N	Y				Tue Sep 03 1935 00:00:00 GMT+0000 (Coordinated Universal Time)	M	N	M	N	N	1	11	15	Y	3	N	PH	18	7	N	N	N	1960	PureDD	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N				51.45	Live	6	P000006
Mon Nov 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	N	R	nan	N	nan	Y	1	1000000	7	Y	6	50000	7	Y	Y				Mon Jan 06 1930 00:00:00 GMT+0000 (Coordinated Universal Time)	D	N	F	N	Y	2	11	15	Y	3	N	PH	8	9	N	Y	N	1980	NonDD	Y	Y	N	N	N	N	N	N	N	N	N	N	N	N	Y	109.32	109.32	Mon Dec 15 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	109.32	Live	7	P000007
Thu Nov 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	N	R	nan	N	nan	N				Y	6	50000	7	N	Y				Wed May 24 1922 00:00:00 GMT+0000 (Coordinated Universal Time)	M	N	M	N	Y	2	11	15	Y	3	N	PH	12	7	N	Y	N	1990	DD-Other	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N				54.53	Cancelled	8	P000008
Thu Nov 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Feb 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	N	E	nan	N	nan	Y		1000000	3	Y		50000	3	Y	Y				Mon Oct 06 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	P	N	M	N	Y	3	11	15	Y	3	N	PH	8	19	N	Y	N	1960	PureDD	Y	Y	Y	N	N	N	N	N	N	N	N	Y	N	N	Y	242.16			242.16	Live	9	P000009
Thu Nov 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	N	E	nan	N	nan	Y	5	1000000	7	Y	1	50000	7	Y	Y				Tue Sep 29 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	S	N	M	N	Y	3	11	15	Y	3	N	PH	8	10	N	Y	N	1946	PureDD	Y	Y	N	N	N	N	N	N	N	N	N	N	N	N	N				188.31	Live	10	P000010


CREATE TABLE home_insurance (
  "quote_date" TIMESTAMP,
  "cover_start" TIMESTAMP,
  "claim3years" VARCHAR,
  "p1_emp_status" VARCHAR,
  "p1_pt_emp_status" VARCHAR,
  "bus_use" VARCHAR,
  "clerical" VARCHAR,
  "ad_buildings" VARCHAR,
  "risk_rated_area_b" DOUBLE,
  "sum_insured_buildings" DOUBLE,
  "ncd_granted_years_b" DOUBLE,
  "ad_contents" VARCHAR,
  "risk_rated_area_c" DOUBLE,
  "sum_insured_contents" DOUBLE,
  "ncd_granted_years_c" DOUBLE,
  "contents_cover" VARCHAR,
  "buildings_cover" VARCHAR,
  "spec_sum_insured" DOUBLE,
  "spec_item_prem" DOUBLE,
  "unspec_hrp_prem" DOUBLE,
  "p1_dob" TIMESTAMP,
  "p1_mar_status" VARCHAR,
  "p1_policy_refused" VARCHAR,
  "p1_sex" VARCHAR,
  "appr_alarm" VARCHAR,
  "appr_locks" VARCHAR,
  "bedrooms" DOUBLE,
  "roof_construction" DOUBLE,
  "wall_construction" DOUBLE,
  "flooding" VARCHAR,
  "listed" DOUBLE,
  "max_days_unocc" DOUBLE,
  "neigh_watch" VARCHAR,
  "occ_status" VARCHAR,
  "ownership_type" DOUBLE,
  "paying_guests" DOUBLE,
  "prop_type" DOUBLE,
  "safe_installed" VARCHAR,
  "sec_disc_req" VARCHAR,
  "subsidence" VARCHAR,
  "yearbuilt" DOUBLE,
  "campaign_desc" VARCHAR,
  "payment_method" VARCHAR,
  "payment_frequency" DOUBLE,
  "legal_addon_pre_ren" VARCHAR,
  "legal_addon_post_ren" VARCHAR,
  "home_em_addon_pre_ren" VARCHAR,
  "home_em_addon_post_ren" VARCHAR,
  "garden_addon_pre_ren" VARCHAR,
  "garden_addon_post_ren" VARCHAR,
  "keycare_addon_pre_ren" VARCHAR,
  "keycare_addon_post_ren" VARCHAR,
  "hp1_addon_pre_ren" VARCHAR,
  "hp1_addon_post_ren" VARCHAR,
  "hp2_addon_pre_ren" VARCHAR,
  "hp2_addon_post_ren" VARCHAR,
  "hp3_addon_pre_ren" VARCHAR,
  "hp3_addon_post_ren" VARCHAR,
  "mta_flag" VARCHAR,
  "mta_fap" DOUBLE,
  "mta_aprp" DOUBLE,
  "mta_date" TIMESTAMP,
  "last_ann_prem_gross" DOUBLE,
  "pol_status" VARCHAR,
  "i" BIGINT,
  "police" VARCHAR
);