Is Women Owned Small Business
Boolean or coded indicator showing whether the vendor was reported as a women-owned small business on the award record. It is a vendor socioeconomic status flag captured at the vendor site level, not a narrative description.
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 obligations to women-owned small businesses
- Segment spend by socioeconomic category
- Compare award patterns across vendor categories
Common Mistakes
- Assuming the flag confirms third-party certification rather than reported status
- Using the field without checking whether the dataset stores booleans, numeric codes, or text equivalents
Query Guidance
Filter on the positive code or true value only after verifying the local encoding. In SQL, use an explicit condition such as WHERE isWomenOwnedSmallBusiness IN ('1', 1, 'Y', 'TRUE') or the dataset's documented equivalent, and aggregate with CASE expressions for consistent counts and spend summaries.
SQL Examples
Preview values
SELECT
content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwnedSmallBusiness AS is_women_owned_small_business
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwnedSmallBusiness IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwnedSmallBusiness AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwnedSmallBusiness 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.