990data_public

Data license: Public Domain (IRS data)

Custom SQL query

Tables

bmf

ein, name, ico, street, city, state, zip, grp, subsection, affiliation, classification, ruling, deductibility, foundation, activity, organization, status, tax_period, asset_cd, income_cd, filing_req_cd, pf_filing_req_cd, acct_pd, asset_amt, income_amt, revenue_amt, ntee_cd, sort_name

Many rows

capital_gains

id, object_id, ein, property_desc, how_acquired, acquired_date, sold_date, gross_sale_price, cost_basis, gain_or_loss

Many rows

contractors

id, object_id, ein, contractor_name, city, state, service_type, compensation

Many rows

contributors

id, object_id, ein, contributor_name, city, state, zip, amount, contributor_type

Many rows

grants

id, object_id, ein, grant_type, recipient_name, recipient_city, recipient_state, recipient_country, recipient_zip, relationship, foundation_status, purpose, amount, grant_date, expended_amount

Many rows

investments

id, object_id, ein, investment_type, description, book_value, fmv, cost_basis

Many rows

officers

id, object_id, ein, person_name, title, avg_hours_per_week, compensation, benefits, expense_account

Many rows

program_activities

id, object_id, ein, activity_num, description, expenses

576,397 rows

program_investments

id, object_id, ein, description, amount

Many rows

related_orgs

id, object_id, ein, related_org_name, related_ein, city, state, zip, primary_activity, legal_domicile, exempt_code_section, public_charity_status, direct_controlling, controlled_org_ind, section

Many rows

returns

object_id, ein, org_name, state, tax_year, tax_period_end, return_type, ntee_code, total_revenue, total_expenses, program_expenses, fundraising_expenses, management_expenses, total_assets_eoy, officer_comp, source_file, parse_error, contributions_received, dividends, interest_income, net_gain_sale_assets, contributions_paid, fmv_assets_eoy, net_assets_eoy, grants_payable_eoy, qualifying_distributions, distributable_amount, min_investment_return, excess_distribution_cyov

Many rows

schedule_i_990

id, object_id, ein, recipient_name, recipient_ein, recipient_city, recipient_state, recipient_zip, irc_section, cash_grant_amt, non_cash_amt, purpose

Many rows

schedule_i_grants

id, funder_ein, funder_name, tax_year, grant_type, recipient_name, recipient_ein, recipient_city, recipient_state, recipient_zip, recipient_country, amount, purpose, source_file

Many rows

sqlite_sequence

name, seq

12 rows

top_employees

id, object_id, ein, person_name, title, avg_hours_per_week, compensation, benefits, expense_account

Many rows

... and 15 hidden tables