CITY OF HAVERHILL
overdue for FY2022, FY2023, FY2024, FY2025 ($6.8M observed); FY2026 not yet due.
| FY | Status | Observed | Threshold | Composition | Due | Days late | SEFA expended | Obs. % of SEFA | Own report | Covering |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026 | Not yet due | $1.2M ▲ | $1.0M | outlays 100% | 2027-03-30 | — | — | — | — | — |
| 2025 | Overdue | $888K ▲ | $750K | outlays 100% | 2026-03-30 | 129d past due | — | — | — | — |
| 2024 | Overdue | $2.2M ▲ | $750K | outlays 54% + pass-through 46% | 2025-03-30 | 494d past due | — | — | — | — |
| 2023 | Overdue | $2.1M ▲ | $750K | outlays 64% + pass-through 36% | 2024-03-30 | 859d past due | — | — | — | — |
| 2022 | Overdue | $1.7M ▲ | $750K | outlays 100% | 2023-03-30 | 1225d past due | — | — | — | — |
- Obligation
- $918K
- Outlay
- $1.2M
- Subaward recv
- $0
- Subaward passed
- $0
- Loan face value
- $0
- Awards
- 2
- FAC check
- —
- Audit type
- —
- Accepted
- —
- Auditor
- —
- Cognizant agency
- —
- Oversight agency
- —
| Component | Obligation | Outlay | Subaward recv | Subaward passed | Loan face value |
|---|---|---|---|---|---|
| Non-HHS federal money | $918K | $1.2M | $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_parentFrom 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.
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 = 'CSHMGK8KWBX4' -- this entity's parent AND related_uei <> 'GBLEKH5LRLB8'; -- everything else under it
| Entity | Provably covers | Latest status | Yrs delinq. | Latest observed |
|---|---|---|---|---|
| CITY OF HAVERHILL TREASURER-COLLECTOR FH6MXBRJMRD7 | — | Overdue | 1 | $11.4M |
| HAVERHILL, CITY OF HHGQZJ98QQ44 | — | Not yet due | 1 | $1.3M |
| HWVSBQZCMF75 HWVSBQZCMF75 | — | — | — | — |
| TB1XMLJWAE51 TB1XMLJWAE51 | — | — | — | — |