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

CITY OF CHICAGO

UEI LMPLBULLMS41 · IL · local · FY 2025-01-01 → 2025-12-31
FY2025: Under threshold

covered by another audit for 1 year; 1 year undetermined.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Under threshold partial$4K $1.0M2027-09-30
2025Under threshold $335K $1.0M2026-09-302025-12-GSAFAC-0000424030 ↗
2024Under threshold $52K $750K2025-09-302024-12-GSAFAC-0000374787 ↗
2023Undetermined $392K $750Kpass-through 100% (outlay unknown)2024-09-302023-12-GSAFAC-0000050009 ↗
2022Covered by parent $1.0M $750Kpass-through 100% (outlay unknown)2023-09-302022-12-CENSUS-0000138815 ↗
Obligation
$0
Outlay
$150K
Subaward recv
$185K
Subaward passed
$0
Loan face value
$0
Awards
0
▲ pass-through money only
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Substance Abuse and Mental Health Services Administration HHS$0$185K$0$0
Non-HHS federal money $0$150K$0$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 = audit_coverage

Whose single audit accounts for this entity, and whose this entity accounts for. The LINKS are standing — they apply to every year, and a gap in the observed span is a gap in FAC reporting, not a year the entity stood alone. The rolled AMOUNTS below follow the selected fiscal year, so the entity count there can be smaller than the standing list.

Covered by
CITY OF CHICAGO 2025-12-GSAFAC-0000424030 ↗
Standing link — declared from fac, observed FY2022–FY2025. This entity is not independently delinquent in any year; the coverer carries the filing obligation.
This entity’s audit covers
Nothing — no other entity relies on this one’s audit.
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
CHICAGO CITY OF P5L3RMDLELN1
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 = 'P5L3RMDLELN1'      -- this entity's parent
  AND related_uei <> 'LMPLBULLMS41';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
CITY OF CHICAGO
NDHBBJ4B1LN5
16Filed$207.0M
CHICAGO DEPARTMENT OF PUBLIC HEALTH
K8F7VYLKGN64
Covered by parent$173.5M
CHICAGO, CITY OF
V99FJ8MSDB43
Covered by parent$128.4M
CITY OF CHICAGO
XT2RYMAAZCY4
Covered by parent$89.1M
CHICAGO DEPARTMENT OF TRANSPORTATION
NFECXMGA3MJ4
Covered by parent$49.9M
CITY OF CHICAGO
FVGJNZXDWVV3
Covered by parent$42.9M
CITY OF CHICAGO
P138LY34M6L6
Covered by parent$31.8M
CITY OF CHICAGO
FMFXFBMYHL37
Covered by parent$14.2M
CITY OF CHICAGO FIRE DEPARTMENT
SF6NEGGTK8U7
Covered by parent$1.7M
CITY OF CHICAGO
G1C1FJAM8CN1
Under threshold$198K
CITY OF CHICAGO
H51WMHGAE8E8
Under threshold$75K
CHICAGO, CITY OF
KQ1JP8NRPGD6
Under threshold$705
CITY OF CHICAGO DEPARTMENT OF ENVIRONMENT
LXDMZNNLAKR3
Undetermined$0
CITY OF CHICAGO DEPARTMENT OF PLANNING AND DEVELOPMENT
MGP9V14KFTR6
Undetermined$0
ELL5KBARX1F4
ELL5KBARX1F4
HYBMGLK3BWD1
HYBMGLK3BWD1