Attachment C Three-Digit Zip Code Analysis.xlsx

This is a Network Provider Coverage and Geographic Access Analysis template spreadsheet consisting of two worksheets. The first worksheet requires respondents to indicate their network provider counts across multiple provider types (Primary Care Physicians, OB/GYN, Pediatricians, Specialists, Hospitals, BHSA, Outpatient facilities, Urgent Care, Convenient Care, Physician Assistants, Nurse Practitioners, and Alternative Care Providers) for approximately 250 three-digit ZIP code locations.

The second worksheet focuses on geographic access analysis, requiring respondents to report employee counts and percentages meeting/not meeting access standards for Hospitals, Primary Care Physicians, OB/GYN, and Pediatricians. The access standards are defined by urban (within 8-10 miles), suburban (within 15 miles), and rural (within 30 miles) areas, with specific population density criteria for each category. Urban areas are defined as having more than 3,000 persons per square mile, suburban areas between 1,000-3,000 persons per square mile, and rural areas less than 1,000 persons per square mile.