1. Edge A→B: National Security Agency (NSA) → In-Q-Tel (relationship: funding-type, "Warner, as a career VC investor in telecommunications and tech sectors, co-founded the venture capital firm Columbia Capital LLC. In-Q-Tel is a strategic investor that partners with companies; the data suggests Warner's VC background positions him as an investor whose firms could interact with entities like In-Q-Tel, though no direct transaction is documented."). 2. Edge B→C: In-Q-Tel → Mark R. Warner (relationship: authority-type, "As Senate Intelligence Chair, Warner stated that FISA Section 702 reauthorization was necessary for national security and voted yea on H.R. 7888 to reauthorize warrantless surveillance powers used by the NSA, despite documented FBI compliance failures."). 3. Edge C→A: Mark R. Warner → National Security Agency (NSA) (relationship: benefit-type, "NSA is one of 10 IC agencies served by In-Q-Tel"). Each edge is independently documented in the connections table (IDs 12728, 12731, 5296). 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=109 AND entity_b_id=10715) OR (entity_a_id=10715 AND entity_b_id=109)) 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=10715 AND entity_b_id=86) OR (entity_a_id=86 AND entity_b_id=10715)) 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=86 AND entity_b_id=109) OR (entity_a_id=109 AND entity_b_id=86)) 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.