1. Edge A→B: US Navy → General Dynamics (relationship: funding-type, "2001-2024: $376,896 via individual ($287,896) and PAC ($89,000) contributions. General Dynamics owns Electric Boat, Courtney's district's largest employer."). 2. Edge B→C: General Dynamics → Joe Courtney (relationship: authority-type, "Courtney's role as Ranking Member of Seapower and Projection Forces Subcommittee leads to submarine procurement (Virginia-class and Columbia-class) being directed to Electric Boat in his district."). 3. Edge C→A: Joe Courtney → US Navy (relationship: benefit-type, "General Dynamics' Electric Boat division is a known submarine manufacturer for the US Navy. The complex subsidiary structure noted in the analysis (contracts filed under subsidiary names rather than parent company) is consistent with how General Dynamics operates its naval shipbuilding business"). Each edge is independently documented in the connections table (IDs 11392, 17586, 623). 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=11201) OR (entity_a_id=11201 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=11201 AND entity_b_id=83) OR (entity_a_id=83 AND entity_b_id=11201)) 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=83 AND entity_b_id=129) OR (entity_a_id=129 AND entity_b_id=83)) 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.