related_orgs

Data license: Public Domain (IRS data)

8,540,764 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE related_orgs (
    id                    INTEGER PRIMARY KEY AUTOINCREMENT,
    object_id             TEXT NOT NULL,
    ein                   TEXT,
    related_org_name      TEXT,
    related_ein           TEXT,
    city                  TEXT,
    state                 TEXT,
    zip                   TEXT,
    primary_activity      TEXT,
    legal_domicile        TEXT,
    exempt_code_section   TEXT,
    public_charity_status TEXT,
    direct_controlling    TEXT,
    controlled_org_ind    INTEGER,
    section               TEXT
);
CREATE INDEX idx_relorg_oid ON related_orgs(object_id);
CREATE INDEX idx_relorg_ein ON related_orgs(ein);
CREATE INDEX idx_relorg_related_ein ON related_orgs(related_ein);