Is Us Government Entity
Boolean or coded flag indicating whether the vendor site is classified as a U.S. government entity in the business or organization type hierarchy. In FPDS, this identifies the entity type associated with the vendor site record rather than the award itself.
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 out U.S. government entities from vendor universe analyses
- Segment awards by government versus non-government vendors
- Support compliance and transaction-type reviews
Common Mistakes
- Treating the flag as a dollar-weighted measure instead of a classification
- Assuming one value format without checking the dataset's observed codes
Query Guidance
Use the field as a WHERE-clause filter on the stored code, e.g. WHERE isUSGovernmentEntity = '1' or = 'Y' depending on the dataset's encoding. Validate the actual code set in the source extract, and join to related vendor-business-type fields if you need the human-readable category instead of the raw flag.
SQL Examples
Preview values
SELECT
content__IDV__vendor__vendorSiteDetails__vendorBusinessTypes__businessOrOrganizationType__isUSGovernmentEntity AS is_us_government_entity
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorBusinessTypes__businessOrOrganizationType__isUSGovernmentEntity IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__IDV__vendor__vendorSiteDetails__vendorBusinessTypes__businessOrOrganizationType__isUSGovernmentEntity AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__IDV__vendor__vendorSiteDetails__vendorBusinessTypes__businessOrOrganizationType__isUSGovernmentEntity 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.