1. Edge A→B: Palantir Technologies → Mark D. Levine (relationship: funding-type, "NYC Comptroller requested independent human rights risk assessment of Palantir's ICE contracts"). 2. Edge B→C: Mark D. Levine → US Immigration and Customs Enforcement (ICE) (relationship: authority-type, "NYC Comptroller Mark Levine requested an independent human rights risk assessment of Palantir's work with DHS/ICE."). 3. Edge C→A: US Immigration and Customs Enforcement (ICE) → Palantir Technologies (relationship: benefit-type, "Connection inferred from the presence of ImmigrationOS in the known entities database - ImmigrationOS is Palantir's immigration enforcement platform used by ICE for case management and tracking, though this specific contract relationship is not explicitly documented in the provided facts"). Each edge is independently documented in the connections table (IDs 1004, 11607, 498). 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=622) OR (entity_a_id=622 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=622 AND entity_b_id=79) OR (entity_a_id=79 AND entity_b_id=622)) 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=79 AND entity_b_id=17) OR (entity_a_id=17 AND entity_b_id=79)) 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.