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

CITY OF CHICOPEE

UEI TESCXLNLPLH7 · MA · local · FY 2025-07-01 → 2026-06-30
FY2026: Under threshold

Filed 4 years (FY2022–FY2025).

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Under threshold $147 $1.0M2027-03-30
2025Filed $40K $750K2026-03-3084$46.5M0.1% 2025-06-GSAFAC-0000420886 ↗
2024Filed $204K $750K2025-03-3030$29.2M0.7% 2024-06-GSAFAC-0000367758 ↗
2023Filed $64K $750Kpass-through 100% (outlay unknown)2024-03-3059$25.1M0.3% 2023-06-GSAFAC-0000041823 ↗
2022Filed $14.4M $750Koutlays 100%2023-03-300$37.5M38% 2022-06-CENSUS-0000147947 ↗
Obligation
$-120K
Outlay
$147
Subaward recv
$0
Subaward passed
$0
Loan face value
$0
Awards
3
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Non-HHS federal money $-120K$147$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
CHICOPEE, CITY OF JKKYEBXMZML5
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 = 'JKKYEBXMZML5'      -- this entity's parent
  AND related_uei <> 'TESCXLNLPLH7';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
CITY OF CHICOPEE
J5CUE7SHMMG6
Overdue4$10.3M
CITY OF CHICOPEE
EMNKEDRG5Z13
Under threshold1$250K
CITY OF CHICOPEE
DHV9S7TMJ1Z3
Under threshold$28K
JBLBEMJKA7V5
JBLBEMJKA7V5