Exhibit_I_-_Claims_Summary_$100,000_and_Greater_(1).xlsx

XLSX spreadsheet 13 KB Posted

Attached to
Excess Liability Insurance
Solicitation number
2024-316
Issued by
Collin County, Texas

About this file

The document is an Exhibit I Claims Summary spreadsheet for Collin County, Texas, detailing liability losses exceeding $100,000 from October 1, 2014, to October 1, 2022. Collin County is seeking a three-year excess liability insurance contract with options for two additional one-year extensions, specifically targeting coverage for commercial crime, professional liability, public officials errors and omissions, employment practices, employee benefits administration, law enforcement liability, and pollution. The county is currently self-insured and is requesting proposals for excess liability coverage with multiple self-insured retention (SIR) options, including $3,000,000 coverage with SIRs of $1,000,000 and $2,000,000, as well as $5,000,000 coverage with SIRs of $1,000,000 and $2,000,000.

The claims summary reveals significant historical liability events, including jail-related incidents, employment discrimination claims, and medical treatment allegations, with total claim amounts ranging from $150,000 to $1,083,779. The most substantial claims involve jail deaths, EEOC discrimination charges, and potential medical negligence, indicating a complex risk profile that likely drives the county's interest in comprehensive excess liability insurance. The spreadsheet documents closed and open claims across various liability categories, suggesting the county's proactive approach to risk management and insurance coverage strategies.

View the file

Other files

File Type Posted
Excess_Liability_Insurance_(Addendum_#10_Revision).pdf PDF
CIQ_-3-22-24.pdf PDF
Exhibit_W-Ambridge_Partners_LLC_-_SIR_Package_Application-Coverage_Summary.pdf PDF
W9.pdf PDF
Exceptions.docx DOCX document
Exhbit_Y-Ambridge_Partners_LLC-SIR_Package_Application-Exposure_Summary.pdf PDF
Exhibit_AA-Ambridge_Partners_LLC_-_SIR_Package_Application-Employment_Practices.pdf PDF
Exhibit_AC-Ambridge_Partners_LLC_-_SIR_Package_Application-Outsourcing.pdf PDF
Exhibit_AB-Ambridge_Partners_LLC_-_SIR_Package_Application-TIV-NOE-WC.pdf PDF
Exhibit_X-Ambridge_Partners_LLC_-_SIR_Package_Application-Risk_Management.pdf PDF
Exhibit_Z-Ambridge_Partners_LLC_-_SIR_Package_Application-Exposure_Detail.pdf PDF
[M]_LEGAL_NOTICE_TEMPLATE-RFP.doc DOC document
EXHIBIT_Q-COM_Food_Inspection_Report_(Mon_Jul_1,_2024_at_221_PM)_-_MS.pdf PDF
EXHIBIT_U-Inspection_MFD-2023-0000511-1.pdf PDF
Ehibit_L-Tank_Schedule_-_for_updates_(006).XLSX XLSX spreadsheet
Exhibit_K-_1._Law_Enforcement_Liability_Application_Juvenile_Detention_(002).pdf PDF
Exhibit_O-Annual_Jail_Report_2024.pdf PDF
Exhibit_S-COM_Food_Inspection_Report_(Mon_Mar_11,_2024_at_1014_AM)_-_Staff_Dinning.pdf PDF
Exhibit_V-Wellpath_Revised_Staffing_Plan_-_FINAL.pdf PDF
Exhibit_T-Comprehensive_Inspection_Report_2024.pdf PDF
EXHIBIT_N-Collin_TX_2024_2-28_Redacted.pdf PDF
Exhibit_P-_COM_Food_Inspection_Report_(Mon_Jul_1,_2024_at_220_PM)_-_MJ.pdf PDF
Ehibit_M-Tank_Schedule.XLSX XLSX spreadsheet
Exhibit_J-1._Law_Enforcement_Liability_Application.pdf PDF
Exhibit_R-COM_Food_Inspection_Report_(Mon_Jul_1,_2024_at_223_PM)_-_MM.pdf PDF
Attachment_D-Crime_Policy.pdf PDF
Exhibit_A_-_Over_the_Road_Fleet_Schedule.xlsx XLSX spreadsheet
Exhibit_D_-_Jail_Inspection_Report.pdf PDF
Exhibit_F_-_Court_Order_for_Outsourced_Inmate_Medical.pdf PDF
Exhibit_G_-_Claims_Summary_(Tristar).xlsx XLSX spreadsheet
Exhibit_H_-_Claims_Summary_(Intact)_(1).xlsx XLSX spreadsheet
Exhibit_B_-_2024_Bond_Schedule.xlsx XLSX spreadsheet
Exhibit_C_-_Collin_County_Employee_Handbook.pdf PDF
Exhibit_E-_Armored_Car_Bank_Deposits.xlsx XLSX spreadsheet
Attachment_B-Excess_Liability_Pricing_7.10.xlsx XLSX spreadsheet
Attachment_C__Excess_Liability_Questionnaire_and_Market_Survey.docx DOCX document
Attachment_A_Excess_Liability_Questionnaire.xlsx XLSX spreadsheet
Show all 37

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1

Exhibit I - Claims Summary $100,000 and Greater
Collin County Incurred Liability Losses $100,000 & Greater 10-1-14 to 10-1-22 as of 3-25-24
AgePolicy Effective DateCause of Accident Description 1Claim DescriptionClaim StatusClaim SuffixClaim TotalClaimant NumberClosed DateCreation DateDate of LossDate ReportedDeductible RecoveryExpenses PaidExpiration DateLegal ExpensesLocation DescriptionLoss PaidLoss ReserveLoss Type DescriptionNet IncurredNo. of DaysOccupation CodePolicy Period ID
2810/1/20LEL - Excessive Force/Deadly ForceJail DeathClosed1$ 1,083,77916/16/233/14/213/14/213/17/21056210/1/21$ 83,217Collin County Jail$ 1,000,000$ - 0GL BODILY INJURY1083217821441232
4810/1/21XS Public Officials EPLEEOC - Clmt alleges discriminationClosed1$ 750,00014/12/238/10/227/15/228/10/220010/1/22$ - 0$ 750,000$ - 0EXCESS GL - BODILY INJURY750000245999332
4810/1/21EPL - EEOC Charge OtherEEOC - Clmt alleges discriminationClosed1$ 539,49416/26/238/10/227/15/228/10/2203010/1/22$ 39,464$ 500,000$ - 0EMPLOYMENT PRACTICES LIABILITY539464320441232
2810/1/20XS Law Enforcement Wrongful ActJail DeathClosed1$ 500,00016/15/233/14/213/14/2112/9/210010/1/21$ - 0Collin County Jail$ 500,000$ - 0EXCESS GL - BODILY INJURY500000553999332
3110/1/21EPL - EEOC Charge OtherEEOC - Clmt alleges discriminationClosed4$ 200,00046/26/238/10/227/15/228/10/220010/1/22$ - 0$ 200,000$ - 0EMPLOYMENT PRACTICES LIABILITY200000320441232
4010/1/18LEL - Confinement Medical TreatmentPlaintiff alleges miscarriage due to delay in medical treatmentOpen1$ 170,30017/5/197/5/196/10/21030010/1/19$ - 0Collin County Jail$ - 0$ 170,000GL BODILY INJURY1700001019441232
4010/1/21EPL - EEOC Charge OtherEEOC - Clmt alleges discriminationClosed5$ 150,00056/26/238/10/227/15/228/10/220010/1/22$ - 0$ 150,000$ - 0EMPLOYMENT PRACTICES LIABILITY150000320441232

File details come from the government source that posted it. Updated .