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

City of Bristol, Virginia

UEI JWTSEDDAMHH5 · VA · local · FY 2025-07-01 → 2026-06-30
FY2026: Not yet due

Filed 2 years (FY2023–FY2024); covered by another audit for 2 years; FY2026 not yet due.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Not yet due $753K $1.0M2027-03-30
2025Covered (standing) $1.2M $750K2026-03-30129d past due
2024Filed $1.5M $750K2025-03-30-90$6.2M24% 2024-06-GSAFAC-0000344021 ↗
2023Filed $981K $750K2024-03-30-93$14.8M6.6% 2023-06-GSAFAC-0000013847 ↗
2022Covered by parent $9.3M $750K2023-03-302022-06-CENSUS-0000176255 ↗
Obligation
$683K
Outlay
$647K
Subaward recv
$106K
Subaward passed
$0
Loan face value
$0
Awards
▲ pass-through money only
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Non-HHS federal money $683K$647K$106K$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 = audit_coverage

Whose single audit accounts for this entity, and whose this entity accounts for. The LINKS are standing — they apply to every year, and a gap in the observed span is a gap in FAC reporting, not a year the entity stood alone. The rolled AMOUNTS below follow the selected fiscal year, so the entity count there can be smaller than the standing list.

Covered by
CITY OF BRISTOL VIRGINIA 2022-06-CENSUS-0000176255 ↗
Standing link — declared from fac, observed FY2022. This entity is not independently delinquent in any year; the coverer carries the filing obligation.
Audit scope — FY2026
Covers 1 entities holding $753K of observed federal money .
This entity’s audit covers (1)
EntityObservedLatest statusYrs delinq.Latest observed
CITY OF BRISTOL VIRGINIA
N68CLJ7QM1P9
FY2023–FY2024Under threshold$753K
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
Rolls up to this entity
Nothing — no entity rolls up to this one.
link_type = succession

One entity replaced by another — a survivor inherits its predecessors’ obligations. Not year-specific.

Succeeded by
Merged into this entity
Nothing — no predecessor merged in.
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 = 'UDFFYR594J94'      -- this entity's parent
  AND related_uei <> 'JWTSEDDAMHH5';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
D54RFNTZG7J9
D54RFNTZG7J9
JY1JFSW8LEN1
JY1JFSW8LEN1