Is Native American Owned Business
Boolean or coded indicator showing whether the vendor is identified in FPDS as a Native American owned business within the vendor's socio-economic indicators. A value such as 0 typically means the condition is not met, while nonzero/true values indicate that it is met, depending on how the extract encodes flags.
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
- count awards or vendors identified as Native American owned
- segment obligation totals by socio-economic ownership status
- filter procurement records for diversity and compliance reporting
Common Mistakes
- assuming the flag is validated legal proof of ownership
- treating null, 0, and false as equivalent without checking the dataset encoding
Query Guidance
In SQL, filter on the affirmative representation used in your dataset, for example `= 1`, `= 'Y'`, or `= TRUE`, after confirming the actual encoding from sample values. Use `COALESCE` only when you intentionally want to treat null as not indicated, and pair this field with other socio-economic indicators when building summary counts.
SQL Examples
Preview values
SELECT
content__IDV__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__minorityOwned__isNativeAmericanOwnedBusiness AS is_native_american_owned_business
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__minorityOwned__isNativeAmericanOwnedBusiness IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__IDV__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__minorityOwned__isNativeAmericanOwnedBusiness AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__IDV__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.