Package Damage Incident Records

This dataset provides detailed records of package damage incidents during shipping, including damage type, severity, suspected causes, locations, and resolution outcomes. It enables logistics providers and analysts to identify root causes, track trends, and improve shipping processes, while also supporting insurance claims and compensation analysis. The dataset's granular structure supports operational monitoring and strategic decision-making for logistics and supply chain management.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Root cause analysis of package damage incidents

Sample rows

preview · 8 of 55 rows · all 30 columns
incident_idstringdamage_severitystringcompensation_amountfloatinsurance_claim_filedbooleanlocation_statestringpackage_idstringshipment_idstringincident_datetimedatetimereported_bystringreporting_rolestringdamage_typestringlocation_typestringlocation_namestringlocation_street_addressstringlocation_citystringlocation_postal_codestringlocation_countrystringsuspected_causestringphotos_availablebooleanclaim_idstringresolution_statusstringresolution_datedatecarrier_namestringpackage_weight_kgfloatpackage_dimensions_cm_lfloatpackage_dimensions_cm_wfloatpackage_dimensions_cm_hfloatpackage_contents_descriptionstringdamage_descriptionstringresolution_descriptionstring
INC100001moderateblankfalseVAPKG3001SHP50012023-03-18T11:34:00Samuel Owensdrivercrushedin_transitI-95 Route Stop 1377 Interstate AveRichmond23220USAimproper_handlingtrueblankinvestigatingblankTransAtlantic Logistics7.2432918Books and educational materialsBox was found compressed at the bottom of the truck stack.blank
INC100002minor0falseTXPKG3002SHP50022023-03-19T16:12:00Patricia Leewarehouse_staffwetwarehouseDallas Fulfillment Center123 Commerce DrDallas75201USAweatherfalseblankresolved2023-03-20SwiftLine Express3.5332314T-shirts (cotton)Minor water stains at package base detected during unloading.Package repackaged and dried. Contents unaffected.
INC100003severe78.5trueNYPKG3003SHP50022023-03-20T10:47:00Evan TorrescourierpunctureddeliveryBroadway 56 Dropoff56 BroadwayNew York10012USAequipment_failuretrueCLM4001compensation_issued2023-03-25ArrowShip1.9281812Bluetooth headphonesTwo holes found in box, contents partially exposed.Compensation processed for damaged goods.
INC100004moderateblanktrueOHPKG3004SHP50032023-03-21T08:23:00Customer-9245customertorncustomer_siteResidence - 15 Oak St15 Oak StCleveland44113USAunknowntrueCLM4002investigatingblankPackPlus Delivery6.4402613Board game and accessoriesOuter packaging torn, some items missing.Investigation pending with carrier.
INC100005severe102trueCAPKG3005SHP50042023-03-22T13:15:00Rosa Huertawarehouse_staffcrushedwarehouseSan Jose Distribution Hub778 Market StSan Jose95110USAequipment_failuretrueCLM4003closed2023-03-29TransAtlantic Logistics12.8523826Kitchen blenderBox severely crushed after forklift incident.Claim settled, warehouse staff retrained.
INC100006minor0falseTNPKG3006SHP50052023-03-22T18:50:00Gregory Milesdrivertornin_transitSouthway Expressway Stop 2201 Southway DrMemphis38103USAimproper_handlingfalseblankresolved2023-03-23ArrowShip2.7251511Children's clothingSmall tear on side, no internal damage.Tape applied, no compensation necessary.
INC100007moderateblanktrueNCPKG3007blank2023-03-23T09:06:00Customer-5874customermissing_itemscustomer_siteResidence - 112 Maple Ave112 Maple AveCharlotte28202USAunknownfalseCLM4004openblankSwiftLine Express4.2362716Kitchen utensils setCustomer reported missing items upon opening.blank
INC100008minor0falseWAPKG3008SHP50062023-03-24T15:22:00Irene B.warehouse_staffwetwarehouseSeattle Consolidation900 Explorer AveSeattle98109USAweatherfalseblankresolved2023-03-24PackPlus Delivery8.1463117Coffee mugs (set of 6)Outer plastic wrap damp, no visible product damage.Package dried and restocked.

What the 55 rows show

from the 55-row sample

Severe (damage severity) stands out: 10 of its 10 rows have insurance_claim_filed = true, against 8 of 45 for the rest.

  • 33%insurance_claim_filed = true
  • 0.0median compensation_amount
  • 4location types
  • 5reporting roles
  • 5resolution statuses
  • 6damage types
Insurance claim filed rate by damage_severityinsurance_claim_filed = true
0%50%100%0%minor0 of 2225%moderate5 of 20100%severe10 of 10100%destroyed3 of 3

Severe (damage severity)'s mean compensation_amount is 82.0, against 0.64 for minor, 11.6 for moderate and 146.1 for destroyed.

compensation_amount34 rows, in bands of 20
0153025112120110100180compensation_amount →

Median 0.0, from 0.0 to 167.5.

location_state55 rows · top 10 of 23 values
  1. TX7
  2. OH4
  3. CA4
  4. NC4
  5. WA4
  6. TN3
  7. MO3
  8. FL3
  9. NY2
  10. CO2
30 columns by typefrom the column list below
  • string 21
  • float 5
  • date 1
  • datetime 1
  • boolean 2

Columns

30 columns in four groups
blueprint · 30 columns
columntypedescriptionexample
Text 21 columns
incident_idstringUnique identifier for each package damage incident record.uniqueINC100001
package_idstringUnique identifier for the package involved in the incident.PKG3001
shipment_idstringIdentifier for the shipment containing the damaged package.optionalSHP5001
reported_bystringName or identifier of the person who reported the incident.optionalSamuel Owens
reporting_rolestringRole of the person reporting the incident (e.g., driver, warehouse staff, customer).driver · warehouse_staff · customer · courier · other · optionaldriver
damage_typestringType of damage observed (e.g., crushed, wet, torn, punctured, missing items).6 valuescrushed
damage_severitystringSeverity level of the damage (e.g., minor, moderate, severe, destroyed).minor · moderate · severe · destroyedmoderate
damage_descriptionstringDetailed description of the damage and its circumstances.optionalBox was found compressed …
location_typestringType of location where the damage was discovered (e.g., warehouse, transit, delivery, customer site).warehouse · in_transit · delivery · customer_site · otherin_transit
location_namestringName or identifier of the specific location (e.g., warehouse name, city, facility code).optionalI-95 Route Stop 13
location_street_addressstringStreet address where the damage was discovered.optional77 Interstate Ave
location_citystringCity where the damage was discovered.optionalRichmond
location_statestringState or province where the damage was discovered.optionalVA
location_postal_codestringPostal code of the location where the damage was discovered.optional23220
location_countrystringCountry where the damage was discovered.optionalUSA
suspected_causestringSuspected cause of the damage (e.g., improper handling, packaging failure, weather, unknown).6 values · optionalimproper_handling
claim_idstringIdentifier for the associated insurance claim, if any.optionalCLM4001
resolution_statusstringCurrent status of the incident resolution (e.g., open, investigating, resolved, closed, compensation issued).5 valuesinvestigating
resolution_descriptionstringDetails of actions taken to resolve the incident.optionalPackage repackaged and dr…
carrier_namestringName of the carrier or shipping company responsible for the package at the time of damage.optionalTransAtlantic Logistics
package_contents_descriptionstringDescription of the contents of the damaged package.optionalT-shirts (cotton)
Numbers 5 columns
compensation_amountfloatAmount of compensation issued for the damage, if applicable.0 or more · optional0
package_weight_kgfloatWeight of the damaged package in kilograms.0 or more · optional7.2
package_dimensions_cm_lfloatLength of the package in centimeters.0 or more · optional43
package_dimensions_cm_wfloatWidth of the package in centimeters.0 or more · optional29
package_dimensions_cm_hfloatHeight of the package in centimeters.0 or more · optional18
Dates and times 2 columns
incident_datetimedatetimeDate and time when the damage incident was reported or discovered.2023-03-18T11:34:00
resolution_datedateDate when the incident was resolved or closed.optional2023-03-20
True or false 2 columns
photos_availablebooleanIndicates if photos of the damage are available.optionaltrue
insurance_claim_filedbooleanIndicates if an insurance claim was filed for this incident.optionalfalse

Use it for

  • insurance clai…33%18 of 55 rowsmean compensation amo…0.64minor11.6mode…82.0seve…146.1dest…

    A logistics dashboard

    The insurance_claim_filed rate, compensation_amount by damage_severity and a breakdown of location_state. Excel, Power BI or Tableau.

  • Why do 18 of 55 rows have insurance_claim_filed = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable incidents with package_id, shipment_id and incident_datetime to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 30 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset55 rows30 columns
Yours1,000 rows30 columnslocation_type: UK only

blueprint · package-damage-incident-records

Behind this dataset

Same schema. As many rows as you need.

These 55 rows came out of a blueprint — 30 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
  • Record incident date and package ID
  • Log type and cause of damage
  • Flag repeat incidents by route
  • Summarize monthly incident rates
  • Differentiate between supplier and carrier damage
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
package-damage-incident-records

More in Logistics

Browse all
Also in LogisticsLogistics Delivery Delay CausesLogistics Shipment Delay PredictionSupply Chain Delivery Delay LogsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.