Is Women Owned
Boolean or coded indicator showing whether the vendor at the IDV site is identified as women-owned. In FPDS, this is a socioeconomic status flag stored under vendor site details and may appear as a numeric code such as 0/1 rather than a textual yes/no value.
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
- Identify women-owned vendors in an IDV population
- Calculate obligations or counts by socioeconomic status
- Support compliance and diversity reporting
Common Mistakes
- Assuming 0 always means no and 1 always means yes without checking the dataset's coded values
- Using this field as a proxy for vendor-wide status when it is site-level data
Query Guidance
Filter on the observed true value after confirming the code set, and use explicit null handling for unknown or missing records. Example pattern: WHERE isWomenOwned = 1; if the field is stored as text or has multiple coded states, inspect distinct values first and map them before analysis.
SQL Examples
Preview values
SELECT
content__IDV__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwned AS is_women_owned
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwned IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__IDV__vendor__vendorSiteDetails__vendorSocioEconomicIndicators__isWomenOwned AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__IDV__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.