Is Women Owned
Boolean or coded indicator showing whether the vendor is identified as women-owned in the transaction record. In FPDS Query, this field reflects a vendor socio-economic classification associated with the award's vendor site details.
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 to women-owned vendors
- Calculate obligated dollars to women-owned firms
- Support socio-economic procurement dashboards and compliance reports
Common Mistakes
- Assuming the field indicates certified status rather than reported ownership
- Counting nulls as non-women-owned without validating source completeness
Query Guidance
Use this field in WHERE clauses to isolate women-owned vendors, e.g. WHERE isWomenOwned = 1 or the dataset's equivalent affirmative code. When calculating shares, join or aggregate at the award or vendor level as appropriate, and exclude or separately track nulls to avoid understating missing data.
SQL Examples
Preview values
SELECT
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwned AS is_women_owned
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwned IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwned AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwned 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.