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

11 rows where parent_entity_id = 161

✎ View and edit SQL

This data as json, CSV (advanced)

relationship_id ▼ parent_entity_id child_entity_id relationship_type source source_ref gen effective_start effective_end confidence_score notes created_at
405253 161 161 2276856 2276856 successor_to gleif_successor gleif:ROPY7PEPIPIDJNF0BO69->549300WYXDDBYRASEG81       1.0   2026-04-19 18:34:12
406078 161 161 2280145 2280145 affiliated_pac fec_connected_org C00137273       1.0 connected_org_name=M&T BANK 2026-06-11T14:51:04.902847+00:00
417809 161 161 2276856 2276856 successor_to gleif_successor gleif:ROPY7PEPIPIDJNF0BO69->549300WYXDDBYRASEG81       1.0   2026-06-16 13:47:09
421386 161 161 2276856 2276856 successor_to gleif_successor gleif:ROPY7PEPIPIDJNF0BO69->549300WYXDDBYRASEG81       1.0   2026-07-16 12:00:44
425263 161 161 2276856 2276856 successor_to gleif_successor gleif:ROPY7PEPIPIDJNF0BO69->549300WYXDDBYRASEG81       1.0   2026-08-16 13:13:54
428923 161 161 2276856 2276856 successor_to gleif_successor gleif:ROPY7PEPIPIDJNF0BO69->549300WYXDDBYRASEG81       1.0   2026-08-16 16:24:31
432504 161 161 2276856 2276856 successor_to gleif_successor gleif:ROPY7PEPIPIDJNF0BO69->549300WYXDDBYRASEG81       1.0   2026-08-16 23:21:17
440159 161 161 2276856 2276856 successor_to gleif_successor gleif:ROPY7PEPIPIDJNF0BO69->549300WYXDDBYRASEG81       1.0   2026-09-16 13:19:08
443831 161 161 2276856 2276856 successor_to gleif_successor gleif:ROPY7PEPIPIDJNF0BO69->549300WYXDDBYRASEG81       1.0   2026-10-11 22:24:42
447429 161 161 2276856 2276856 successor_to gleif_successor gleif:ROPY7PEPIPIDJNF0BO69->549300WYXDDBYRASEG81       1.0   2026-10-16 15:04:09
451084 161 161 2276856 2276856 successor_to gleif_successor gleif:ROPY7PEPIPIDJNF0BO69->549300WYXDDBYRASEG81       1.0   2026-11-16 15:05:48

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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 4.007ms · 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