schedule_i_grants

Data license: Public Domain (IRS data)

1,272,399 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE schedule_i_grants (
            id              INTEGER PRIMARY KEY AUTOINCREMENT,
            funder_ein      TEXT NOT NULL,
            funder_name     TEXT,
            tax_year        INTEGER,
            grant_type      TEXT,  -- 'us_org' or 'foreign_org'
            recipient_name  TEXT,
            recipient_ein   TEXT,
            recipient_city  TEXT,
            recipient_state TEXT,
            recipient_zip   TEXT,
            recipient_country TEXT,
            amount          INTEGER,
            purpose         TEXT,
            source_file     TEXT
        );
CREATE INDEX idx_si_funder ON schedule_i_grants(funder_ein);
CREATE INDEX idx_si_recipient ON schedule_i_grants(recipient_name);
CREATE INDEX idx_si_recipient_ein ON schedule_i_grants(recipient_ein);
CREATE INDEX idx_si_year ON schedule_i_grants(tax_year);
CREATE INDEX idx_si_amount ON schedule_i_grants(amount);
CREATE INDEX idx_si_recipient_nocase ON schedule_i_grants(recipient_name COLLATE NOCASE);
CREATE INDEX idx_si_funder_year_amt  ON schedule_i_grants(funder_ein, tax_year, amount DESC);