1. Edge A→B: Peter Thiel → Michael McCaul (relationship: funding-type, "Documented campaign donor / political contributor (inferential mapping from public donor profile and party / state heuristics)"). 2. Edge B→C: Michael McCaul → US Immigration and Customs Enforcement (ICE) (relationship: authority-type, "McCaul voted to renew ICE funding in H.R. 7147 (2026) and wrote the Laken Riley Act requiring mandatory ICE detention. He criticized Democrats for trying to 'remove ICE and CBP funding.'"). 3. Edge C→A: US Immigration and Customs Enforcement (ICE) → Peter Thiel (relationship: benefit-type, "Palantir Technologies has contracted with ICE"). Each edge is independently documented in the connections table (IDs 10977, 17697, 18705). 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=1 AND entity_b_id=9302) OR (entity_a_id=9302 AND entity_b_id=1)) 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=9302 AND entity_b_id=79) OR (entity_a_id=79 AND entity_b_id=9302)) 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=79 AND entity_b_id=1) OR (entity_a_id=1 AND entity_b_id=79)) 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.