{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Notebook Tasks\n",
"\n",
"
\n",
"**_Possible Samples for Statistical Tests_**:\n",
"- Given the above, there are a number of possible tests:
\n",
"\n",
"
IV: SOX Policies | \n", "DV: Donor Advisory | \n", "N | \n", "Notes | \n", "TO DO | \n", "
---|---|---|---|---|
2011 | \n", "2016 | \n", "4,857 | \n", "47 donor advisories on these organizations; associational test (we don't know when the SOX policies were added); also, DV is 'current donor advisory' | \n", "ready to run | \n",
"
2011 | \n", "2012-2016 | \n", "4,857 | \n", "47 2016 advisories plus probably another dozen or so advisories over the 2012-2015 period; associational test as above, but adds in donor advisories that were put in place then dropped between 2012 and 2015. | \n", "some minor work creating this new DV but not very burdensome | \n", "
2011 | \n", "2011 | \n", "5,439 | \n", "39 donor advisories; pure cross-sectional test | \n",
" Download the '2011' 990 data (SOX policies + controls) for the 39 orgs with a 2011 donor advisory; a few hours work to download and enter the data | \n", "
2016 | \n", "2016 | \n", "8,304 | \n", "328 donor advisories; pure cross-sectional test | \n", "ready to run | \n", "
change 2011-2016 | \n", "2016 | \n", "4,857 | \n", "'Divide 4,857 orgs into three groups: i) those with no SOX policies in 2011 and still no SOX policies in 2016; ii) those with SOX policies in 2011 and 2016; and iii) those with no SOX policies in 2011 but SOX policies in 2016. Create dummy variables for each group and see whether those in group iii) do better than i) or ii). This is a relatively low cost 'pre-post' test. | \n", "moderate amount of work to create the new dummies but not too burdensome | \n", "
change 2011-2016 | \n", "2012-2016 | \n", "TBD | \n", "Similar to above option, but would need to take a sample of organizations in group iii) and go through their 990s to find out exactly when they added the SOX policies | \n", "Resource-intensive 990 searches | \n", "
\n", " | donor_advisory | \n", "donor_advisory_2016 | \n", "donor_advisory_2011_to_2016 | \n", "org_id | \n", "EIN | \n", "FYE | \n", "Form 990 FYE | \n", "ratings_system | \n", "2011_data | \n", "2016_data | \n", "conflict_of_interest_policy_v2 | \n", "records_retention_policy_v2 | \n", "whistleblower_policy_v2 | \n", "SOX_policies | \n", "SOX_policies_binary | \n", "SOX_policies_all_binary | \n", "program_efficiency | \n", "complexity | \n", "complexity_2011 | \n", "age | \n", "total_revenue_logged | \n", "category | \n", "state | \n", "tot_rev | \n", "category_Animals | \n", "category_Arts, Culture, Humanities | \n", "category_Community Development | \n", "category_Education | \n", "category_Environment | \n", "category_Health | \n", "category_Human Services | \n", "category_Human and Civil Rights | \n", "category_International | \n", "category_Religion | \n", "category_Research and Public Policy | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50715 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "5954 | \n", "010202467 | \n", "FY2009 | \n", "2009-12 | \n", "CN 2.0 | \n", "1.0 | \n", "0.0 | \n", "1.0 | \n", "1.0 | \n", "1.0 | \n", "3.0 | \n", "1.0 | \n", "1.0 | \n", "0.788895 | \n", "0.0 | \n", "3.0 | \n", "62.0 | \n", "15.947563 | \n", "Research and Public Policy | \n", "ME | \n", "8432154.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "1.0 | \n", "
\n", " | donor_advisory | \n", "donor_advisory_2016 | \n", "donor_advisory_2011_to_2016 | \n", "org_id | \n", "EIN | \n", "FYE | \n", "Form 990 FYE | \n", "ratings_system | \n", "2011_data | \n", "2016_data | \n", "conflict_of_interest_policy_v2 | \n", "records_retention_policy_v2 | \n", "whistleblower_policy_v2 | \n", "SOX_policies | \n", "SOX_policies_binary | \n", "SOX_policies_all_binary | \n", "program_efficiency | \n", "complexity | \n", "complexity_2011 | \n", "age | \n", "total_revenue_logged | \n", "category | \n", "state | \n", "tot_rev | \n", "category_Animals | \n", "category_Arts, Culture, Humanities | \n", "category_Community Development | \n", "category_Education | \n", "category_Environment | \n", "category_Health | \n", "category_Human Services | \n", "category_Human and Civil Rights | \n", "category_International | \n", "category_Religion | \n", "category_Research and Public Policy | \n", "
---|
Dep. Variable: | donor_advisory_2011_to_2016 | No. Observations: | 4833 | \n", "
---|---|---|---|
Model: | Logit | Df Residuals: | 4817 | \n", "
Method: | MLE | Df Model: | 15 | \n", "
Date: | Tue, 06 Sep 2016 | Pseudo R-squ.: | 0.08962 | \n", "
Time: | 12:35:26 | Log-Likelihood: | -363.45 | \n", "
converged: | False | LL-Null: | -399.24 | \n", "
LLR p-value: | 2.351e-09 | \n", "
coef | std err | z | P>|z| | [95.0% Conf. Int.] | \n", "|
---|---|---|---|---|---|
Intercept | -2.6828 | 1.438 | -1.865 | 0.062 | -5.502 0.136 | \n", "
C(category)[T.Arts, Culture, Humanities] | -0.5078 | 0.515 | -0.986 | 0.324 | -1.517 0.502 | \n", "
C(category)[T.Community Development] | -0.3612 | 0.575 | -0.629 | 0.530 | -1.487 0.765 | \n", "
C(category)[T.Education] | -1.2152 | 0.794 | -1.531 | 0.126 | -2.771 0.340 | \n", "
C(category)[T.Environment] | -18.8719 | 4856.123 | -0.004 | 0.997 | -9536.698 9498.954 | \n", "
C(category)[T.Health] | -1.0195 | 0.548 | -1.862 | 0.063 | -2.093 0.054 | \n", "
C(category)[T.Human Services] | -0.1790 | 0.415 | -0.431 | 0.666 | -0.993 0.635 | \n", "
C(category)[T.Human and Civil Rights] | -0.6823 | 0.687 | -0.993 | 0.321 | -2.029 0.664 | \n", "
C(category)[T.International] | -0.3676 | 0.511 | -0.719 | 0.472 | -1.369 0.634 | \n", "
C(category)[T.Religion] | 0.3141 | 0.449 | 0.700 | 0.484 | -0.566 1.194 | \n", "
C(category)[T.Research and Public Policy] | -0.5298 | 0.796 | -0.665 | 0.506 | -2.090 1.031 | \n", "
SOX_policies | -0.4256 | 0.110 | -3.876 | 0.000 | -0.641 -0.210 | \n", "
total_revenue_logged | 0.2806 | 0.101 | 2.785 | 0.005 | 0.083 0.478 | \n", "
program_efficiency | -3.0563 | 0.767 | -3.982 | 0.000 | -4.561 -1.552 | \n", "
age | -0.0065 | 0.007 | -0.981 | 0.327 | -0.019 0.006 | \n", "
complexity_2011 | -0.7391 | 0.274 | -2.700 | 0.007 | -1.275 -0.203 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
2011_data | \n", "84958 | \n", "0.057240 | \n", "0.232302 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1.000000 | \n", "
donor_advisory_2016 | \n", "84958 | \n", "0.004332 | \n", "0.065672 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1.000000 | \n", "
SOX_policies | \n", "21894 | \n", "2.724582 | \n", "0.689867 | \n", "0.000000 | \n", "3.000000 | \n", "3.000000 | \n", "3.000000 | \n", "3.000000 | \n", "
total_revenue_logged | \n", "21825 | \n", "15.911470 | \n", "1.458552 | \n", "11.616123 | \n", "14.781636 | \n", "15.706608 | \n", "16.864409 | \n", "22.042788 | \n", "
program_efficiency | \n", "21894 | \n", "0.805400 | \n", "0.103635 | \n", "0.000000 | \n", "0.756568 | \n", "0.817758 | \n", "0.871105 | \n", "1.010186 | \n", "
age | \n", "83830 | \n", "39.508147 | \n", "19.310175 | \n", "0.000000 | \n", "24.000000 | \n", "35.000000 | \n", "52.000000 | \n", "108.000000 | \n", "
complexity | \n", "84958 | \n", "0.373031 | \n", "1.220945 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "8.000000 | \n", "
complexity_2011 | \n", "4833 | \n", "2.466791 | \n", "0.514468 | \n", "1.000000 | \n", "2.000000 | \n", "2.000000 | \n", "3.000000 | \n", "3.000000 | \n", "
Dep. Variable: | donor_advisory_2011_to_2016 | No. Observations: | 4808 | \n", "
---|---|---|---|
Model: | Logit | Df Residuals: | 4792 | \n", "
Method: | MLE | Df Model: | 15 | \n", "
Date: | Fri, 02 Sep 2016 | Pseudo R-squ.: | 0.08892 | \n", "
Time: | 12:11:05 | Log-Likelihood: | -363.36 | \n", "
converged: | False | LL-Null: | -398.83 | \n", "
LLR p-value: | 3.049e-09 | \n", "
coef | std err | z | P>|z| | [95.0% Conf. Int.] | \n", "|
---|---|---|---|---|---|
Intercept | -2.6649 | 1.444 | -1.845 | 0.065 | -5.495 0.166 | \n", "
C(category)[T.Arts, Culture, Humanities] | -0.5071 | 0.515 | -0.985 | 0.325 | -1.516 0.502 | \n", "
C(category)[T.Community Development] | -0.3595 | 0.575 | -0.626 | 0.532 | -1.486 0.767 | \n", "
C(category)[T.Education] | -1.2142 | 0.794 | -1.530 | 0.126 | -2.770 0.341 | \n", "
C(category)[T.Environment] | -20.2785 | 9810.033 | -0.002 | 0.998 | -1.92e+04 1.92e+04 | \n", "
C(category)[T.Health] | -1.0181 | 0.548 | -1.859 | 0.063 | -2.092 0.055 | \n", "
C(category)[T.Human Services] | -0.1780 | 0.415 | -0.429 | 0.668 | -0.992 0.636 | \n", "
C(category)[T.Human and Civil Rights] | -0.6780 | 0.687 | -0.987 | 0.324 | -2.025 0.669 | \n", "
C(category)[T.International] | -0.3664 | 0.511 | -0.717 | 0.474 | -1.368 0.636 | \n", "
C(category)[T.Religion] | 0.3200 | 0.449 | 0.712 | 0.476 | -0.560 1.200 | \n", "
C(category)[T.Research and Public Policy] | -0.5291 | 0.796 | -0.665 | 0.506 | -2.090 1.031 | \n", "
SOX_policies | -0.4264 | 0.110 | -3.882 | 0.000 | -0.642 -0.211 | \n", "
total_revenue_logged | 0.2790 | 0.101 | 2.753 | 0.006 | 0.080 0.478 | \n", "
program_efficiency | -3.0518 | 0.768 | -3.976 | 0.000 | -4.556 -1.547 | \n", "
age | -0.0064 | 0.007 | -0.977 | 0.329 | -0.019 0.006 | \n", "
complexity_2011 | -0.7374 | 0.274 | -2.695 | 0.007 | -1.274 -0.201 | \n", "
Dep. Variable: | donor_advisory_2011_to_2016 | No. Observations: | 4833 | \n", "
---|---|---|---|
Model: | Logit | Df Residuals: | 4817 | \n", "
Method: | MLE | Df Model: | 15 | \n", "
Date: | Tue, 06 Sep 2016 | Pseudo R-squ.: | 0.08962 | \n", "
Time: | 12:35:43 | Log-Likelihood: | -363.45 | \n", "
converged: | False | LL-Null: | -399.24 | \n", "
LLR p-value: | 2.351e-09 | \n", "
coef | std err | z | P>|z| | [95.0% Conf. Int.] | \n", "|
---|---|---|---|---|---|
Intercept | -2.6828 | 1.038 | -2.585 | 0.010 | -4.717 -0.649 | \n", "
C(category)[T.Arts, Culture, Humanities] | -0.5078 | 0.465 | -1.092 | 0.275 | -1.419 0.404 | \n", "
C(category)[T.Community Development] | -0.3612 | 0.700 | -0.516 | 0.606 | -1.733 1.010 | \n", "
C(category)[T.Education] | -1.2152 | 0.683 | -1.779 | 0.075 | -2.554 0.123 | \n", "
C(category)[T.Environment] | -18.8719 | 0.433 | -43.552 | 0.000 | -19.721 -18.023 | \n", "
C(category)[T.Health] | -1.0195 | 0.520 | -1.959 | 0.050 | -2.039 0.000 | \n", "
C(category)[T.Human Services] | -0.1790 | 0.370 | -0.484 | 0.628 | -0.904 0.546 | \n", "
C(category)[T.Human and Civil Rights] | -0.6823 | 0.483 | -1.412 | 0.158 | -1.629 0.265 | \n", "
C(category)[T.International] | -0.3676 | 0.487 | -0.754 | 0.451 | -1.323 0.588 | \n", "
C(category)[T.Religion] | 0.3141 | 0.470 | 0.668 | 0.504 | -0.607 1.235 | \n", "
C(category)[T.Research and Public Policy] | -0.5298 | 0.526 | -1.007 | 0.314 | -1.561 0.501 | \n", "
SOX_policies | -0.4256 | 0.093 | -4.588 | 0.000 | -0.607 -0.244 | \n", "
total_revenue_logged | 0.2806 | 0.074 | 3.776 | 0.000 | 0.135 0.426 | \n", "
program_efficiency | -3.0563 | 0.816 | -3.744 | 0.000 | -4.656 -1.456 | \n", "
age | -0.0065 | 0.005 | -1.199 | 0.231 | -0.017 0.004 | \n", "
complexity_2011 | -0.7391 | 0.263 | -2.814 | 0.005 | -1.254 -0.224 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
overall_rating_2011 | \n", "4833 | \n", "53.547455 | \n", "8.933975e+00 | \n", "8.040000e+00 | \n", "48.73 | \n", "54.61 | \n", "59.97 | \n", "6.996000e+01 | \n", "
overall_rating_star_2011 | \n", "4833 | \n", "2.869646 | \n", "8.916785e-01 | \n", "0.000000e+00 | \n", "2.00 | \n", "3.00 | \n", "3.00 | \n", "4.000000e+00 | \n", "
efficiency_rating_2011 | \n", "4833 | \n", "53.430780 | \n", "1.048261e+01 | \n", "0.000000e+00 | \n", "46.53 | \n", "54.88 | \n", "61.73 | \n", "6.997000e+01 | \n", "
AT_rating_2011 | \n", "4833 | \n", "56.446100 | \n", "1.152050e+01 | \n", "-2.000000e+00 | \n", "52.00 | \n", "59.00 | \n", "63.00 | \n", "7.000000e+01 | \n", "
financial_rating_star_2011 | \n", "4833 | \n", "2.850403 | \n", "1.007304e+00 | \n", "0.000000e+00 | \n", "2.00 | \n", "3.00 | \n", "4.00 | \n", "4.000000e+00 | \n", "
AT_rating_star_2011 | \n", "4833 | \n", "3.128078 | \n", "1.001005e+00 | \n", "0.000000e+00 | \n", "3.00 | \n", "3.00 | \n", "4.00 | \n", "4.000000e+00 | \n", "
program_expense_percent_2011 | \n", "4833 | \n", "80.416325 | \n", "1.055343e+01 | \n", "2.200000e+00 | \n", "75.50 | \n", "81.60 | \n", "87.00 | \n", "9.970000e+01 | \n", "
admin_expense_percent_2011 | \n", "4833 | \n", "10.320608 | \n", "6.665639e+00 | \n", "-5.000000e-01 | \n", "5.80 | \n", "9.20 | \n", "13.20 | \n", "6.790000e+01 | \n", "
fund_expense_percent_2011 | \n", "4833 | \n", "9.110180 | \n", "8.056593e+00 | \n", "0.000000e+00 | \n", "4.10 | \n", "7.50 | \n", "11.90 | \n", "9.070000e+01 | \n", "
fund_efficiency_2011 | \n", "4833 | \n", "0.129679 | \n", "5.190376e-01 | \n", "0.000000e+00 | \n", "0.05 | \n", "0.10 | \n", "0.16 | \n", "3.533000e+01 | \n", "
primary_revenue_growth_2011 | \n", "4833 | \n", "4.403580 | \n", "1.554988e+01 | \n", "-7.960000e+01 | \n", "-3.50 | \n", "2.60 | \n", "10.20 | \n", "2.452000e+02 | \n", "
program_expense_growth_2011 | \n", "4833 | \n", "6.314918 | \n", "2.073699e+01 | \n", "-5.320000e+01 | \n", "-1.10 | \n", "4.10 | \n", "11.10 | \n", "1.007400e+03 | \n", "
working_capital_ratio_2011 | \n", "4833 | \n", "1.788438 | \n", "2.455707e+00 | \n", "-3.260000e+00 | \n", "0.44 | \n", "1.01 | \n", "2.20 | \n", "5.842000e+01 | \n", "
primary_revenue_2011 | \n", "4833 | \n", "16525465.992551 | \n", "7.313324e+07 | \n", "1.498700e+04 | \n", "1989838.00 | \n", "4430280.00 | \n", "11346855.00 | \n", "3.502077e+09 | \n", "
other_revenue_2011 | \n", "4833 | \n", "651129.463066 | \n", "6.235616e+06 | \n", "-6.612359e+07 | \n", "5922.00 | \n", "99129.00 | \n", "443689.00 | \n", "2.392543e+08 | \n", "
total_revenue_2011 | \n", "4833 | \n", "17176106.777985 | \n", "7.570407e+07 | \n", "-4.263887e+07 | \n", "2103386.00 | \n", "4673878.00 | \n", "11721565.00 | \n", "3.587775e+09 | \n", "
program_expense_2011 | \n", "4833 | \n", "14784010.616387 | \n", "6.451777e+07 | \n", "2.848300e+04 | \n", "1694422.00 | \n", "3808132.00 | \n", "9557716.00 | \n", "3.091879e+09 | \n", "
admin_expense_2011 | \n", "4833 | \n", "1477281.476929 | \n", "7.805211e+06 | \n", "-8.585600e+04 | \n", "188863.00 | \n", "412603.00 | \n", "1010869.00 | \n", "4.323913e+08 | \n", "
fund_expense_2011 | \n", "4833 | \n", "1133717.688599 | \n", "5.382822e+06 | \n", "0.000000e+00 | \n", "160486.00 | \n", "359811.00 | \n", "830250.00 | \n", "2.231224e+08 | \n", "
total_functional_expense_2011 | \n", "4833 | \n", "17395155.368922 | \n", "7.292829e+07 | \n", "1.507310e+05 | \n", "2188637.00 | \n", "4769351.00 | \n", "11766482.00 | \n", "3.354177e+09 | \n", "
affiliate_payments_2011 | \n", "4833 | \n", "60756.626733 | \n", "1.812179e+06 | \n", "-4.059500e+05 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.235951e+08 | \n", "
budget_surplus_2011 | \n", "4833 | \n", "-219048.159321 | \n", "9.895040e+06 | \n", "-3.008552e+08 | \n", "-477470.00 | \n", "1652.00 | \n", "452604.00 | \n", "2.335980e+08 | \n", "
net_assets_2011 | \n", "4833 | \n", "33372071.914339 | \n", "1.651812e+08 | \n", "-1.691832e+07 | \n", "2013666.00 | \n", "6004379.00 | \n", "19206628.00 | \n", "7.002755e+09 | \n", "
leader_comp_2011 | \n", "4657 | \n", "153519.535753 | \n", "1.313950e+05 | \n", "0.000000e+00 | \n", "80808.00 | \n", "126250.00 | \n", "191203.00 | \n", "2.257910e+06 | \n", "
leader_comp_percent_2011 | \n", "4657 | \n", "3.166133 | \n", "3.015173e+00 | \n", "0.000000e+00 | \n", "1.00 | \n", "2.33 | \n", "4.44 | \n", "3.090000e+01 | \n", "
\n", " | charity_name_2011 | \n", "category_2011 | \n", "city_2011 | \n", "state_2011 | \n", "cause_2011 | \n", "tag_line_2011 | \n", "url_2011 | \n", "ein_2011 | \n", "fye_2011 | \n", "overall_rating_2011 | \n", "overall_rating_star_2011 | \n", "efficiency_rating_2011 | \n", "AT_rating_2011 | \n", "financial_rating_star_2011 | \n", "AT_rating_star_2011 | \n", "program_expense_percent_2011 | \n", "admin_expense_percent_2011 | \n", "fund_expense_percent_2011 | \n", "fund_efficiency_2011 | \n", "primary_revenue_growth_2011 | \n", "program_expense_growth_2011 | \n", "working_capital_ratio_2011 | \n", "independent_board_2011 | \n", "no_material_division_2011 | \n", "audited_financials_2011 | \n", "no_loans_related_2011 | \n", "documents_minutes_2011 | \n", "form_990_2011 | \n", "conflict_of_interest_policy_2011 | \n", "whistleblower_policy_2011 | \n", "records_retention_policy_2011 | \n", "CEO_listed_2011 | \n", "process_CEO_compensation_2011 | \n", "no_board_compensation_2011 | \n", "donor_privacy_policy_2011 | \n", "board_listed_2011 | \n", "audited_financials_web_2011 | \n", "form_990_web_2011 | \n", "staff_listed_2011 | \n", "primary_revenue_2011 | \n", "other_revenue_2011 | \n", "total_revenue_2011 | \n", "govt_revenue_2011 | \n", "program_expense_2011 | \n", "admin_expense_2011 | \n", "fund_expense_2011 | \n", "total_functional_expense_2011 | \n", "affiliate_payments_2011 | \n", "budget_surplus_2011 | \n", "net_assets_2011 | \n", "leader_comp_2011 | \n", "leader_comp_percent_2011 | \n", "email_2011 | \n", "website_2011 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
35 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
36 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
37 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
38 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
39 | \n", "100 Club of Arizona | \n", "Human Services | \n", "Phoenix | \n", "AZ | \n", "Multipurpose Human Service Organizations | \n", "Supporting families of public safety | \n", "http://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=12123 | \n", "23-7172077 | \n", "12/2009 | \n", "63.84 | \n", "4 | \n", "66.58 | \n", "62 | \n", "4 | \n", "4 | \n", "82.4 | \n", "14.4 | \n", "3 | \n", "0.03 | \n", "6.2 | \n", "6.3 | \n", "1.06 | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "NO | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "NO | \n", "yes | \n", "yes | \n", "1212051 | \n", "-227543 | \n", "984508 | \n", "Note: This organization receives $0 in government support. | \n", "1019191 | \n", "178385 | \n", "37899 | \n", "1235475 | \n", "0 | \n", "-250967 | \n", "1316781 | \n", "122623 | \n", "9.92 | \n", "info@100club.org | \n", "http://www.100club.org | \n", "
40 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
41 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
42 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
total_revenue_2011_logged | \n", "4811 | \n", "15.530981 | \n", "1.282845 | \n", "12.586466 | \n", "14.569243 | \n", "15.36338 | \n", "16.27977 | \n", "2.200080e+01 | \n", "
total_revenue_2011 | \n", "4833 | \n", "17176106.777985 | \n", "75704074.259743 | \n", "-42638874.000000 | \n", "2103386.000000 | \n", "4673878.00000 | \n", "11721565.00000 | \n", "3.587775e+09 | \n", "
Dep. Variable: | donor_advisory_2016 | No. Observations: | 4808 | \n", "
---|---|---|---|
Model: | Logit | Df Residuals: | 4802 | \n", "
Method: | MLE | Df Model: | 5 | \n", "
Date: | Wed, 31 Aug 2016 | Pseudo R-squ.: | 0.08557 | \n", "
Time: | 21:43:38 | Log-Likelihood: | -215.96 | \n", "
converged: | True | LL-Null: | -236.17 | \n", "
LLR p-value: | 1.229e-07 | \n", "
coef | std err | z | P>|z| | [95.0% Conf. Int.] | \n", "|
---|---|---|---|---|---|
Intercept | -3.0296 | 1.925 | -1.574 | 0.115 | -6.802 0.743 | \n", "
SOX_policies_2011 | -0.4992 | 0.145 | -3.448 | 0.001 | -0.783 -0.215 | \n", "
total_revenue_2011_logged | 0.3113 | 0.138 | 2.260 | 0.024 | 0.041 0.581 | \n", "
program_expense_percent_2011 | -0.0285 | 0.009 | -3.068 | 0.002 | -0.047 -0.010 | \n", "
age | -0.0104 | 0.009 | -1.130 | 0.258 | -0.028 0.008 | \n", "
complexity_2011 | -1.2189 | 0.358 | -3.402 | 0.001 | -1.921 -0.517 | \n", "
Dep. Variable: | donor_advisory_2016 | No. Observations: | 4808 | \n", "
---|---|---|---|
Model: | Logit | Df Residuals: | 4802 | \n", "
Method: | MLE | Df Model: | 5 | \n", "
Date: | Wed, 31 Aug 2016 | Pseudo R-squ.: | 0.08557 | \n", "
Time: | 21:46:12 | Log-Likelihood: | -215.96 | \n", "
converged: | True | LL-Null: | -236.17 | \n", "
LLR p-value: | 1.229e-07 | \n", "
coef | std err | z | P>|z| | [95.0% Conf. Int.] | \n", "|
---|---|---|---|---|---|
Intercept | -3.0296 | 1.925 | -1.574 | 0.115 | -6.802 0.743 | \n", "
SOX_policies_2011 | -0.4992 | 0.145 | -3.448 | 0.001 | -0.783 -0.215 | \n", "
total_revenue_2011_logged | 0.3113 | 0.138 | 2.260 | 0.024 | 0.041 0.581 | \n", "
program_expense_percent_2011 | -0.0285 | 0.009 | -3.068 | 0.002 | -0.047 -0.010 | \n", "
age | -0.0104 | 0.009 | -1.130 | 0.258 | -0.028 0.008 | \n", "
complexity_2011 | -1.2189 | 0.358 | -3.402 | 0.001 | -1.921 -0.517 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
SOX_policies_2011 | \n", "4833 | \n", "2.533416 | \n", "0.869466 | \n", "0.000000 | \n", "2.000000 | \n", "3.00000 | \n", "3.00000 | \n", "3.000000 | \n", "
total_revenue_2011_logged | \n", "4811 | \n", "15.530981 | \n", "1.282845 | \n", "12.586466 | \n", "14.569243 | \n", "15.36338 | \n", "16.27977 | \n", "22.000798 | \n", "
program_expense_percent_2011 | \n", "4833 | \n", "80.416325 | \n", "10.553429 | \n", "2.200000 | \n", "75.500000 | \n", "81.60000 | \n", "87.00000 | \n", "99.700000 | \n", "
age | \n", "4860 | \n", "40.051029 | \n", "19.240216 | \n", "0.000000 | \n", "25.000000 | \n", "35.00000 | \n", "52.00000 | \n", "108.000000 | \n", "
complexity_2011 | \n", "4833 | \n", "2.466791 | \n", "0.514468 | \n", "1.000000 | \n", "2.000000 | \n", "2.00000 | \n", "3.00000 | \n", "3.000000 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
donor_advisory_2016 | \n", "4808 | \n", "0.008527 | \n", "0.091959 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.0000 | \n", "1.000000 | \n", "
SOX_policies_2011 | \n", "4808 | \n", "2.534110 | \n", "0.869042 | \n", "0.000000 | \n", "2.000000 | \n", "3.000000 | \n", "3.0000 | \n", "3.000000 | \n", "
total_revenue_2011_logged | \n", "4808 | \n", "15.532027 | \n", "1.282551 | \n", "12.586466 | \n", "14.569824 | \n", "15.364199 | \n", "16.2804 | \n", "22.000798 | \n", "
program_expense_percent_2011 | \n", "4808 | \n", "80.427787 | \n", "10.558554 | \n", "2.200000 | \n", "75.500000 | \n", "81.600000 | \n", "87.0000 | \n", "99.700000 | \n", "
age | \n", "4808 | \n", "40.016015 | \n", "19.198956 | \n", "0.000000 | \n", "25.000000 | \n", "35.000000 | \n", "52.0000 | \n", "108.000000 | \n", "
complexity_2011 | \n", "4808 | \n", "2.466722 | \n", "0.514543 | \n", "1.000000 | \n", "2.000000 | \n", "2.000000 | \n", "3.0000 | \n", "3.000000 | \n", "
Dep. Variable: | donor_advisory_2016 | No. Observations: | 4808 | \n", "
---|---|---|---|
Model: | Logit | Df Residuals: | 4792 | \n", "
Method: | MLE | Df Model: | 15 | \n", "
Date: | Wed, 31 Aug 2016 | Pseudo R-squ.: | 0.1172 | \n", "
Time: | 21:48:06 | Log-Likelihood: | -208.48 | \n", "
converged: | False | LL-Null: | -236.17 | \n", "
LLR p-value: | 1.546e-06 | \n", "
coef | std err | z | P>|z| | [95.0% Conf. Int.] | \n", "|
---|---|---|---|---|---|
Intercept | -3.4848 | 1.884 | -1.849 | 0.064 | -7.178 0.208 | \n", "
C(category)[T.Arts, Culture, Humanities] | -0.7432 | 0.965 | -0.770 | 0.441 | -2.635 1.149 | \n", "
C(category)[T.Community Development] | 0.2960 | 0.856 | 0.346 | 0.730 | -1.382 1.974 | \n", "
C(category)[T.Education] | -0.1108 | 0.901 | -0.123 | 0.902 | -1.877 1.655 | \n", "
C(category)[T.Environment] | -17.5510 | 0.614 | -28.598 | 0.000 | -18.754 -16.348 | \n", "
C(category)[T.Health] | -0.1414 | 0.744 | -0.190 | 0.849 | -1.600 1.317 | \n", "
C(category)[T.Human Services] | -0.2230 | 0.760 | -0.293 | 0.769 | -1.713 1.268 | \n", "
C(category)[T.Human and Civil Rights] | -0.0320 | 0.774 | -0.041 | 0.967 | -1.550 1.486 | \n", "
C(category)[T.International] | -0.0034 | 0.766 | -0.004 | 0.996 | -1.505 1.498 | \n", "
C(category)[T.Religion] | 1.1258 | 0.708 | 1.589 | 0.112 | -0.263 2.514 | \n", "
C(category)[T.Research and Public Policy] | 0.5617 | 0.799 | 0.703 | 0.482 | -1.004 2.127 | \n", "
SOX_policies_2011 | -0.4728 | 0.124 | -3.805 | 0.000 | -0.716 -0.229 | \n", "
total_revenue_2011_logged | 0.2978 | 0.126 | 2.356 | 0.018 | 0.050 0.546 | \n", "
program_expense_percent_2011 | -0.0330 | 0.011 | -2.998 | 0.003 | -0.055 -0.011 | \n", "
age | -0.0104 | 0.007 | -1.499 | 0.134 | -0.024 0.003 | \n", "
complexity_2011 | -0.8049 | 0.465 | -1.730 | 0.084 | -1.717 0.107 | \n", "
Dep. Variable: | donor_advisory_2016 | No. Observations: | 4808 | \n", "
---|---|---|---|
Model: | Logit | Df Residuals: | 4792 | \n", "
Method: | MLE | Df Model: | 15 | \n", "
Date: | Wed, 31 Aug 2016 | Pseudo R-squ.: | 0.1172 | \n", "
Time: | 21:48:36 | Log-Likelihood: | -208.48 | \n", "
converged: | False | LL-Null: | -236.17 | \n", "
LLR p-value: | 1.546e-06 | \n", "
coef | std err | z | P>|z| | [95.0% Conf. Int.] | \n", "|
---|---|---|---|---|---|
Intercept | -3.4848 | 2.010 | -1.734 | 0.083 | -7.424 0.454 | \n", "
C(category)[T.Arts, Culture, Humanities] | -0.7432 | 0.940 | -0.790 | 0.429 | -2.586 1.100 | \n", "
C(category)[T.Community Development] | 0.2960 | 0.835 | 0.354 | 0.723 | -1.341 1.933 | \n", "
C(category)[T.Education] | -0.1108 | 0.929 | -0.119 | 0.905 | -1.931 1.709 | \n", "
C(category)[T.Environment] | -17.5510 | 4367.028 | -0.004 | 0.997 | -8576.769 8541.667 | \n", "
C(category)[T.Health] | -0.1414 | 0.755 | -0.187 | 0.851 | -1.620 1.338 | \n", "
C(category)[T.Human Services] | -0.2230 | 0.707 | -0.315 | 0.753 | -1.609 1.163 | \n", "
C(category)[T.Human and Civil Rights] | -0.0320 | 0.934 | -0.034 | 0.973 | -1.863 1.799 | \n", "
C(category)[T.International] | -0.0034 | 0.790 | -0.004 | 0.997 | -1.552 1.545 | \n", "
C(category)[T.Religion] | 1.1258 | 0.673 | 1.672 | 0.095 | -0.194 2.445 | \n", "
C(category)[T.Research and Public Policy] | 0.5617 | 0.930 | 0.604 | 0.546 | -1.260 2.384 | \n", "
SOX_policies_2011 | -0.4728 | 0.146 | -3.240 | 0.001 | -0.759 -0.187 | \n", "
total_revenue_2011_logged | 0.2978 | 0.139 | 2.150 | 0.032 | 0.026 0.569 | \n", "
program_expense_percent_2011 | -0.0330 | 0.010 | -3.336 | 0.001 | -0.052 -0.014 | \n", "
age | -0.0104 | 0.010 | -1.081 | 0.280 | -0.029 0.008 | \n", "
complexity_2011 | -0.8049 | 0.394 | -2.045 | 0.041 | -1.576 -0.034 | \n", "
\n", " | name | \n", "org_id | \n", "FYE | \n", "2011 data | \n", "current_donor_advisory | \n", "past_donor_advisory | \n", "SOX_policies_2011 | \n", "
---|---|---|---|---|---|---|---|
21 | \n", "10,000 Degrees | \n", "6466 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
39 | \n", "100 Club of Arizona | \n", "12123 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "2 | \n", "
52 | \n", "1000 Friends of Florida | \n", "10092 | \n", "FY2008 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
63 | \n", "1000 Friends of Oregon | \n", "8770 | \n", "FY2010 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
148 | \n", "4 Paws for Ability | \n", "13055 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
161 | \n", "The 92nd Street Y | \n", "4792 | \n", "FY2010 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
185 | \n", "A Better Chance | \n", "6082 | \n", "FY2010 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
208 | \n", "A Contemporary Theatre | \n", "3634 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
228 | \n", "A Kid Again | \n", "9239 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
244 | \n", "A Noise Within | \n", "10176 | \n", "FY2010 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "
255 | \n", "A Place Called Home | \n", "8040 | \n", "FY2010 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
276 | \n", "A.J. Muste Memorial Institute | \n", "6096 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
292 | \n", "AAA Foundation for Traffic Safety | \n", "8302 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
312 | \n", "Aaron Diamond AIDS Research Center | \n", "4991 | \n", "FY2010 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
328 | \n", "AARP Foundation | \n", "3205 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
337 | \n", "AAUW - American Association of University Women | \n", "3240 | \n", "FY2010 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
362 | \n", "Abilities United | \n", "7940 | \n", "FY2010 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
373 | \n", "The Ability Experience | \n", "7632 | \n", "FY2010 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
385 | \n", "Abode Services | \n", "9182 | \n", "FY2010 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
399 | \n", "The Abraham Fund Initiatives | \n", "9371 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
426 | \n", "Abused Deaf Women's Advocacy Services | \n", "12762 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
441 | \n", "Academy of Achievement | \n", "5705 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "
458 | \n", "Academy of American Poets | \n", "9256 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
477 | \n", "The Academy of Natural Sciences of Drexel University | \n", "3209 | \n", "FY2009 | \n", "1 | \n", "0 | \n", "0 | \n", "3 | \n", "
\n", " | org_id | \n", "EIN | \n", "org_url | \n", "name | \n", "category | \n", "category-full | \n", "Date Published | \n", "Form 990 FYE | \n", "Form 990 FYE, v2 | \n", "FYE | \n", "Earliest Rating Publication Date | \n", "ratings_system | \n", "Overall Score | \n", "Overall Rating | \n", "advisory text - current advisory | \n", "advisory text - past advisory | \n", "current_or_past_donor_advisory | \n", "current_donor_advisory | \n", "past_donor_advisory | \n", "latest_entry | \n", "current_ratings_url | \n", "ein_2016 | \n", "Publication_date_and_FY_2016 | \n", "Publication Date_2016 | \n", "FYE_2016 | \n", "donor_alert_2016 | \n", "overall_rating_2016 | \n", "efficiency_rating_rating_2016 | \n", "AT_rating_2016 | \n", "overall_rating_star_2016 | \n", "financial_rating_star_2016 | \n", "AT_rating_star_2016 | \n", "program_expense_percent_2016 | \n", "admin_expense_percent_2016 | \n", "fund_expense_percent_2016 | \n", "fund_efficiency_2016 | \n", "working_capital_ratio_2016 | \n", "program_expense_growth_2016 | \n", "liabilities_to_assets_2016 | \n", "independent_board_2016 | \n", "no_material_division_2016 | \n", "audited_financials_2016 | \n", "no_loans_related_2016 | \n", "documents_minutes_2016 | \n", "form_990_2016 | \n", "conflict_of_interest_policy_2016 | \n", "whistleblower_policy_2016 | \n", "records_retention_policy_2016 | \n", "CEO_listed_2016 | \n", "process_CEO_compensation_2016 | \n", "no_board_compensation_2016 | \n", "donor_privacy_policy_2016 | \n", "board_listed_2016 | \n", "audited_financials_web_2016 | \n", "form_990_web_2016 | \n", "staff_listed_2016 | \n", "contributions_gifts_grants_2016 | \n", "federated_campaigns_2016 | \n", "membership_dues_2016 | \n", "fundraising_events_2016 | \n", "related_organizations_2016 | \n", "government_grants_2016 | \n", "total_contributions_2016 | \n", "program_service_revenue_2016 | \n", "total_primary_revenue_2016 | \n", "other_revenue_2016 | \n", "total_revenue_2016 | \n", "program_expenses_2016 | \n", "administrative_expenses_2016 | \n", "fundraising_expenses_2016 | \n", "total_functional_expenses_2016 | \n", "payments_to_affiliates_2016 | \n", "excess_or_deficit_2016 | \n", "net_assets_2016 | \n", "comp_2016 | \n", "cp_2016 | \n", "mission_2016 | \n", "2011 data | \n", "charity_name_2011 | \n", "category_2011 | \n", "city_2011 | \n", "state_2011 | \n", "cause_2011 | \n", "tag_line_2011 | \n", "url_2011 | \n", "ein_2011 | \n", "fye_2011 | \n", "overall_rating_2011 | \n", "overall_rating_2011_plus_30 | \n", "overall_rating_2011_plus_30_v2 | \n", "overall_rating_star_2011 | \n", "overall_rating_star_2011_text | \n", "efficiency_rating_2011 | \n", "AT_rating_2011 | \n", "financial_rating_star_2011 | \n", "AT_rating_star_2011 | \n", "program_expense_percent_2011 | \n", "admin_expense_percent_2011 | \n", "fund_expense_percent_2011 | \n", "fund_efficiency_2011 | \n", "primary_revenue_growth_2011 | \n", "program_expense_growth_2011 | \n", "working_capital_ratio_2011 | \n", "independent_board_2011 | \n", "no_material_division_2011 | \n", "audited_financials_2011 | \n", "no_loans_related_2011 | \n", "documents_minutes_2011 | \n", "form_990_2011 | \n", "conflict_of_interest_policy_2011 | \n", "whistleblower_policy_2011 | \n", "records_retention_policy_2011 | \n", "CEO_listed_2011 | \n", "process_CEO_compensation_2011 | \n", "no_board_compensation_2011 | \n", "donor_privacy_policy_2011 | \n", "board_listed_2011 | \n", "audited_financials_web_2011 | \n", "form_990_web_2011 | \n", "staff_listed_2011 | \n", "primary_revenue_2011 | \n", "other_revenue_2011 | \n", "total_revenue_2011 | \n", "govt_revenue_2011 | \n", "program_expense_2011 | \n", "admin_expense_2011 | \n", "fund_expense_2011 | \n", "total_functional_expense_2011 | \n", "affiliate_payments_2011 | \n", "budget_surplus_2011 | \n", "net_assets_2011 | \n", "leader_comp_2011 | \n", "leader_comp_percent_2011 | \n", "email_2011 | \n", "website_2011 | \n", "2016 Advisory - Date Posted | \n", "2016 Advisory - Charity Name | \n", "2016 Advisory - advisory_url | \n", "2016 Advisory - advisory | \n", "_merge_v1 | \n", "to_be_merged | \n", "NEW ROW | \n", "NAME_2015_BMF | \n", "STREET_2015_BMF | \n", "CITY_2015_BMF | \n", "STATE_2015_BMF | \n", "ZIP_2015_BMF | \n", "RULING_2015_BMF | \n", "ACTIVITY_2015_BMF | \n", "TAX_PERIOD_2015_BMF | \n", "ASSET_AMT_2015_BMF | \n", "INCOME_AMT_2015_BMF | \n", "REVENUE_AMT_2015_BMF | \n", "NTEE_CD_2015_BMF | \n", "2015 BMF | \n", "ruledate_2004_BMF | \n", "name_MSTRALL | \n", "state_MSTRALL | \n", "NTEE1_MSTRALL | \n", "nteecc_MSTRALL | \n", "zip_MSTRALL | \n", "fips_MSTRALL | \n", "taxper_MSTRALL | \n", "income_MSTRALL | \n", "F990REV_MSTRALL | \n", "assets_MSTRALL | \n", "ruledate_MSTRALL | \n", "deductcd_MSTRALL | \n", "accper_MSTRALL | \n", "rule_date_v1 | \n", "taxpd | \n", "NAME_SOI | \n", "yr_frmtn | \n", "pt1_num_vtng_gvrn_bdy_mems | \n", "pt1_num_ind_vtng_mems | \n", "num_vtng_gvrn_bdy_mems | \n", "num_ind_vtng_mems | \n", "tot_num_empls | \n", "tot_num_vlntrs | \n", "contri_grnts_cy | \n", "prog_srvc_rev_cy | \n", "invst_incm_cy | \n", "oth_rev_cy | \n", "grnts_and_smlr_amts_cy | \n", "tot_prof_fndrsng_exp_cy | \n", "tot_fndrsng_exp_cy | \n", "pt1_tot_asts_eoy | \n", "aud_fincl_stmts | \n", "mtrl_divrsn_or_misuse | \n", "cnflct_int_plcy | \n", "whistleblower_plcy | \n", "doc_retention_plcy | \n", "federated_campaigns | \n", "memshp_dues | \n", "rltd_orgs | \n", "govt_grnts | \n", "all_oth_contri | \n", "nncsh_contri | \n", "tot_contri | \n", "psr_tot | \n", "inv_incm_tot_rev | \n", "bonds_tot_rev | \n", "roylrev_tot_rev | \n", "net_rent_tot_rev | \n", "gain_or_loss_sec | \n", "gain_or_loss_oth | \n", "oth_rev_tot | \n", "tot_rev | \n", "mgmt_srvc_fee_tot | \n", "fee_for_srvc_leg_tot | \n", "fee_for_srvc_acct_tot | \n", "fee_for_srvc_lbby_tot | \n", "fee_for_srvc_prof_tot | \n", "fee_for_srvc_invst_tot | \n", "fee_for_srvc_oth_tot | \n", "fs_audited | \n", "audit_committee | \n", "vlntr_hrs | \n", "_merge | \n", "rule_date | \n", "ruledate_2004_BMF_v2 | \n", "ruledate_MSTRALL_v2 | \n", "yr_frmtn_v2 | \n", "age | \n", "category_Animals | \n", "category_Arts, Culture, Humanities | \n", "category_Community Development | \n", "category_Education | \n", "category_Environment | \n", "category_Health | \n", "category_Human Services | \n", "category_Human and Civil Rights | \n", "category_International | \n", "category_Religion | \n", "category_Research and Public Policy | \n", "govt_revenue_2011_binary | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | \n", "10166 | \n", "043314346 | \n", "http://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=10166 | \n", "Angel Flight Northeast | \n", "Health | \n", "Health : Patient and Family Support | \n", "2011-01-05 00:00:00 | \n", "2009-12 | \n", "2009-12-01 | \n", "FY2009 | \n", "2005-12-01 | \n", "CN 1.0 | \n", "-- | \n", "Donor Advisory | \n", "NaN | \n", "This donor advisory was published on Wednesday, January 5, 2011.In accordance with our.policy for removing Donor Advisories., Charity Navigator removed the Donor Advisory for Angel Flight Northeast on March 1, 2012 because the Donor Advisory had been in place for more than a year (since January 5, 2011) and because the issue that prompted the Donor Advisory has been resolved..Charity Navigator had published a Donor Advisory for this charity because we became aware of the following informati... | \n", "1 | \n", "0 | \n", "1 | \n", "False | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1 | \n", "Angel Flight Northeast | \n", "Health | \n", "North Andover | \n", "MA | \n", "Patient and Family Support | \n", "Providing free flights so children and adults can access medical care since 1996 | \n", "http://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=10166 | \n", "04-3314346 | \n", "NaN | \n", "NaN | \n", "-- | \n", "-- | \n", "NaN | \n", "Missing - Apparent Donor Advisory | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "left_only | \n", "1 | \n", "NaN | \n", "ANGEL FLIGHT OF NEW ENGLAND INC | \n", "LAWRENCE MUNICIPAL AIRPORT | \n", "NORTH ANDOVER | \n", "MA | \n", "01845-0000 | \n", "200812 | \n", "994179000 | \n", "201312 | \n", "869310 | \n", "896259 | \n", "3877845 | \n", "E99 | \n", "1 | \n", "199608 | \n", "ANGEL FLIGHT NEW ENG | \n", "MA | \n", "E | \n", "E87 | \n", "01867-1110 | \n", "25017 | \n", "200012 | \n", "539450 | \n", "520862 | \n", "318758 | \n", "199608 | \n", "1 | \n", "12 | \n", "1996 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "left_only | \n", "2008 | \n", "1996 | \n", "1996 | \n", "nan | \n", "8 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
21 | \n", "6466 | \n", "953667812 | \n", "http://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6466 | \n", "10,000 Degrees | \n", "Education | \n", "Education : Scholarship and Financial Support | \n", "2011-09-20 00:00:00 | \n", "2009-06 | \n", "2009-06-01 | \n", "FY2009 | \n", "2003-09-01 | \n", "CN 2.0 | \n", "85.33 | \n", "3 stars | \n", "NaN | \n", "NaN | \n", "0 | \n", "0 | \n", "0 | \n", "False | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1 | \n", "10,000 Degrees | \n", "Education | \n", "San Rafael | \n", "CA | \n", "Other Education Programs and Services | \n", "Creating College Graduates Who Change the World | \n", "http://www.charitynavigator.org/index.cfm?bay=search.summary&orgid=6466 | \n", "95-3667812 | \n", "06/2009 | \n", "55.33 | \n", "85.33 | \n", "85.33 | \n", "3 | \n", "3 stars | \n", "52.42 | \n", "59 | \n", "3 | \n", "3 | \n", "79.7 | \n", "7.3 | \n", "12.8 | \n", "0.11 | \n", "3.4 | \n", "0 | \n", "0.67 | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "yes | \n", "NO | \n", "yes | \n", "NO | \n", "NO | \n", "yes | \n", "3914222 | \n", "216503 | \n", "4130725 | \n", "Note: This organization receives $0 in government support. | \n", "2813532 | \n", "260007 | \n", "454629 | \n", "3528168 | \n", "0 | \n", "602557 | \n", "3389166 | \n", "154300 | \n", "4.37 | \n", "info@10000degrees.org | \n", "http://www.10000degrees.org | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "both | \n", "0 | \n", "NaN | \n", "10000 DEGREES | \n", "1650 LOS GAMOS SUITE 110 | \n", "SAN RAFAEL | \n", "CA | \n", "94903-1838 | \n", "198105 | \n", "40000000 | \n", "201506 | \n", "8611662 | \n", "7760209 | \n", "7627694 | \n", "B11 | \n", "1 | \n", "198211 | \n", "MARIN EDUC FND | \n", "CA | \n", "B | \n", "B20 | \n", "94901-2920 | \n", "06041 | \n", "200106 | \n", "3958011 | \n", "3958011 | \n", "1958251 | \n", "198211 | \n", "1 | \n", "06 | \n", "1982 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "left_only | \n", "1981 | \n", "1982 | \n", "1982 | \n", "nan | \n", "35 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "