FPDS Query Library
About Us
Contact Us

Is Nonprofit Organization

Boolean or coded flag indicating whether the vendor is identified as a nonprofit organization in the award record. It represents a vendor organization factor under vendor site details and is used to classify the supplier’s profit status.

Family: Award
Category: Vendor Site Details
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__vendor__vendorSiteDetails__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isNonprofitOrganization
Title
Is Nonprofit Organization
FPDS Path
award/vendor/vendorSiteDetails/vendorSiteDetails/vendorOrganizationFactors/profitStructure/isNonprofitOrganization
Description
Boolean or coded flag indicating whether the vendor is identified as a nonprofit organization in the award record. It represents a vendor organization factor under vendor site details and is used to classify the supplier’s profit status.
Business Meaning
This field helps analysts segment awards to nonprofit versus for-profit entities, which is important for spending mix analysis, supplier demographics, program targeting, and compliance or policy reviews. It can also support assessments of whether awards are flowing to mission-driven organizations in specific NAICS, place-of-performance, or assistance-adjacent contexts.
Example Value
Y

FPDS Compare

FPDS Query Variable
content__award__vendor__vendorSiteDetails__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isNonprofitOrganization
FPDS XML Path
award/vendor/vendorSiteDetails/vendorSiteDetails/vendorOrganizationFactors/profitStructure/isNonprofitOrganization
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/vendor/vendorSiteDetails/vendorSiteDetails/vendorOrganizationFactors/profitStructure/isNonprofitOrganization' into the SQL-ready variable 'content__award__vendor__vendorSiteDetails__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isNonprofitOrganization'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • Filter awards to nonprofit vendors
  • Compare obligation totals by vendor profit status
  • Profile award distributions across organization types

Common Mistakes

  • Assuming the flag is a legal determination of nonprofit status beyond the FPDS record
  • Treating null, blank, and explicit no values as equivalent without checking source encoding

Query Guidance

Use this field in WHERE clauses to isolate nonprofit vendors, e.g. `... WHERE isNonprofitOrganization = 'Y'`. If the table stores booleans or mixed codes, normalize the field first and test for both coded and descriptive variants before aggregating or joining.

SQL Examples

Preview values

SELECT
    content__award__vendor__vendorSiteDetails__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isNonprofitOrganization AS is_nonprofit_organization
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isNonprofitOrganization IS NOT NULL
LIMIT 25

Flag distribution

SELECT
    content__award__vendor__vendorSiteDetails__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isNonprofitOrganization AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorSiteDetails__vendorOrganizationFactors__profitStructure__isNonprofitOrganization IS NOT NULL
GROUP BY flag_value
ORDER BY record_count DESC

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.