contributors

Data license: Public Domain (IRS data)

662,265 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE contributors (
    id                    INTEGER PRIMARY KEY AUTOINCREMENT,
    object_id             TEXT NOT NULL,
    ein                   TEXT,
    contributor_name      TEXT,
    city                  TEXT,
    state                 TEXT,
    zip                   TEXT,
    amount                INTEGER,
    contributor_type      TEXT  -- 'person' or 'business'
);
CREATE INDEX idx_contributors_oid ON contributors(object_id);
CREATE INDEX idx_contributors_ein ON contributors(ein);