990data_public
Data license: Public Domain (IRS data)
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
1,964,958 rows
bmf_former
ein, name, city, state, subsection, ntee_cd, status, deductibility, foundation, ruling, last_seen_asof, dropped_asof, grp
63,138 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
1,119,785 rows
contributors
id, object_id, ein, contributor_name, city, state, zip, amount, contributor_type
544,533 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, tax_year
Many rows
officers
id, object_id, ein, person_name, title, avg_hours_per_week, compensation, benefits, expense_account, reportable_comp_filing_org, reportable_comp_related_org, other_compensation, is_highest_compensated_employee, is_officer, is_individual_trustee, is_institutional_trustee, is_key_employee, is_former
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, total_functional_expenses, return_version, contractors_over_100k_cnt, amended_return, return_ts, name_line1, name_line2, name_rule_class, name_street_suffix, group_exemption_num, group_return_for_affiliates_ind, all_affiliates_included_ind, voting_members_cnt, voting_members_independent_cnt, total_employee_cnt, total_volunteers_cnt, gross_receipts, formation_year, legal_domicile_state, activity_or_mission_desc, mission_desc, website, principal_officer_name
Many rows
returns_checklist
id, object_id, ein, described_in_section_501c3_ind, schedule_b_required_ind, political_campaign_acty_ind, lobbying_activities_ind, subject_to_proxy_tax_ind, donor_advised_fund_ind, conservation_easements_ind, collections_of_art_ind, credit_counseling_ind, donor_rstr_or_quasi_endowments_ind, report_land_building_equipment_ind, report_investments_other_sec_ind, report_program_related_invst_ind, report_other_assets_ind, report_other_liabilities_ind, include_fin48_footnote_ind, independent_audit_fincl_stmt_ind, consolidated_audit_fincl_stmt_ind, school_operating_ind, foreign_office_ind, foreign_activities_ind, more_than_5000k_to_org_ind, more_than_5000k_to_individuals_ind, professional_fundraising_ind, fundraising_activities_ind, gaming_activities_ind, operate_hospital_ind, audited_financial_stmt_att_ind, grants_to_organizations_ind, grants_to_individuals_ind, schedule_j_required_ind, tax_exempt_bonds_ind, invest_tax_exempt_bonds_ind, escrow_account_ind, on_behalf_of_issuer_ind, engaged_in_excess_benefit_trans_ind, py_excess_benefit_trans_ind, loan_outstanding_ind, grant_to_related_person_ind, business_rln_with_org_mem_ind, business_rln_with_fam_mem_ind, business_rln_with_35_ctrl_ent_ind, deductible_non_cash_contri_ind, deductible_art_contribution_ind, terminate_operations_ind, partial_liquidation_ind, disregarded_entity_ind, related_entity_ind, related_organization_ctrl_ent_ind, transaction_with_control_ent_ind, trnsfr_exmpt_non_chrtbl_rltd_org_ind, activities_conducted_prtshp_ind, schedule_o_required_ind
Many rows
returns_governance
id, object_id, ein, conflict_of_interest_policy_ind, coi_annual_disclosure_ind, coi_regular_monitoring_ind, whistleblower_policy_ind, document_retention_policy_ind, comp_process_ceo_ind, comp_process_other_ind, family_or_business_rln_ind, material_diversion_ind, form990_provided_to_board_ind, governing_body_voting_members_cnt, independent_voting_members_cnt, delegation_of_mgmt_duties_ind, minutes_of_governing_body_ind
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
1,509,275 rows
top_employees
id, object_id, ein, person_name, title, avg_hours_per_week, compensation, benefits, expense_account, reportable_comp_filing_org, reportable_comp_related_org, other_compensation
57,548 rows
... and 31 hidden tables