1. Edge A→B: US Department of Defense (Pentagon) → General Dynamics (relationship: funding-type, "1991-2024: $227,300 total ($122,800 individuals + $104,500 PAC)."). 2. Edge B→C: General Dynamics → Ken Calvert (relationship: authority-type, "As chair of the Defense Appropriations Subcommittee, Calvert sponsored and passed an $833 billion defense spending bill (H.R. 8774) in 2024, and his subcommittee oversees federal contract funding for defense companies that donate to his campaign."). 3. Edge C→A: Ken Calvert → US Department of Defense (Pentagon) (relationship: benefit-type, "General Dynamics is a major defense contractor with documented SEC filings spanning 2011-2024, indicating ongoing public company operations in the defense sector. The absence of USASpending contract data despite their known status as a top Pentagon contractor suggests contracts may be filed under subsidiary names (Electric Boat, GDIT, etc.)"). Each edge is independently documented in the connections table (IDs 11471, 13399, 622). 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=129 AND entity_b_id=11013) OR (entity_a_id=11013 AND entity_b_id=129)) 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=11013 AND entity_b_id=94) OR (entity_a_id=94 AND entity_b_id=11013)) 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=129) OR (entity_a_id=129 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.