home / openregs

entity_relationships

Links between organizations: a central organization and the organizations covered by its IRS group exemption, successor organizations from the global Legal Entity Identifier file, affiliates named in lobbying filings, and the organization each political action committee names as connected to it in FEC records. Some links have no parent_entity_id; for a group exemption, the gen column still gives its IRS group exemption number. Relationships whose source is gleif_successor come from a snapshot: the Global Legal Entity Identifier Foundation's (GLEIF's) full published file of 2026-04-18, not refreshed since.

Data license: Public Domain (U.S. Government data) · Data source: U.S. government sources, plus a few identifier registries; each is listed on the methodology page

0 rows where parent_entity_id = 37814

✎ View and edit SQL

This data as json

0 records

CREATE TABLE entity_relationships (
    relationship_id INTEGER PRIMARY KEY,
    parent_entity_id INTEGER,            -- NULL when parent is unknown (e.g., BMF GEN with no resolved central)
    child_entity_id INTEGER NOT NULL,
    relationship_type TEXT NOT NULL,     -- 'subsidiary_of' | 'parent_of' | 'affiliated_pac'
                                         -- | 'founder_family' | 'foreign_controlled' | 'joint_venture'
                                         -- | 'predecessor_to' | 'successor_to'
                                         -- | 'bmf_group_exemption' | 'lobbying_affiliate'
    source TEXT NOT NULL,                -- 'bmf' | 'sec_exhibit_21' | 'lobbying_affiliated_orgs'
                                         -- | 'gleif_successor' | 'fec_connected_org' | 'manual'
    source_ref TEXT,                     -- filing_uuid / accession_number / GEN / etc.
    gen TEXT,                            -- IRS Group Exemption Number when source='bmf'
    effective_start TEXT,
    effective_end TEXT,
    confidence_score REAL NOT NULL DEFAULT 1.0,
    notes TEXT,
    created_at TEXT NOT NULL,
    FOREIGN KEY (parent_entity_id) REFERENCES entities(entity_id),
    FOREIGN KEY (child_entity_id) REFERENCES entities(entity_id),
    CHECK (parent_entity_id IS NULL OR parent_entity_id != child_entity_id)
);
CREATE INDEX idx_er_parent ON entity_relationships(parent_entity_id) WHERE parent_entity_id IS NOT NULL;
CREATE INDEX idx_er_child ON entity_relationships(child_entity_id);
CREATE INDEX idx_er_type ON entity_relationships(relationship_type);
CREATE INDEX idx_er_gen ON entity_relationships(gen) WHERE gen IS NOT NULL;
CREATE INDEX idx_er_source ON entity_relationships(source);
CREATE INDEX idx_er_gen_child ON entity_relationships(gen, child_entity_id);
CREATE UNIQUE INDEX uq_er_fec_connected
    ON entity_relationships(child_entity_id, relationship_type, source, source_ref)
    WHERE source='fec_connected_org';
Powered by Datasette · Queries took 1.322ms · Data license: Public Domain (U.S. Government data) · Data source: U.S. government sources, plus a few identifier registries; each is listed on the methodology page · Privacy