Insurance
26 columns
1,000 rows
8 formats

Property Claims - Fire and Perils

This dataset provides detailed, structured records of property damage insurance claims resulting from fire, wind, hail, water, theft, and other perils. It includes claim details, damage assessments, restoration costs, contents inventories, and actual vs replacement value determinations, making it ideal for claims analytics, risk modeling, and operational reporting.

last updated 2 Nov 2025
by GoMask

The brief that made it

Claims analytics and fraud detection

Sample rows

preview · 8 of 1,000 rows · all 26 columns

claim_idstring	peril_typestring	contents_inventory_total_valuefloat	property_countrystring	policy_idstring	claimant_namestring	claimant_contact_phonestring	claimant_contact_emailstring	property_street_addressstring	property_citystring	property_statestring	property_postal_codestring	date_of_lossdate	date_claim_reporteddate	damage_assessment_amountfloat	restoration_estimate_amountfloat	actual_cash_value_amountfloat	replacement_cost_value_amountfloat	contents_inventory_countinteger	claim_statusstring	claim_settlement_amountfloat	adjuster_namestring	adjuster_contact_phonestring	adjuster_contact_emailstring	damage_descriptionstring	notesstring
CLM00001	water	2250	USA	POL10001	James Rodriguez	+1-917-555-2187	jrodriguez.ny@email.com	1123 Maple Avenue	New York	NY	10009	2024-01-14	2024-01-15	9300.25	8500	8000	9600	5	paid	8700	Mark Ellison	+1-212-555-1724	mark.ellison@insureco.us	Water damage due to burst pipe in basement, affecting flooring and furniture.	Restoration completed by AquaRestore Inc. Invoice attached.
CLM00002	fire	1800	Ireland	POL10002	Linda O'Connor	+353-21-555-9821	linda.oconnor@email.ie	27 Main Street	Cork	Munster	T12DF7P	2023-11-30	2023-12-03	7800	7200	6500	8000	4	closed	7400	Siobhan McCarthy	+353-1-555-3328	siobhan.mccarthy@insureco.ie	Smoke and fire damage to kitchen appliances and cabinetry after stove malfunction.	Claim closed after repair. Inspection photos in file.
CLM00003	theft	16500	Russia	POL10003	Viktor Ivanov	+7-495-555-7192	v.ivanov@email.ru	Ulitsa Tverskaya 14	Moscow	Moscow	101000	2022-08-12	2022-08-13	19500	1100	14500	19800	9	paid	16000	Irina Petrovna	+7-812-555-3344	irina.petrovna@insureco.ru	Theft of electronics and jewelry from apartment during absence.	Police report filed. Documentation reviewed.
CLM00004	wind	900	Italy	POL10004	Giulia Romano	+39-06-555-9173	giulia.romano@email.it	Via del Corso 22	Rome	Lazio	00186	2024-03-10	2024-03-12	6700	6800	5900	7100	2	open	blank	Marco Bianchi	+39-06-555-1187	marco.bianchi@insureco.it	Severe wind caused roof tile dislodgement and window breakage.	Awaiting contractor quotes.
CLM00005	hail	400	UK	POL10005	Emma Johnson	+44-20-555-8137	emma.johnson@email.co.uk	47 High Street	London	England	SW1A2AA	2023-12-25	2023-12-26	5400	5200	4600	5700	1	closed	5000	Rachel Green	+44-20-555-3279	rachel.green@insureco.uk	Hail storm caused window damage and dents in car parked outside.	Secondary inspection confirmed damages.
CLM00006	water	2600	Mexico	POL10006	Carlos Mendoza	+52-55-555-2198	carlos.mendoza@email.mx	Calle Juarez 9	Mexico City	CDMX	06000	2024-04-02	2024-04-03	8700	9200	7900	9300	6	paid	9000	Miguel Torres	+52-55-555-3091	miguel.torres@insureco.mx	Flooding from heavy rains damaged living room and electronics.	Restoration in progress. All receipts attached.
CLM00007	wind	1200	USA	POL10007	Amelia Carter	+1-515-555-3192	amelia.carter@email.com	820 Cedar Lane	Des Moines	IA	50309	2023-09-18	2023-09-19	4100	3900	3500	4300	3	under review	blank	Steven Clark	+1-515-555-2017	steven.clark@insureco.us	Windstorm uprooted fence and damaged backyard shed.	Awaiting engineering report.
CLM00008	fire	3700	Russia	POL10008	Olga Kuznetsova	+7-812-555-8011	olga.kuznetsova@email.ru	Nevsky Prospekt 47	St. Petersburg	SPB	190000	2024-02-11	2024-02-12	11200	12800	10200	13500	7	paid	12000	Ivan Smirnov	+7-495-555-6712	ivan.smirnov@insureco.ru	Electrical fire damaged bedroom and hallway, extensive smoke residue.	Expedited handling approved by supervisor.
CLM00009	theft	4700	China	POL10009	Sophie Chen	+86-21-555-9217	sophie.chen@email.cn	Lane 388 Huaihai Rd	Shanghai	Shanghai	200020	2023-08-20	2023-08-22	8800	1200	7400	9000	3	under review	blank	Li Wei	+86-21-555-2014	li.wei@insureco.cn	Burglary during night, laptop and cash stolen from office.	Police investigation ongoing.
CLM00010	hail	1100	USA	POL10010	John Williams	+1-626-555-5129	jwilliams.la@email.com	1017 Oakcrest Drive	Los Angeles	CA	90068	2022-07-19	2022-07-27	7100	6800	5900	7500	2	closed	7000	Linda Park	+1-213-555-4217	linda.park@insureco.us	Large hail damaged solar panels and vehicle in driveway.	Solar panel invoice submitted.
CLM00011	water	1600	France	POL10011	Isabelle Dubois	+33-1-555-7142	isabelle.dubois@email.fr	18 Rue de Rivoli	Paris	Île-de-France	75001	2024-03-21	2024-03-21	6000	6400	5800	6700	3	paid	6100	Pierre Martin	+33-1-555-9231	pierre.martin@insureco.fr	Leak from upstairs neighbor flooded bedroom and closet.	Repair scheduled with local contractor.
CLM00012	wind	600	India	POL10012	Ava Patel	+91-22-555-9213	ava.patel@email.in	304 Residency Road	Mumbai	Maharashtra	400001	2024-04-01	2024-04-06	3200	3400	2900	3450	1	open	blank	Rajesh Mehta	+91-22-555-8100	rajesh.mehta@insureco.in	Strong winds toppled outdoor signage and damaged balcony railing.	Site inspection scheduled.
CLM00013	other	0	Germany	POL10013	Martha Klein	+49-30-555-8123	martha.klein@email.de	Bismarckstrasse 44	Berlin	Berlin	10557	2023-10-09	2023-10-10	1800	2000	1500	2100	0	closed	1950	Hans Becker	+49-30-555-9017	hans.becker@insureco.de	Bicycle accident caused damage to garden fence and landscaping.	Self-repair completed by claimant.
CLM00014	water	900	Estonia	POL10014	Nina Sokolova	+372-555-8134	nina.sokolova@email.ee	Kaarli pst 11	Tallinn	Harju	10119	2022-05-25	2022-05-29	4300	4500	3800	4700	2	closed	4100	Andres Saar	+372-555-8112	andres.saar@insureco.ee	Heavy rain caused basement flooding and property damage.	Restoration completed. Photos attached.
CLM00015	theft	3600	USA	POL10015	Lucas Thompson	+1-214-555-9217	lucas.thompson@email.com	653 Westwood Blvd	Dallas	TX	75209	2023-03-11	2023-03-12	6500	700	4900	6800	4	paid	5900	Jessica Lee	+1-214-555-3010	jessica.lee@insureco.us	Break-in resulted in theft of gaming consoles and jewelry.	Police report and receipts attached.
CLM00016	other	400	Italy	POL10016	Alessandro Rossi	+39-02-555-7115	alessandro.rossi@email.it	Via Monte Napoleone 3	Milan	Lombardy	20121	2024-02-03	2024-02-03	2200	2400	1900	2450	1	open	blank	Francesca Moretti	+39-02-555-8011	francesca.moretti@insureco.it	Tree fell on garage roof during storm, minor structural damage.	Pending contractor estimate.
CLM00017	fire	1300	USA	POL10017	Emily Nguyen	+1-617-555-2187	emily.nguyen@email.com	1400 Beacon St	Boston	MA	02115	2023-06-07	2023-06-07	5700	5200	4800	5900	3	paid	5450	David Palmer	+1-617-555-9219	david.palmer@insureco.us	Small kitchen fire resulting in smoke damage and appliance loss.	Kitchen repair authorized.
CLM00018	wind	700	UK	POL10018	Thomas Wright	+44-161-555-8217	thomas.wright@email.co.uk	18 Bridgewater Road	Manchester	England	M13LT	2023-09-02	2023-09-03	3800	4200	3400	4300	2	open	blank	Helen Smith	+44-161-555-9012	helen.smith@insureco.uk	Windstorm caused roof shingles to loosen and gutter damage.	Awaiting contractor proposal.
CLM00019	theft	8800	USA	POL10019	Jessica Adams	+1-312-555-2179	jessica.adams@email.com	3327 Lake Shore Dr	Chicago	IL	60657	2023-05-10	2023-05-10	12300	1400	9200	13000	6	paid	11000	Gary Maxwell	+1-312-555-2191	gary.maxwell@insureco.us	Office burglary resulted in stolen computers and files.	Security system invoice included.
CLM00020	water	1200	Canada	POL10020	Chloe Martin	+1-416-555-9214	chloe.martin@email.ca	22 King St W	Toronto	ON	M5H1A1	2023-04-15	2023-04-17	5100	5300	4800	5400	3	closed	5250	Paul Wilson	+1-416-555-2019	paul.wilson@insureco.ca	Water damage from roof leak during spring thaw.	Roof repair completed. Photos attached.

What the 1,000 rows show

from the 1,000-row sample

Theft (peril type) stands out: mean contents_inventory_total_value is 7,100, against 819.1 for the rest.

700median contents_inventory_total_value
5claim statuses
110property states
126property cities
4,300median damage_assessment_amount
3,900median restoration_estimate_amount

Mean contents_inventory_total_value by peril_type1,000 rows

contents_inventory_total_value1,000 rows, in bands of 2,500

Median 700, from 0 to 22,100.

property_country1,000 rows · top 10 of 26 values

USA305
Russia94
UK73
Ireland68
Italy66
Mexico50
Estonia46
Canada38
India37
Ukraine35

26 columns by typefrom the column list below

string 17
integer 1
float 6
date 2

Columns

26 columns in three groups

blueprint · 26 columns
column	type	description	example
Text 17 columns
`claim_id`	string	Unique identifier for the property claimunique	CLM00001
`policy_id`	string	Unique identifier for the insurance policy associated with the claim	POL10001
`claimant_name`	string	Full name of the person or entity filing the claim	James Rodriguez
`claimant_contact_phone`	string	Primary phone number for the claimantoptional	+1-917-555-2187
`claimant_contact_email`	string	Email address for the claimantoptional	jrodriguez.ny@email.com
`property_street_address`	string	Street address of the damaged property	1123 Maple Avenue
`property_city`	string	City where the damaged property is located	New York
`property_state`	string	State or province where the damaged property is located	NY
`property_postal_code`	string	Postal code for the damaged property	10009
`property_country`	string	Country where the damaged property is located	USA
`peril_type`	string	Type of peril causing the damage (e.g., fire, wind, hail, water, theft, other)6 values	water
`damage_description`	string	Detailed description of the damage sustained	Water damage due to burst…
`claim_status`	string	Current status of the claim (e.g., open, closed, under review, denied, paid)open · closed · under review · denied · paid	paid
`adjuster_name`	string	Name of the insurance adjuster assigned to the claimoptional	Mark Ellison
`adjuster_contact_phone`	string	Phone number for the insurance adjusteroptional	+1-212-555-1724
`adjuster_contact_email`	string	Email address for the insurance adjusteroptional	mark.ellison@insureco.us
`notes`	string	Additional notes or comments related to the claimoptional	Garage repair completed.
Numbers 7 columns
`damage_assessment_amount`	float	Assessed monetary value of the damage to the property0 or more	9300.25
`restoration_estimate_amount`	float	Estimated cost to restore the property to its pre-loss condition0 or more · optional	8500
`actual_cash_value_amount`	float	Actual cash value (ACV) determined for the damaged property or contents0 or more · optional	8000
`replacement_cost_value_amount`	float	Replacement cost value (RCV) determined for the damaged property or contents0 or more · optional	9600
`contents_inventory_count`	integer	Number of individual contents items inventoried in the claim0 or more · optional	5
`contents_inventory_total_value`	float	Total assessed value of all inventoried contents items0 or more · optional	2250
`claim_settlement_amount`	float	Final settlement amount paid or approved for the claim0 or more · optional	8700
Dates and times 2 columns
`date_of_loss`	date	Date when the damage or loss occurred	2024-01-14
`date_claim_reported`	date	Date when the claim was reported to the insurer	2024-01-15

Use it for

An insurance dashboard
Contents_inventory_total_value by peril_type and a breakdown of property_country. Excel, Power BI or Tableau.
Why do the 160 theft rows have a mean contents_inventory_total_value of 7,100?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Claims1,000
CLM000012250water
CLM000021800fire
CLM0000316500theft
A software demo
Believable claims with policy_id, claimant_name and claimant_contact_phone to fill a screen in front of a buyer.

This dataset1,000 rows26 columns

Yours1,000 rows26 columnsproperty_street_address: UK only

blueprint · property-claims-fire-and-perils

Behind this dataset

Same schema. As many rows as you need.

These 1,000 rows came out of a blueprint — 26 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with

Peril type coded per ISO cause of loss
Building damage vs contents damage separated
Actual Cash Value (ACV) vs Replacement Cost Value (RCV)
Depreciation applied for ACV
Coinsurance penalty if underinsured
Deductible applied per occurrence
Emergency mitigation expenses
Additional living expenses (ALE) for uninhabitable properties

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: property-claims-fire-and-perils

What should your data show?

No signup. No card.

Sample rows

What the 1,000 rows show

Columns

Use it for

An insurance dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Insurance

What should your data show?