Census_-_Dane_County_9.16.26.xlsx

This is a census spreadsheet documenting Short-Term/Long-Term Disability (STD/LTD) and Long-Term Disability Only (LTD Only) coverage for Dane County employees as of September 16, 2026. The file contains detailed employee records including 1,057 county staff members across various departments and job classifications, with data fields capturing person code, birth date, hire date, job title, full-time equivalent (FTE) status, wage rate, zip code, gender, and disability coverage type.

The spreadsheet reveals that the majority of Dane County employees (approximately 94 percent) are enrolled in combined STD/LTD plans with either a two- or three-tier wage replacement structure, while a smaller subset (approximately 6 percent) are enrolled in LTD Only coverage. Wage rates across the county workforce range from approximately $26.93 to $196.50 per hour, reflecting positions spanning from entry-level support staff to executive leadership roles such as the Chief Medical Examiner and County Executive. The data indicates comprehensive disability coverage integration across all county operational units, with no apparent gaps in employee coverage, and demonstrates the county's significant human resources footprint across multiple functional areas including public health, public safety, social services, courts, and administrative operations.