1. Edge A→B: Donald Trump → Howard Lutnick (relationship: funding-type, "Howard Lutnick, Cantor Fitzgerald's leader, personally donated $1 million to the Trump 47 Committee and additional amounts to Trump-affiliated PACs in the 2024 cycle."). 2. Edge B→C: Howard Lutnick → Cantor Fitzgerald (relationship: authority-type, "Howard Lutnick was nominated by President Donald Trump to serve as U.S. Secretary of Commerce in late 2024 and was confirmed in 2025."). 3. Edge C→A: Cantor Fitzgerald → Donald Trump (relationship: benefit-type, "Former chairman and CEO of Cantor Fitzgerald. Transferred control to son upon appointment as Commerce Secretary."). Each edge is independently documented in the connections table (IDs 16723, 16616, 10312). 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=9792 AND entity_b_id=9122) OR (entity_a_id=9122 AND entity_b_id=9792)) 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=9122 AND entity_b_id=9791) OR (entity_a_id=9791 AND entity_b_id=9122)) 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=9791 AND entity_b_id=9792) OR (entity_a_id=9792 AND entity_b_id=9791)) 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.