GOBLIN HOUSE
[ Enter Database → ]
1. Edge A→B: Elon Musk → US Air Force (relationship: funding-type, "Elon Musk is listed as a related person and executive officer in SpaceX's SEC Form D filings. He is the company's founder and CEO, with documented political contributions to both Republican and Democratic candidates. In 2024, he donated to America PAC supporting Republican candidates and publicly endorsed Donald Trump for president."). 2. Edge B→C: US Air Force → SpaceX (relationship: authority-type, "In 2018, the U.S. Air Force investigated Musk after he smoked marijuana on Joe Rogan's podcast, as this potentially affected his security clearance. The Air Force confirmed Musk retained his clearance."). 3. Edge C→A: SpaceX → Elon Musk (relationship: benefit-type, "SpaceX filed a lawsuit against the U.S. Air Force in 2014 in the U.S. Court of Federal Claims, challenging the block-buy contract awarded to United Launch Alliance. The lawsuit was settled after SpaceX was certified for national security missions and allowed to compete for contracts."). Each edge is independently documented in the connections table (IDs 275, 327, 277). 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=23 AND entity_b_id=3) OR (entity_a_id=3 AND entity_b_id=23)) 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=3 AND entity_b_id=82) OR (entity_a_id=82 AND entity_b_id=3)) 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=82 AND entity_b_id=23) OR (entity_a_id=23 AND entity_b_id=82)) 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.