1. Edge A→B: Elon Musk → US Air Force (relationship: funding-type, "Musk is CEO of SpaceX, which holds major government contracts including NASA Commercial Crew Program contracts worth approximately $2.6 billion, a $2.89 billion NASA Human Landing System contract for Artemis, Commercial Resupply Services contracts worth multiple billions, and classified contracts with DoD and intelligence agencies including the National Reconnaissance Office. Musk obtained security clearance for SpaceX's classified government work."). 2. Edge B→C: US Air Force → SpaceX (relationship: authority-type, "In 2018, the U.S. Air Force investigated Musk after he smoked marijuana on Joe Rogan's podcast, as this potentially affected his security clearance. The Air Force confirmed Musk retained his clearance."). 3. Edge C→A: SpaceX → Elon Musk (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 157, 327, 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=3) OR (entity_a_id=3 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=3 AND entity_b_id=82) OR (entity_a_id=82 AND entity_b_id=3)) 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.