1. Edge A→B: Gary Gensler → Goldman Sachs (relationship: funding-type, "1989-2024: $707,228 via employee contributions and PAC"). 2. Edge B→C: Goldman Sachs → Chuck Schumer (relationship: authority-type, "Gary Gensler chaired the Subcommittee on Investor Protection, Entrepreneurship and Capital Markets, which has oversight of securities industry practices. Schumer's documented cultivation of Wall Street donors connects to the regulatory environment Gensler oversees."). 3. Edge C→A: Chuck Schumer → Gary Gensler (relationship: benefit-type, "Gary Gensler was a partner at Goldman Sachs before being brought to the Treasury Department by Robert Rubin."). Each edge is independently documented in the connections table (IDs 11495, 18859, 16459). 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=9013 AND entity_b_id=7826) OR (entity_a_id=7826 AND entity_b_id=9013)) 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=7826 AND entity_b_id=686) OR (entity_a_id=686 AND entity_b_id=7826)) 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=686 AND entity_b_id=9013) OR (entity_a_id=9013 AND entity_b_id=686)) 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.