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

SONOMA COUNTY

UEI MA5MFLZKNJR3 · CA · local · FY 2023-07-01 → 2024-06-30
FY2024: Under threshold

.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2024Under threshold $455K $750K2025-03-302024-06-GSAFAC-0000357040 ↗
2023Under threshold $734K $750K2024-03-302023-06-GSAFAC-0000033081 ↗
2022Under threshold $495K $750K2023-03-302022-06-CENSUS-0000184744 ↗
Obligation
$-11K
Outlay
$258K
Subaward recv
$197K
Subaward passed
$0
Loan face value
$0
Awards
1
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Non-HHS federal money $-11K$258K$197K$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
SONOMA, COUNTY OF 2025-06-GSAFAC-0000406555 ↗
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
SONOMA, COUNTY OF EB6LZJPCWEU3
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 = 'EB6LZJPCWEU3'      -- this entity's parent
  AND related_uei <> 'MA5MFLZKNJR3';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
SONOMA COUNTY COMMUNITY DEVELOPMENT COMMISSION
QJKVLDMEA4B1
Not yet due$77.7M
SONOMA, COUNTY OF
UVR7G1KAPHT5
Not yet due$6.0M
COUNTY OF SONOMA
N11GQJJTNLF1
Under threshold$256K
COUNTY OF SONOMA
XM1KKF9Z41Z6
Under threshold$161K
COUNTY OF SONOMA
NRGZB96XYQB5
Undetermined$0
FS5CNGJVWK69
FS5CNGJVWK69
JFT4UYJJMAT4
JFT4UYJJMAT4