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

KERN COUNTY PUBLIC WORKS DEPT

UEI HAS4EEJ3JF67 · CA · local · FY 2024-07-01 → 2025-06-30
FY2025: Overdue

overdue for FY2022, FY2023, FY2024, FY2025 ($57.2M observed).

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2025Overdue $15.8M $750Kpass-through 100%2026-03-30129d past due
2024Overdue $21.8M $750Kpass-through 100%2025-03-30494d past due
2023Overdue $17.8M $750Kpass-through 100%2024-03-30859d past due
2022Overdue $1.8M $750Kpass-through 100%2023-03-301225d past due
Obligation
$0
Outlay
Subaward recv
$15.8M
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
Non-HHS federal money $0$15.8M$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
COUNTY OF KERN LYM1ZJ6B7BM3
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 = 'LYM1ZJ6B7BM3'      -- this entity's parent
  AND related_uei <> 'HAS4EEJ3JF67';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
COUNTY OF KERN
WAHHPJUUDP16
Not yet due$200.7M
KERN COUNTY EMPLOYERS TRAINING RESOURCE
K9X8GTMWKS65
Overdue4$17.7M
COUNTY OF KERN
CMJ8UPMMN1H6
Not yet due4$9.5M
COUNTY OF KERN
NMJRLC3L3A87
Not yet due2$6.8M
KERN COUNTY AIRPORTS
E3DQMGWJNF44
Not yet due4$6.1M
KERN COUNTY DIST ATTORNEY OFFICE
HBJYNP2M1GS6
Not yet due3$1.5M
KERN, COUNTY OF
X36BLMWZDKM5
Under threshold2$714K
COUNTY OF KERN
J3PCLKKDJ373
Under threshold$291K
KERN COUNTY DEPARTMENT OF PUBLIC HEALTH
ED62VXEJCS33
Under threshold2$228K
COUNTY OF KERN
T1Y6YMBTGKP4
Filed$80K
COUNTY OF KERN
NQGBLFTTWSS9
Under threshold$5K
KCYMQUWQJWK9
KCYMQUWQJWK9
GJ2WVN2MNGJ7
GJ2WVN2MNGJ7
C63DNR94MFJ5
C63DNR94MFJ5
NC6DGPUVMEA8
NC6DGPUVMEA8
S98TSP62Q1H4
S98TSP62Q1H4