FPDS Query Library
About Us
Contact Us

Is Federal Government Agency

Boolean or coded flag indicating whether the vendor site is associated with a federal government agency. A value such as 1/true typically means the site is identified as a federal government agency; 0/false means it is not.

Family: Other Transaction IDV
Category: Vendor Site Details
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__federalGovernment__isFederalGovernmentAgency
Title
Is Federal Government Agency
FPDS Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/vendorBusinessTypes/federalGovernment/isFederalGovernmentAgency
Description
Boolean or coded flag indicating whether the vendor site is associated with a federal government agency. A value such as 1/true typically means the site is identified as a federal government agency; 0/false means it is not.
Business Meaning
This field helps analysts identify awards or vendor records that involve federal government entities rather than commercial or non-federal organizations. It is useful for supplier classification, competitive landscape analysis, interagency transaction review, and compliance checks where government-to-government relationships may need to be separated from private-sector vendor activity.
Example Value
0
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__federalGovernment__isFederalGovernmentAgency
FPDS XML Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/vendorBusinessTypes/federalGovernment/isFederalGovernmentAgency
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/vendorBusinessTypes/federalGovernment/isFederalGovernmentAgency' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__federalGovernment__isFederalGovernmentAgency'.

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 federal agencies from commercial vendor counts
  • Segment awards by government versus non-government vendors
  • Support compliance or interagency transaction analysis

Common Mistakes

  • Assuming the flag identifies the parent vendor rather than the specific vendor site
  • Treating null, blank, and false as equivalent without checking data quality rules

Query Guidance

Filter on the stored truthy value for agency records and explicitly handle nulls. Example pattern: WHERE isFederalGovernmentAgency IN ('1', 1, 'Y', TRUE) or compare to the known code set from the source extract; if you need non-agency records, use the complementary false set and exclude nulls separately when precision matters.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__federalGovernment__isFederalGovernmentAgency AS is_federal_government_agency
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__federalGovernment__isFederalGovernmentAgency IS NOT NULL
LIMIT 25

Flag distribution

SELECT
    content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__federalGovernment__isFederalGovernmentAgency AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorBusinessTypes__federalGovernment__isFederalGovernmentAgency 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.