1. Edge A→B: US Navy → Boeing (relationship: funding-type, "Boeing PAC donated $2,500 to Kelly's 2025-2026 campaign"). 2. Edge B→C: Boeing → Trent Kelly (relationship: authority-type, "As Chairman of Seapower and Projection Forces Subcommittee, Kelly has direct oversight of Navy programs and Naval Air Station Meridian borders his district"). 3. Edge C→A: Trent Kelly → US Navy (relationship: benefit-type, "Boeing is a known defense contractor that historically contracts with the US Navy, though specific contracts were not found under the colloquial name."). Each edge is independently documented in the connections table (IDs 13615, 13627, 18770). 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=31234 AND entity_b_id=11117) OR (entity_a_id=11117 AND entity_b_id=31234)) 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=11117 AND entity_b_id=83) OR (entity_a_id=83 AND entity_b_id=11117)) 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=83 AND entity_b_id=31234) OR (entity_a_id=31234 AND entity_b_id=83)) 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.