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

LAKE COUNTY HEALTH DEPARTMENT & COMMUNITY HEALTH CENTER

UEI PQ96R3K1MRJ1 · IL · local · FY 2024-12-01 → 2025-11-30
FY2025: Not yet due

overdue for FY2022, FY2023, FY2024 ($82.6M observed); FY2026 not yet due.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Not yet due partial$4.8M $1.0Moutlays 64% + pass-through 36%2027-08-30
2025Not yet due $9.0M $1.0Moutlays 69% + pass-through 31%2026-08-30
2024Overdue $18.8M $750Koutlays 49% + pass-through 51%2025-08-30341d past due
2023Overdue $29.2M $750Koutlays 31% + pass-through 69%2024-08-30706d past due
2022Overdue $34.7M $750Koutlays 26% + pass-through 74%2023-08-301072d past due
Obligation
$4.9M
Outlay
$6.2M
Subaward recv
$2.7M
Subaward passed
$0
Loan face value
$0
Awards
6
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Health Resources and Services Administration HHS$4.8M$5.6M$230K$0$0
Substance Abuse and Mental Health Services Administration HHS$125K$97K$1.4M$0$0
Centers for Disease Control and Prevention HHS$0$1.0M$0$0
HHS, component not specified HHS$0$0$0$0
Non-HHS federal money $0$494K$32K$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
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 = 'W2VMR6ZKNT21'      -- this entity's parent
  AND related_uei <> 'PQ96R3K1MRJ1';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
COUNTY OF LAKE
LSLMZB9M4329
Under threshold$427K
E9VVL1BEA5A1
E9VVL1BEA5A1
Under threshold$407K
GJ17QBVW3WR6
GJ17QBVW3WR6
LMFNNQBGU6A9
LMFNNQBGU6A9
RB38FRXQZKJ5
RB38FRXQZKJ5