1. Edge A→B: Palantir Technologies → Robert J. Wittman (relationship: funding-type, "Misc Defense ($248,311) includes technology contractors like Palantir; Wittman's committee oversees defense technology and data analytics programs."). 2. Edge B→C: Robert J. Wittman → US Department of Defense (Pentagon) (relationship: authority-type, "Wittman's role as Vice Chair of the House Armed Services Committee gives him direct oversight of Department of Defense appropriations and the National Defense Authorization Act."). 3. Edge C→A: US Department of Defense (Pentagon) → Palantir Technologies (relationship: benefit-type, "Palantir holds multiple contracts with Department of Defense components including U.S. Special Operations Command (USSOCOM) and various military branches. Congressional records document these contracts through procurement hearings and oversight testimony."). Each edge is independently documented in the connections table (IDs 17380, 17373, 410). 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=17 AND entity_b_id=11163) OR (entity_a_id=11163 AND entity_b_id=17)) 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=11163 AND entity_b_id=94) OR (entity_a_id=94 AND entity_b_id=11163)) 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=94 AND entity_b_id=17) OR (entity_a_id=17 AND entity_b_id=94)) 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.