PROTOTYPE — Not for official use. Data and outputs are for demonstration only and do not constitute official HHS determinations.
← delinquency review

COUNTY OF HAMILTON, OHIO

UEI ZC2HNMHB1RJ5 · OH · local · FY 2025-01-01 → 2025-12-31
FY2025: Not yet due

Filed 3 years (FY2022–FY2024); FY2026 not yet due.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2027Under threshold partial$165K $1.0M2028-09-30
2026Not yet due partial$12.6M $1.0Moutlays 69% + pass-through 31%2027-09-30
2025Not yet due $43.4M $1.0Moutlays 21% + pass-through 79%2026-09-30
2024Filed $76.1M $750Koutlays 14% + pass-through 86%2025-09-300$167.3M45% 2024-12-GSAFAC-0000380339 ↗
2023Filed $86.5M $750Koutlays 9% + pass-through 91%2024-09-300$182.6M47% 2023-12-GSAFAC-0000053364 ↗
2022Filed $201.0M $750Koutlays 84% + pass-through 16%2023-09-30-5$178.2M113% 2022-12-CENSUS-0000162455 ↗
Obligation
$7.4M
Outlay
$9.2M
Subaward recv
$34.2M
Subaward passed
$0
Loan face value
$0
Awards
14
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Substance Abuse and Mental Health Services Administration HHS$7K$199K$0$0$0
Administration for Children and Families HHS$0$16.2M$0$0
Centers for Medicare and Medicaid Services HHS$0$10.1M$0$0
Non-HHS federal money $7.4M$9.0M$7.9M$0$0

Relationships

Three independent link types, one card each. They overlap — the same money can appear under more than one, so never add them together.

link_type = corporate_parent

From SAM.gov registration: the headquarters an entity registered under, and the entities registered beneath it. A registration record, not an org chart — it does not mean the parent runs the entity’s programs. The link itself never changes, but the lists below follow the selected year: an entity only appears in years it had federal activity.

Rolls up to
HAMILTON, COUNTY OF JKAKE55CKTY1
Rolls up to this entity
Nothing — no entity rolls up to this one.
derived — not a link_type

Not a stored relationship. These entities are found by taking this entity’s parent and looking up everything else registered under it — so they will not appear in any row keyed to this entity’s own UEI. Shown because the coverage lead above rests on them: if a sibling provably covers other entities, it may account for this one too.

Show the query
SELECT related_uei, link_type FROM pub.entity_link
WHERE link_type = 'corporate_parent'
  AND uei = 'JKAKE55CKTY1'      -- this entity's parent
  AND related_uei <> 'ZC2HNMHB1RJ5';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
COUNTY OF HAMILTON
UNJJLXHEEND8
Not yet due$6.8M
COUNTY OF HAMILTON
M775R3QW1X11
Not yet due3$5.6M
HAMILTON COUNTY SHERIFF DEPARTMENT
CF7NND3CKGP4
Under threshold2$207K
YQX6WP6K7SB4
YQX6WP6K7SB4