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

310.12 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

318.6 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

318.92 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

11.84 KB
262 rows
6 columns


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