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 → Federal Bureau of Investigation (FBI) (relationship: authority-type, "As Vice Chair of House Armed Services Committee, Wittman oversees defense and national security matters that involve FBI jurisdiction; also his district includes federal employees at Langley AFB and other installations."). 3. Edge C→A: Federal Bureau of Investigation (FBI) → Palantir Technologies (relationship: benefit-type, "FBI uses Palantir software for database integration and data analytics, relationship dating back to at least 2013"). Each edge is independently documented in the connections table (IDs 17380, 17372, 3681). 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=84) OR (entity_a_id=84 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=84 AND entity_b_id=17) OR (entity_a_id=17 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.