returns

Data license: Public Domain (IRS data)

5,345,798 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: tax_period_end (date)

Next page

CREATE TABLE returns (
            object_id            TEXT PRIMARY KEY,
            ein                  TEXT,
            org_name             TEXT,
            state                TEXT,
            tax_year             INTEGER,
            tax_period_end       TEXT,
            return_type          TEXT,
            ntee_code            TEXT,
            total_revenue        INTEGER,
            total_expenses       INTEGER,
            program_expenses     INTEGER,
            fundraising_expenses INTEGER,
            management_expenses  INTEGER,
            total_assets_eoy     INTEGER,
            officer_comp         INTEGER,
            source_file          TEXT,
            parse_error          TEXT
        , contributions_received INTEGER, dividends INTEGER, interest_income INTEGER, net_gain_sale_assets INTEGER, contributions_paid INTEGER, fmv_assets_eoy INTEGER, net_assets_eoy INTEGER, grants_payable_eoy INTEGER, qualifying_distributions INTEGER, distributable_amount INTEGER, min_investment_return INTEGER, excess_distribution_cyov INTEGER);
CREATE INDEX idx_ein         ON returns(ein);
CREATE INDEX idx_return_type ON returns(return_type);
CREATE INDEX idx_tax_year    ON returns(tax_year);
CREATE INDEX idx_returns_ein_type ON returns(ein, return_type);
CREATE INDEX idx_returns_ein_year_oid ON returns(ein, tax_year DESC, object_id DESC);