Summary

This is a claims data spreadsheet for Coastal Carolina University's student accident insurance program, documenting insurance claims filed between August 2014 and March 2019. The dataset contains 747 individual claim records organized by policy number (9497310 and 9153237) and includes comprehensive information on loss dates, claim receipt dates, claim status (open, closed, or under review), and associated costs. Claims are primarily related to student-athlete injuries sustained during sponsored athletic activities including football, soccer, basketball, volleyball, lacrosse, and track and field, though the dataset also includes non-athletic injuries to students on campus. The policy periods covered span from August 1, 2014 through August 1, 2019, with claims ranging from minor injuries such as sprains and contusions to more serious injuries including ACL tears, concussions, and fractures.

The claims database tracks financial data including indemnity paid, indemnity outstanding, medical paid, medical outstanding, legal paid, legal outstanding, and recovery amounts. Total medical expenses across sampled claims range from zero to over $13,000 per claim, with numerous claims showing significant medical costs and some claims generating legal fees. The data indicates that Coastal Carolina University sought to re-bid its student accident insurance coverage through this procurement, suggesting the institution manages risk through commercial insurance rather than self-insurance. The comprehensive nature of the claims data and detailed injury descriptions suggest this spreadsheet was prepared to support the re-bidding process by providing potential insurers with historical loss experience, frequency of claims, and cost patterns necessary for accurate premium quotation.