Name: Analysis Of 990 EZ SOI For 501(c)(3) 2010-2012
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Analysis Of 990 EZ SOI For 501(c)(3) 2010-2012

The SOI data sets were downloaded from the GitHub page of the NCCS in April 2024. These sets were merged and cleaned with the Python file to create the taxinfocatA csv file for analysis. This reflects analysis of only nonprofits that fall under this category. An executive report with findings is provided in pdf format.

Tables

Soi Microdata 2010–501c3 Charities Ez

@kaggle.skoch2500_analysis_of_990_ez_soi_for_501c3_2010_2012.soi_microdata_2010_501c3_charities_ez

317.56 kB
792 rows
212 columns

CREATE TABLE soi_microdata_2010_501c3_charities_ez (
  "scpl" DOUBLE,
  "ein" BIGINT,
  "e010" BIGINT,
  "cond" VARCHAR,
  "name" VARCHAR,
  "state" VARCHAR,
  "zip5" BIGINT,
  "grp_exmpt_num" DOUBLE,
  "subseccd" BIGINT,
  "fisyr" BIGINT,
  "r040" BIGINT,
  "r050" BIGINT,
  "r060" BIGINT,
  "rz100" BIGINT,
  "rz200" BIGINT,
  "rz300" BIGINT,
  "r190" BIGINT,
  "r199" BIGINT,
  "r200" BIGINT,
  "r210" BIGINT,
  "r220" BIGINT,
  "r230" BIGINT,
  "r240" BIGINT,
  "r250" BIGINT,
  "r260" BIGINT,
  "r270" BIGINT,
  "xz100" BIGINT,
  "f020" BIGINT,
  "xz200" BIGINT,
  "xz300" BIGINT,
  "xz400" BIGINT,
  "xz500" BIGINT,
  "xz600" BIGINT,
  "x050" BIGINT,
  "n010" BIGINT,
  "n020" BIGINT,
  "n030" BIGINT,
  "n040" BIGINT,
  "az101" BIGINT,
  "a023" BIGINT,
  "az201" BIGINT,
  "a030" BIGINT,
  "l010" BIGINT,
  "b010" BIGINT,
  "az100" BIGINT,
  "a160" BIGINT,
  "az200" BIGINT,
  "a180" BIGINT,
  "l090" BIGINT,
  "b020" BIGINT,
  "c020_sum" BIGINT,
  "c030_sum" BIGINT,
  "c040_sum" BIGINT,
  "q020" VARCHAR,
  "q030" VARCHAR,
  "q050" BIGINT,
  "q060" VARCHAR,
  "q150" BIGINT,
  "q160" BIGINT,
  "q170" BIGINT,
  "q180" BIGINT,
  "q190" BIGINT,
  "q200" VARCHAR,
  "q210" BIGINT,
  "q220" BIGINT,
  "q222" VARCHAR,
  "q300" VARCHAR,
  "q310" VARCHAR,
  "h100" BIGINT,
  "h110" BIGINT,
  "h120" BIGINT,
  "h200" BIGINT,
  "h210" BIGINT,
  "h220" BIGINT,
  "h300" BIGINT,
  "h310" BIGINT,
  "h320" BIGINT,
  "h400" BIGINT,
  "h410" BIGINT,
  "h420" BIGINT,
  "h500" BIGINT,
  "h510" BIGINT,
  "h520" BIGINT,
  "h600" BIGINT,
  "non_pf_status_cd" DOUBLE,
  "type_suprtng_org" DOUBLE,
  "cert_chkbx" VARCHAR,
  "wrttn_irs_determ" VARCHAR,
  "contri_by_cntrl_indiv" VARCHAR,
  "contri_by_rltd_prty" VARCHAR,
  "contri_by_35_cntrl_ent" VARCHAR,
  "sum_of_suprtd_amts" BIGINT,
  "pltcl_expend" BIGINT,
  "vlntr_hrs" BIGINT,
  "amt_4955_tx" BIGINT,
  "amt_4955_tx_on_mgrs" BIGINT,
  "frm_4720_filed_4955_tx" VARCHAR,
  "corr_made" VARCHAR,
  "amt_expend_for_527_actvs" BIGINT,
  "amt_intrnl_fnds_contri" BIGINT
);

Soi Microdata 2011–501c3 Charities Ez

@kaggle.skoch2500_analysis_of_990_ez_soi_for_501c3_2010_2012.soi_microdata_2011_501c3_charities_ez

326.24 kB
784 rows
230 columns

CREATE TABLE soi_microdata_2011_501c3_charities_ez (
  "scpl" DOUBLE,
  "ein" BIGINT,
  "e010" BIGINT,
  "cond" VARCHAR,
  "name" VARCHAR,
  "state" VARCHAR,
  "zip5" BIGINT,
  "grp_exmpt_num" DOUBLE,
  "subseccd" BIGINT,
  "fisyr" BIGINT,
  "r040" BIGINT,
  "r050" BIGINT,
  "r060" BIGINT,
  "rz100" BIGINT,
  "rz200" BIGINT,
  "rz300" BIGINT,
  "r190" BIGINT,
  "r195" BIGINT,
  "r200" BIGINT,
  "r210" BIGINT,
  "r220" BIGINT,
  "r230" BIGINT,
  "r240" BIGINT,
  "r250" BIGINT,
  "r260" BIGINT,
  "r270" BIGINT,
  "xz100" BIGINT,
  "f020" BIGINT,
  "xz200" BIGINT,
  "xz300" BIGINT,
  "xz400" BIGINT,
  "xz500" BIGINT,
  "xz600" BIGINT,
  "x050" BIGINT,
  "n010" BIGINT,
  "n020" BIGINT,
  "n030" BIGINT,
  "n040" BIGINT,
  "az101" BIGINT,
  "a023" BIGINT,
  "az201" BIGINT,
  "a030" BIGINT,
  "l010" BIGINT,
  "b010" BIGINT,
  "az100" BIGINT,
  "a160" BIGINT,
  "az200" BIGINT,
  "a180" BIGINT,
  "l090" BIGINT,
  "b020" BIGINT,
  "c020_sum" BIGINT,
  "c030_sum" BIGINT,
  "c040_sum" BIGINT,
  "qx005" VARCHAR,
  "qx010" VARCHAR,
  "qx015" VARCHAR,
  "q020" VARCHAR,
  "qx025" VARCHAR,
  "q030" VARCHAR,
  "q050" BIGINT,
  "q060" VARCHAR,
  "qx070" VARCHAR,
  "qx080" BIGINT,
  "q150" BIGINT,
  "q160" BIGINT,
  "q170" BIGINT,
  "q180" BIGINT,
  "q190" BIGINT,
  "q200" VARCHAR,
  "q210" BIGINT,
  "q220" BIGINT,
  "q222" VARCHAR,
  "qx225" VARCHAR,
  "qx230" VARCHAR,
  "qx235" BIGINT,
  "qx240" VARCHAR,
  "qx245" VARCHAR,
  "qx250" VARCHAR,
  "qx260" VARCHAR,
  "qx270" VARCHAR,
  "qx280" VARCHAR,
  "q300" VARCHAR,
  "q310" VARCHAR,
  "qx320" VARCHAR,
  "qx330" VARCHAR,
  "qx340" VARCHAR,
  "h100" BIGINT,
  "h110" BIGINT,
  "h120" BIGINT,
  "h200" BIGINT,
  "h210" BIGINT,
  "h220" BIGINT,
  "h300" BIGINT,
  "h310" BIGINT,
  "h320" BIGINT,
  "h400" BIGINT,
  "h410" BIGINT,
  "h420" BIGINT,
  "h500" BIGINT,
  "h510" BIGINT
);

Soi Microdata 2012–501c3 Charities Ez

@kaggle.skoch2500_analysis_of_990_ez_soi_for_501c3_2010_2012.soi_microdata_2012_501c3_charities_ez

326.57 kB
797 rows
228 columns

CREATE TABLE soi_microdata_2012_501c3_charities_ez (
  "scpl" DOUBLE,
  "ein" BIGINT,
  "e010" BIGINT,
  "fisyr" BIGINT,
  "cond" VARCHAR,
  "name" VARCHAR,
  "state" VARCHAR,
  "zip5" BIGINT,
  "grp_exmpt_num" DOUBLE,
  "subseccd" BIGINT,
  "r040" BIGINT,
  "r050" BIGINT,
  "r060" BIGINT,
  "rz100" BIGINT,
  "rz200" BIGINT,
  "rz300" BIGINT,
  "r190" BIGINT,
  "r195" BIGINT,
  "r200" BIGINT,
  "r210" BIGINT,
  "r220" BIGINT,
  "r230" BIGINT,
  "r240" BIGINT,
  "r250" BIGINT,
  "r260" BIGINT,
  "r270" BIGINT,
  "xz100" BIGINT,
  "f020" BIGINT,
  "xz200" BIGINT,
  "xz300" BIGINT,
  "xz400" BIGINT,
  "xz500" BIGINT,
  "xz600" BIGINT,
  "x050" BIGINT,
  "n010" BIGINT,
  "n020" BIGINT,
  "n030" BIGINT,
  "n040" BIGINT,
  "az101" BIGINT,
  "a023" BIGINT,
  "az201" BIGINT,
  "a030" BIGINT,
  "l010" BIGINT,
  "b010" BIGINT,
  "az100" BIGINT,
  "a160" BIGINT,
  "az200" BIGINT,
  "a180" BIGINT,
  "l090" BIGINT,
  "b020" BIGINT,
  "c020_sum" BIGINT,
  "c030_sum" BIGINT,
  "c040_sum" BIGINT,
  "qx005" VARCHAR,
  "qx010" VARCHAR,
  "qx015" VARCHAR,
  "q020" VARCHAR,
  "qx025" VARCHAR,
  "q030" VARCHAR,
  "q050" BIGINT,
  "q060" VARCHAR,
  "qx070" VARCHAR,
  "qx080" BIGINT,
  "q150" BIGINT,
  "q160" BIGINT,
  "q170" BIGINT,
  "q180" BIGINT,
  "q190" BIGINT,
  "q200" VARCHAR,
  "q210" BIGINT,
  "q220" BIGINT,
  "q222" VARCHAR,
  "qx225" VARCHAR,
  "qx230" VARCHAR,
  "qx235" BIGINT,
  "qx240" VARCHAR,
  "qx245" VARCHAR,
  "qx250" VARCHAR,
  "qx260" VARCHAR,
  "qx270" VARCHAR,
  "qx280" VARCHAR,
  "q300" VARCHAR,
  "q310" VARCHAR,
  "qx320" VARCHAR,
  "qx330" VARCHAR,
  "qx340" VARCHAR,
  "h100" BIGINT,
  "h110" BIGINT,
  "h120" BIGINT,
  "h200" BIGINT,
  "h210" BIGINT,
  "h220" BIGINT,
  "h300" BIGINT,
  "h310" BIGINT,
  "h320" BIGINT,
  "h400" BIGINT,
  "h410" BIGINT,
  "h420" BIGINT,
  "h500" BIGINT,
  "h510" BIGINT
);

Taxinfocata

@kaggle.skoch2500_analysis_of_990_ez_soi_for_501c3_2010_2012.taxinfocata

12.12 kB
262 rows
6 columns

CREATE TABLE taxinfocata (
  "name" VARCHAR,
  "state" VARCHAR,
  "fiscal_year" BIGINT,
  "category" VARCHAR,
  "total_gross_revenue" BIGINT,
  "net_revenue" BIGINT
);