grants

Data license: Public Domain (IRS data)

13,609,220 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: grant_date (date)

Next page

CREATE TABLE grants (
    id                    INTEGER PRIMARY KEY AUTOINCREMENT,
    object_id             TEXT NOT NULL,
    ein                   TEXT,
    grant_type            TEXT,  -- 'paid', 'future', 'exp_responsibility'
    recipient_name        TEXT,
    recipient_city        TEXT,
    recipient_state       TEXT,
    recipient_country     TEXT,  -- NULL for US
    recipient_zip         TEXT,
    relationship          TEXT,
    foundation_status     TEXT,
    purpose               TEXT,
    amount                INTEGER,
    grant_date            TEXT,       -- exp_responsibility only
    expended_amount       INTEGER     -- exp_responsibility only
, tax_year INTEGER);
CREATE INDEX idx_grants_type ON grants(grant_type);
CREATE INDEX idx_grants_ein_type ON grants(ein, grant_type);
CREATE INDEX idx_grants_oid_type ON grants(object_id, grant_type);
CREATE INDEX idx_grants_amount ON grants(amount);
CREATE INDEX idx_grants_ein_recip ON grants(ein, recipient_name COLLATE NOCASE);
CREATE INDEX idx_grants_recip_type ON grants(recipient_name COLLATE NOCASE, grant_type);
CREATE INDEX idx_grants_year_amount  ON grants(tax_year, amount DESC);