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

LARIMER COUNTY

UEI TJTHWRMWY5S1 · CO · local · FY 2025-01-01 → 2025-12-31
FY2025: Under threshold

.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Under threshold partial$39K $1.0M2027-09-30
2025Under threshold $723K $1.0M2026-09-30
2024Under threshold $350K $750K2025-09-30
2023Under threshold $386K $750K2024-09-30
2022Under threshold $126K $750K2023-09-30
Obligation
$25K
Outlay
$304K
Subaward recv
$419K
Subaward passed
$0
Loan face value
$0
Awards
5
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Administration for Children and Families HHS$0$400K$0$0
Substance Abuse and Mental Health Services Administration HHS$0$20K$0$0
Non-HHS federal money $25K$304K$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 = 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 LARIMER HQMBX6GPALH6
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 = 'HQMBX6GPALH6'      -- this entity's parent
  AND related_uei <> 'TJTHWRMWY5S1';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
LARIMER, COUNTY OF
SEY1UWDJFPJ1
Not yet due2$2.5M
LARIMER COUNTY HUMAN SERVICES
JQCRGXB9TP28
Not yet due3$2.1M
COUNTY OF LARIMER
DU2SMLHBNCD1
Under threshold$528K
LARIMER, COUNTY OF
TMYXN2KAM546
Undetermined$0
D4N2QLUCGJ67
D4N2QLUCGJ67
D7B3HB6DL3Y7
D7B3HB6DL3Y7