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

COUNTY OF CHARLOTTE

UEI D1LXLQECY6Y7 · FL · local · FY 2024-10-01 → 2025-09-30
FY2025: Overdue

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

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2025Overdue $2.6M $1.0Moutlays 0% + pass-through 100%2026-06-3037d past due
2024Overdue $807K $750Koutlays 11% + pass-through 89%2025-06-30402d past due
2023Under threshold $227K $750K2024-06-30
2022Overdue $1.7M $750Koutlays 1% + pass-through 99%2023-06-301133d past due
Obligation
$-9K
Outlay
$11K
Subaward recv
$2.6M
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 $-9K$11K$2.6M$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 CHARLOTTE X3RBY2VEDJT3
Rolls up to this entity (2)
EntityLatest statusYrs delinq.Latest observed
COUNTY OF CHARLOTTE
X3RBY2VEDJT3
Filed$89.8M
COUNTY OF CHARLOTTE
CAF5J662SND5
Undetermined$0
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 = 'X3RBY2VEDJT3'      -- this entity's parent
  AND related_uei <> 'D1LXLQECY6Y7';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
COUNTY OF CHARLOTTE
W8YJZF4NSQL1
Overdue4$22.6M
EPSQM9VBCDP8
EPSQM9VBCDP8