HAMILTON COUNTY General Health District (TB CONTROL CLINIC) (TB452022 and STD452191)
Tuberculosis 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 IDs
- TB452022 HAMILTON COUNTY General Health District (TB CONTROL CLINIC) (Tuberculosis clinic)
- STD452191 Hamilton County General Health District (Sexually transmitted disease 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 | $30,318.07 |
| 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) | 156 | 55 | 245 | 135 | 774 | 1,365 |
| 340B prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B) | 156 | 55 | 245 | 135 | 774 | 1,365 |
| Percentage that were 340BPercentage of total prescriptions that were 340B | 100% | 100% | 100% | 100% | 100% | 100% |
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: | $43 | $0 | $0 | $0 | $150.48 | $0 | $193.48 |
| Payments receivedAggregate Payments Received for all 340B drugs dispensed by all Contract Pharmacies on behalf of the Covered Entity above: | $216.77 | $0 | $0 | $0 | $0 | $0 | $216.77 |
| All prescriptionsTotal number of Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity (340B and non-340B): | 6 | 0 | 0 | 0 | 24 | 0 | 30 |
| 340B prescriptionsTotal number of 340B Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity: | 6 | 0 | 0 | 0 | 24 | 0 | 30 |
| Percentage that were 340BPercentage of total Covered-Entity associated prescriptions that were 340B: | 100% | #DIV/0! | #DIV/0! | #DIV/0! | 100% | #DIV/0! | 100% |
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 | $0 | $0 | $0 | $0 | $0 | $249.33 |
| Actual paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - Actual Payments | $0 | $0 | $0 | $0 | $0 | $0 |
| 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) | 0 | 0 | 0 | 0 | 0 | 0 |
| 340B prescriptionsTotal number of Prescriptions administered by the Covered Entity (340B) | 0 | 0 | 0 | 0 | 0 | 230 |
| Percentage that were 340BPercentage of total prescriptions that were 340B | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | 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.
Costs of running the program
Amounts in US dollars, as the workbook stores them.
| Cost | Amount | Cell |
|---|---|---|
| Contract pharmacies | $1,010.35 | C46 |
| Third-party administrators | $0 | C47 |
| Consultants | $0 | C48 |
| Software and IT | $0 | C49 |
| Other outside costs | $0 | C50 |
| Staffing | time of 2 directors and 1 pharmacist | C53 |
| Internal IT | $0 | C54 |
| Other internal costs | - | C55 |
Contract pharmacies
- Number of contract pharmacies as typed
- 1
Uses of 340B funds
What the filer typed under the template's questions about how it uses the money 340B brings in. A dash or an empty cell is left out.
Narrative, as typed
The filer in the workbook
- 340B ID as typed
- TB452022, STD452191
- NPIs as typed
- 1194859694
- 1245688951
Cells outside the template
The filer typed text in cells the template does not ask for. They are listed as found, by cell.
| Cell | Text |
|---|---|
| D46 | note, this is owed but not yet paid |
Differences in this workbook
This workbook has 3 places where two of its figures differ. Nothing was changed; both figures are kept as stored.
The five payer cells of aggregate acquisition cost dispensed in house add up to the Total cell
- Expected
- 0
- Stored
- 30,318.07
- Difference
- 30,318.07
Aggregate acquisition cost, dispensed in house. The total cell holds 30,318.07. The five payer cells add to 0.00.
The form itself says the two figures agree. Rule
in_house_acquisition_cost.rows=totalin Methods.The five payer cells of aggregate acquisition cost administered add up to the Total cell
- Expected
- 0
- Stored
- 249.33
- Difference
- 249.33
Aggregate acquisition cost, administered drugs. The total cell holds 249.33. The five payer cells add to 0.00.
The form itself says the two figures agree. Rule
administered_acquisition_cost.rows=totalin Methods.The five payer cells of 340B prescriptions administered add up to the Total cell
- Expected
- 0
- Stored
- 230
- Difference
- 230
340b prescriptions, administered drugs. The total cell holds 230. The five payer cells add to 0.
The form itself says the two figures agree. Rule
administered_rx_340b.rows=totalin Methods.
Source
- Workbook
- Open TB452022STD452191.xlsx on the Ohio Department of Health's website
- Size
- 22 KB
- Retrieved
- 16 November 2026
- SHA-256
- e588bd677bd510f344b1cd927e40b1a821589f1d5f7339c72831a78b4c815da0
- 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.