Exhibit_G_-_Claims_Summary_(Tristar).xlsx

The document is an Excel spreadsheet titled "Exhibit G - Claims Summary" for Collin County, Texas, containing a comprehensive record of insurance claims from October 1, 2004, to March 13, 2024. The claims summary details a solicitation for excess liability insurance coverage, seeking a three-year contract with options for two additional one-year extensions. Collin County is currently self-insured and is requesting proposals for excess liability coverage across multiple domains, including commercial crime, professional liability, public officials errors and omissions, law enforcement liability, and pollution coverage. The county is specifically interested in four coverage scenarios: $3,000,000 coverage with self-insured retentions (SIR) of $1,000,000 and $2,000,000, and $5,000,000 coverage with SIRs of $1,000,000 and $2,000,000.

The claims summary spreadsheet provides an extensive historical record of insurance claims, categorized by type (general liability, auto, etc.), with detailed financial information including total paid amounts, recoveries, and incurred costs. The document reflects a wide range of incidents, from property damage and bodily injury to law enforcement-related claims and civil rights violations. While the spreadsheet does not directly outline pricing for the new insurance contract, it serves as a comprehensive risk assessment tool that potential insurers would likely use to evaluate coverage terms and pricing. The claims data spans multiple policy years and demonstrates the county's ongoing risk management approach, with claims ranging from minor property damage to more significant personal injury and liability incidents.