grantmakers / profiles

Grantmakers.io Profiles - Summary profiles for all US-based foundations who have filed electronic IRS Form 990-PF
MIT License
1 stars 1 forks source link

Improve how "null" grants appear in profiles #95

Closed chadokruse closed 4 years ago

chadokruse commented 4 years ago

In limited circumstances, profile templates might show null in grant lists.

Showing null is a bug. Presenting the error in an alternative way is an enhancement.

Early analysis suggests it affects ~5k profiles. All of these appear to have errors in how grants are listed (e.g. they provide a grant amount of zero but no other information).

On the one hand, our stated mission is to help foundations improve their filings by presenting the data exactly as it appears in the dataset.

On the other hand, the error occurs in a decent number of profiles.

Example: https://s3.amazonaws.com/irs-form-990/201633149349101018_public.xml

Basic query

db.getCollection('grants').find({
    'grant_amount': 0,
    'grantee_name': null,
    //'grant_purpose': null,
    //'grantee_city': null,
}).count()