1. Edge A→B: Federal Bureau of Investigation (FBI) → CACI International (relationship: funding-type, "2024: $33,525 total ($23,525 individuals + $10,000 PAC). Defense contractor benefiting from Armed Services Committee oversight."). 2. Edge B→C: CACI International → Robert J. Wittman (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: Robert J. Wittman → Federal Bureau of Investigation (FBI) (relationship: benefit-type, "FBI's ITSSS-2 contract vehicle worth $8 billion is available for use by all DOJ components; CACI International previously held DOJ contracts and may be eligible under this vehicle, though no direct FBI contract found in public databases."). Each edge is independently documented in the connections table (IDs 11491, 17372, 16936). 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=108 AND entity_b_id=11163) OR (entity_a_id=11163 AND entity_b_id=108)) 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=108) OR (entity_a_id=108 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.