Is Native American Owned Business
Boolean or coded indicator showing whether the vendor is identified in FPDS as a Native American owned business. It is a socioeconomic ownership flag stored under the vendor site details section of the award record.
FPDS Compare
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 involving Native American owned businesses
- Aggregate socioeconomic participation by vendor ownership type
- Support compliance and diversity reporting
Common Mistakes
- Assuming all non-1 values mean false without checking coding conventions
- Using this field as a vendor master attribute without accounting for award-level reporting context
Query Guidance
Use this field as a boolean filter or grouping column after normalizing its coding to a consistent true/false representation. In SQL, explicitly handle nulls and coded values, for example by mapping 1/Y/true to true and 0/N/false to false, then filter on the normalized flag for analysis.
SQL Examples
Preview values
SELECT
content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__minorityOwned__isNativeAmericanOwnedBusiness AS is_native_american_owned_business
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__minorityOwned__isNativeAmericanOwnedBusiness IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__minorityOwned__isNativeAmericanOwnedBusiness AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__minorityOwned__isNativeAmericanOwnedBusiness 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.