GOBLIN HOUSE
[ Enter Database → ]
1. Edge A→B: Trae Stephens → Palantir Technologies (relationship: funding-type, "Both Palantir and Anduril operate in the defense technology sector with government contracts. Peter Thiel's Founders Fund has invested in both companies, and Anduril was co-founded by Trae Stephens, a former Palantir employee."). 2. Edge B→C: Palantir Technologies → Anduril Industries (relationship: authority-type, "Trae Stephens is co-founder and Executive Chairman of Anduril Industries, a defense technology company founded in 2017. The company has received federal contracts from the Department of Defense and Department of Homeland Security."). 3. Edge C→A: Anduril Industries → Trae Stephens (relationship: benefit-type, "Stephens previously worked at Palantir Technologies, a government contractor, where he worked on government-facing projects including intelligence community contracts before co-founding Anduril."). Each edge is independently documented in the connections table (IDs 207, 192, 57). 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=26) OR (entity_a_id=26 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=26 AND entity_b_id=12) OR (entity_a_id=12 AND entity_b_id=26)) 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=12 AND entity_b_id=17) OR (entity_a_id=17 AND entity_b_id=12)) 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.