1. Edge A→B: Federal Bureau of Investigation (FBI) → 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, "Warner led advocacy for reauthorizing FISA Section 702, which allows searching 702 data for Americans' communications without warrants—despite documented FBI compliance failures. Virginia voters have shown strong support for privacy protections."). 3. Edge C→A: Mark R. Warner → Federal Bureau of Investigation (FBI) (relationship: benefit-type, "FBI is listed as one of In-Q-Tel's government partners"). Each edge is independently documented in the connections table (IDs 12728, 12732, 5299). 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=84) OR (entity_a_id=84 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=84 AND entity_b_id=109) OR (entity_a_id=109 AND entity_b_id=84)) 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.