NonprofitFilters

input

Fields

Filter by EIN

org501c3·Boolean

Only include 501(c)(3) orgs (IRS subsection_code = '03')

excludeSubsidiaries·Boolean

Exclude subsidiary orgs (i.e., nonprofits present in t_nonprofit_consolidated.nonprofit_id)

updatedAt·DateFilters

Filter by date

bmfStatus·BmfFilter= {in: [GREEN, YELLOW]}

Filter by BMF status

excludeBlocked·Boolean

Exclude orgs which are blocked from an Encompass rating (i.e. nonprofits present in t_temp_encompass_block)

excludeActiveAlertLevels·ActiveAlertLevelsExcludeFilter

Exclude orgs with an active alert whose level is in in