1. Edge A→B: US Department of Defense (Pentagon) → Booz Allen Hamilton (relationship: funding-type, "Booz Allen Hamilton PAC heavily backed Strong's 2026 reelection bid"). 2. Edge B→C: Booz Allen Hamilton → Dale W. Strong (relationship: authority-type, "Strong serves on the House Armed Services Committee, with jurisdiction over the Department of Defense"). 3. Edge C→A: Dale W. Strong → US Department of Defense (Pentagon) (relationship: benefit-type, "Booz Allen Hamilton is a major government contractor with significant Department of Defense business, as evidenced by its status as a publicly traded company with regular SEC filings and known reputation in the federal contracting space. The company's consistent SEC filing history indicates ongoing substantial government contract work."). Each edge is independently documented in the connections table (IDs 13295, 13308, 561). Together they form a directed cycle: money flows from A, authority flows through B, benefit returns to A. This is the structural definition of a closed conflict-of-interest loop.
Anyone can re-execute this query to verify the published value. If the result diverges, the finding auto-flags as stale.
SELECT (
EXISTS (SELECT 1 FROM connections WHERE ((entity_a_id=105 AND entity_b_id=10964) OR (entity_a_id=10964 AND entity_b_id=105)) AND (relationship_type ILIKE '%investor%' OR relationship_type ILIKE '%donor%' OR relationship_type ILIKE '%donation%' OR relationship_type ILIKE '%contributor%' OR relationship_type ILIKE '%contribution%' OR relationship_type ILIKE '%funder%' OR relationship_type ILIKE '%founder%' OR relationship_type ILIKE '%co-founder%' OR relationship_type ILIKE '%shareholder%'))
AND EXISTS (SELECT 1 FROM connections WHERE ((entity_a_id=10964 AND entity_b_id=94) OR (entity_a_id=94 AND entity_b_id=10964)) AND (relationship_type ILIKE '%oversight%' OR relationship_type ILIKE '%regulatory_oversight%' OR relationship_type ILIKE '%regulatory%' OR relationship_type ILIKE '%regulator%' OR relationship_type ILIKE '%committee_membership%' OR relationship_type ILIKE '%committee%' OR relationship_type ILIKE '%chair%' OR relationship_type ILIKE '%appointed_by%' OR relationship_type ILIKE '%appointment%' OR relationship_type ILIKE '%supervisor%'))
AND EXISTS (SELECT 1 FROM connections WHERE ((entity_a_id=94 AND entity_b_id=105) OR (entity_a_id=105 AND entity_b_id=94)) AND (relationship_type ILIKE '%contractor%' OR relationship_type ILIKE '%contractor_relationship%' OR relationship_type ILIKE '%client%' OR relationship_type ILIKE '%supplier%' OR relationship_type ILIKE '%vendor%' OR relationship_type ILIKE '%grant_recipient%' OR relationship_type ILIKE '%employment%' OR relationship_type ILIKE '%employee%' OR relationship_type ILIKE '%former_employee%' OR relationship_type ILIKE '%consultant%'))
)::int AS value
Each question can be commissioned at the matching investigation tier.