Is Native American Owned Business
Boolean or coded indicator showing whether the vendor is identified as a Native American owned business at the vendor site level in the award record. A value such as 0 typically means the condition is not met, while other observed values should be checked against the dataset’s code conventions and any paired description fields.
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 or vendors associated with Native American owned businesses
- Compute share of obligations or count of awards by ownership category
- Support diversity, equity, and socioeconomic reporting
Common Mistakes
- Assuming 0 always means false without verifying the code set in the extract
- Using this field as proof of current certification status rather than a record-level indicator
Query Guidance
Use explicit value checks in SQL, for example `WHERE field = 1` or `WHERE field IN ('Y','1')` after confirming the dataset’s actual encoding. When comparing across records, normalize the field to a consistent boolean interpretation and join to any companion description field only for validation or display.
SQL Examples
Preview values
SELECT
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__minorityOwned__isNativeAmericanOwnedBusiness AS is_native_american_owned_business
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__minorityOwned__isNativeAmericanOwnedBusiness IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__minorityOwned__isNativeAmericanOwnedBusiness AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__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.