Hancock Public Health Department (DBA/HANCOCK PUBLIC HEALTH) (FP458401)
Title X family planning clinic, Ohio, calendar year 2025. Everything below is as the workbook stored it, with figures shown to the cent. Each section follows the Ohio Department of Health's template, in its order and words.
The name is HRSA's, from its public list of covered entities read on 11 November 2026. The workbook prints the 340B ID and no name.
About this workbook
- 340B ID
- FP458401 Hancock Public Health Department (DBA/HANCOCK PUBLIC HEALTH) (Title X family planning clinic)
- Reporting period as typed
- January 1, 2025 - December 31, 2025
- Form
- Ohio Department of Health, ORC 3701.88 340B Covered Entity Reporting Template, calendar year 2025
Drugs dispensed in house
Drugs the covered entity dispensed through its own pharmacies.
| Row of the template | Commercial Insurance/Private Insurance | Medicare | Medicaid (all states) | Other Third-Party Payor | Uninsured/Self-Pay | Total |
|---|---|---|---|---|---|---|
| Acquisition costAggregate Acquisition Cost for all 340B drugs dispensed by the Covered Entity | $0 | $0 | $0 | $0 | $0 | $0 |
| Payments receivedAggregate Payments Received for all 340B drugs dispensed by the Covered Entity | $0 | $0 | $0 | $0 | $0 | $0 |
| All prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B and non-340B) | 0 | 0 | 0 | 0 | 0 | 0 |
| 340B prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B) | 0 | 0 | 0 | 0 | 0 | 0 |
| Percentage that were 340BPercentage of total prescriptions that were 340B | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
Drugs dispensed through contract pharmacies
Drugs contract pharmacies dispensed on behalf of the covered entity.
| Row of the template | Commercial Insurance/Private Insurance | Medicare | Medicaid (all states) | Other Third-Party Payor | Uninsured/Self-Pay | Indeterminate (Explain) | Total |
|---|---|---|---|---|---|---|---|
| Acquisition costAggregate Acquisition Cost for all 340B drugs dispensed by all Contract Pharmacies on behalf of the Covered Entity above: | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Payments receivedAggregate Payments Received for all 340B drugs dispensed by all Contract Pharmacies on behalf of the Covered Entity above: | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| All prescriptionsTotal number of Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity (340B and non-340B): | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 340B prescriptionsTotal number of 340B Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity: | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Percentage that were 340BPercentage of total Covered-Entity associated prescriptions that were 340B: | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
Drugs administered
Drugs the covered entity administered, for example by infusion or injection.
| Row of the template | Commercial Insurance/Private Insurance | Medicare | Medicaid (all states) | Other Third-Party Payor | Uninsured/Self-Pay | Total |
|---|---|---|---|---|---|---|
| Acquisition costAggregate Acquisition Cost for all 340B drugs administered by the Covered Entity | $70.40 | $0 | $1,152.30 | $0 | $915.20 | $2,137.90 |
| Actual paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - Actual Payments | $144 | $0 | $0 | $0 | $86.40 | $230.40 |
| Estimated paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - Estimated Payments* | $0 | $0 | $0 | $0 | $0 | $0 |
| Total paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - TOTAL | $0 | $0 | $0 | $0 | $0 | $0 |
| All prescriptionsTotal number of Prescriptions administered by the Covered Entity (340B and non-340B) | Withheldfewer than 6 | 0 | Withheldfewer than 6 | 0 | 24 | 30 |
| 340B prescriptionsTotal number of Prescriptions administered by the Covered Entity (340B) | Withheldfewer than 6 | 0 | Withheldfewer than 6 | 0 | 24 | 30 |
| Percentage that were 340BPercentage of total prescriptions that were 340B | Withheldwould show a small count | #DIV/0! | Withheldwould show a small count | #DIV/0! | 100% | 100% |
Figures are shown to the cent. The downloads keep each figure exactly as it is written in the file, and the cell file lists the workbook cell each one was read from.
Cells marked Withheld. A count of prescriptions from 1 to 5 is never published, and neither is a figure that would let a reader work one out.
- The count of prescriptions is 1 to 5. A count that small is never published, here or in the data files.
- The percentage would let a reader work out a count of 1 to 5 in another cell.
Costs of running the program
Amounts in US dollars, as the workbook stores them.
| Cost | Amount | Cell |
|---|---|---|
| Contract pharmacies | $0 | C46 |
| Third-party administrators | $0 | C47 |
| Consultants | $0 | C48 |
| Software and IT | $0 | C49 |
| Other outside costs | $0 | C50 |
| Staffing | $0 | C53 |
| Internal IT | $0 | C54 |
| Other internal costs | $0 | C55 |
Contract pharmacies
- Number of contract pharmacies as typed
- -
The filer in the workbook
- 340B ID as typed
- FP458401, STD458401, TB45840
- NPIs as typed
- 1578923298
Differences in this workbook
This workbook has 3 places where two of its figures differ. Nothing was changed; both figures are kept as stored.
Administered drugs, commercial column: total payments equal actual payments plus estimated payments
- Expected
- 144
- Stored
- 0
- Difference
- -144
Administered drugs, commercial column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 144.00.
The form itself says the two figures agree. Rule
administered_payments_total.commercial=actual+estimatedin Methods.Administered drugs, uninsured column: total payments equal actual payments plus estimated payments
- Expected
- 86.4
- Stored
- 0
- Difference
- -86.4
Administered drugs, uninsured column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 86.40.
The form itself says the two figures agree. Rule
administered_payments_total.uninsured=actual+estimatedin Methods.Administered drugs, total column: total payments equal actual payments plus estimated payments
- Expected
- 230.4
- Stored
- 0
- Difference
- -230.4
Administered drugs, total column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 230.40.
The form itself says the two figures agree. Rule
administered_payments_total.total=actual+estimatedin Methods.
Source
- Workbook
- Open FP458401.xlsx on the Ohio Department of Health's website
- Size
- 21 KB
- Retrieved
- 16 November 2026
- SHA-256
- 2e84f4d4df5f38c83251754484f186c4b3dcbff6a95fe22e9a16eb7fe3b5979b
- How it was read
- Two separate programs read each cell of the workbook, and a value is kept when their reads agree. The cells of this workbook are listed one by one in the dataset repository.