1. Edge A→B: SpaceX → Trent Kelly (relationship: funding-type, "SpaceX PAC donated $5,000 to Kelly's 2025-2026 campaign"). 2. Edge B→C: Trent Kelly → US Air Force (relationship: authority-type, "Kelly's subcommittee chairmanship on House Armed Services Committee includes oversight of Air Force projection forces; Columbus Air Force Base is within his district"). 3. Edge C→A: US Air Force → SpaceX (relationship: benefit-type, "SpaceX filed a lawsuit against the U.S. Air Force in 2014 in the U.S. Court of Federal Claims, challenging the block-buy contract awarded to United Launch Alliance. The lawsuit was settled after SpaceX was certified for national security missions and allowed to compete for contracts."). Each edge is independently documented in the connections table (IDs 13614, 13626, 277). 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=23 AND entity_b_id=11117) OR (entity_a_id=11117 AND entity_b_id=23)) 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=82) OR (entity_a_id=82 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=82 AND entity_b_id=23) OR (entity_a_id=23 AND entity_b_id=82)) 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.