bmf

Data license: Public Domain (IRS data)

grp

Four-digit IRS group exemption number (GEN), zero-padded TEXT. <strong>'0000' IS A SENTINEL MEANING NO GROUP RULING, NOT A GROUP</strong> — it is carried by 1,561,684 rows. <code>returns.group_exemption_num</code> uses the SAME sentinel, so an unguarded <code>bmf.grp = returns.group_exemption_num</code> join is a cartesian, not a subtle error. <strong>Always exclude '0000' on BOTH sides.</strong> Also: this roster disagrees with the affiliate lists filed on group returns — measured on 25 all-affiliates-included groups, only 40 percent agree within a 80-120 percent band — so treat <code>grp</code> as an indicative membership key, not an authoritative one.

1,964,958 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE bmf (
            ein              TEXT PRIMARY KEY,
            name             TEXT, ico              TEXT, street           TEXT,
            city             TEXT, state            TEXT, zip              TEXT,
            grp              TEXT, subsection       TEXT, affiliation      TEXT,
            classification   TEXT, ruling           TEXT, deductibility    TEXT,
            foundation       TEXT, activity         TEXT, organization     TEXT,
            status           TEXT, tax_period       TEXT, asset_cd         TEXT,
            income_cd        TEXT, filing_req_cd    TEXT, pf_filing_req_cd TEXT,
            acct_pd          TEXT, asset_amt        INTEGER,
            income_amt       INTEGER, revenue_amt   INTEGER,
            ntee_cd          TEXT, sort_name        TEXT
        );
CREATE INDEX idx_bmf_subsection       ON bmf(subsection);
CREATE INDEX idx_bmf_state            ON bmf(state);
CREATE INDEX idx_bmf_foundation       ON bmf(foundation);