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. The group exemption links come from a single IRS release (see its date) and show the holder in its own column, not in parent_entity_id. Some other links have no parent_entity_id. 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.

For rows from LDA filings (source 'lobbying_affiliated_orgs'), as LDA.gov’s terms of use require: “Senate Office of Public Records cannot vouch for the data or analyses derived from these data after the data have been retrieved from LDA.gov.”

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

effective_start
Not populated: empty on every row (checked 2026-10-19).
effective_end
Not populated: empty on every row (checked 2026-10-19).
group_exemption_holder_entity_id
The organization whose IRS group exemption covers this one. Often a national body over its local chapters, but not necessarily a parent organization. Blank where the IRS names no holder, and for church groups for now. See the methodology page. Blank on links that aren't IRS group exemptions.
parent_entity_id
Not used for IRS group exemptions; see the holder column.

0 rows where parent_entity_id = 9705

✎ 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, group_exemption_holder_entity_id INTEGER REFERENCES entities(entity_id) CHECK (group_exemption_holder_entity_id IS NULL OR group_exemption_holder_entity_id != child_entity_id),
    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';
CREATE INDEX idx_er_group_exemption_holder ON entity_relationships(group_exemption_holder_entity_id) WHERE group_exemption_holder_entity_id IS NOT NULL;
Powered by Datasette · Queries took 4.832ms · 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