Is Us Government Entity
Boolean or coded indicator showing whether the vendor business type is classified as a U.S. Government entity. It is part of the vendor business type details and typically identifies entities such as federal agencies or other government organizations rather than private-sector firms.
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
- Exclude U.S. government entities from commercial vendor analyses
- Identify intergovernmental or intra-government awards
- Segment spend by vendor ownership or entity type
Common Mistakes
- Assuming every 0 means a missing value rather than a valid negative flag
- Using the field alone to determine whether a vendor is public-sector without checking related vendor type fields
Query Guidance
Filter with the actual stored values observed in the table, for example WHERE isUSGovernmentEntity = 1 for government entities or = 0 for non-government entities. If the column is nullable or coded inconsistently, normalize values first and join or co-check related vendor classification fields before aggregating.
SQL Examples
Preview values
SELECT
content__award__vendor__vendorSiteDetails__vendorBusinessTypes__businessOrOrganizationType__isUSGovernmentEntity AS is_us_government_entity
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorBusinessTypes__businessOrOrganizationType__isUSGovernmentEntity IS NOT NULL
LIMIT 25
Flag distribution
SELECT
content__award__vendor__vendorSiteDetails__vendorBusinessTypes__businessOrOrganizationType__isUSGovernmentEntity AS flag_value,
count() AS record_count
FROM fpds.data
WHERE content__award__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.