Is Us Government Entity
Boolean or coded flag indicating whether the vendor entity associated with the vendor site is a U.S. government entity. It captures the government-entity status at the vendor business-type level for the record.
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 to isolate transactions involving government vendors
- Segment vendor population by public-sector versus non-public-sector entities
- Support compliance and exclusion checks in supplier analysis
Common Mistakes
- Assuming a value of 0 always means a private commercial firm without checking coding conventions
- Using the flag alone to classify a vendor without reviewing related entity-type fields or descriptions
Query Guidance
Use this field in WHERE clauses to filter on the encoded government-entity value after confirming the dataset's stored coding convention. For example, compare against the observed true/false code in the data, and join to vendor descriptor fields when building summary counts or exclusion logic.
SQL Examples
Preview values
SELECT
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__businessOrOrganizationType__isUSGovernmentEntity AS is_us_government_entity
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__businessOrOrganizationType__isUSGovernmentEntity IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__businessOrOrganizationType__isUSGovernmentEntity AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__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.