home

990data_public

Data license: Public Domain (IRS data) · Data source: Internal Revenue Service: Form 990 e-file data and the Exempt Organizations Business Master File

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

1,984,891 rows

bmf_former

ein, name, city, state, subsection, ntee_cd, status, deductibility, foundation, ruling, last_seen_asof, dropped_asof, grp

63,284 rows

bmf_source_meta

loaded_utc, as_of_date, source_files, row_count, content_sha256

1 row

build_metadata

key, value

3 rows

canonical_filings

object_id

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

1,125,268 rows

contributors

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

548,965 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

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, 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

program_activities

id, object_id, ein, activity_num, description, expenses

410,123 rows

program_investments

id, object_id, ein, description, amount

232,007 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

returns_ntee_source

ein, ntee_code, source, source_asof

598,790 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

sqlite_sequence

name, seq

14 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,864 rows

... and 31 hidden tables

Views

  • officer_total_comp
  • canonical_returns
Powered by Datasette · Queries took 686.392ms · Data license: Public Domain (IRS data) · Data source: Internal Revenue Service: Form 990 e-file data and the Exempt Organizations Business Master File · Privacy