FPDS Query Library
About Us
Contact Us

Country

Country of the contracting office. This is the geographic country associated with the purchaser information record, and in FPDS it is typically a human-readable value for the contracting office location rather than a transaction outcome.

Family: IDV
Category: Purchaser Information
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__purchaserInformation__contractingOfficeID__country
Title
Country
FPDS Path
IDV/purchaserInformation/contractingOfficeID/country
Description
Country of the contracting office. This is the geographic country associated with the purchaser information record, and in FPDS it is typically a human-readable value for the contracting office location rather than a transaction outcome.
Business Meaning
This field helps analysts understand where procurement actions originate geographically, supporting office-level segmentation, jurisdictional analysis, and cross-border reporting. It is useful for identifying domestic versus overseas contracting activity and for grouping awards by contracting office location in portfolio reviews.
Example Value
USA
Observed Non-Null Count
4,494,536

FPDS Compare

FPDS Query Variable
content__IDV__purchaserInformation__contractingOfficeID__country
FPDS XML Path
IDV/purchaserInformation/contractingOfficeID/country
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/purchaserInformation/contractingOfficeID/country' into the SQL-ready variable 'content__IDV__purchaserInformation__contractingOfficeID__country'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building

Common Usage

  • Group awards by contracting office country
  • Filter for domestic versus overseas contracting activity
  • Join with office-location or geography dimensions for dashboarding

Common Mistakes

  • Using it as the vendor or place of performance country
  • Assuming all values follow one code standard without checking actual data

Query Guidance

Use this field in SELECT, GROUP BY, and WHERE clauses to segment records by contracting office country. Normalize values if needed, for example by mapping abbreviations such as 'USA' to a consistent country standard before aggregating.

SQL Examples

Preview values

SELECT
    content__IDV__purchaserInformation__contractingOfficeID__country AS country
FROM fpds.data
WHERE content__IDV__purchaserInformation__contractingOfficeID__country IS NOT NULL
LIMIT 25

Top values

SELECT
    content__IDV__purchaserInformation__contractingOfficeID__country AS value,
    count() AS record_count
FROM fpds.data
WHERE content__IDV__purchaserInformation__contractingOfficeID__country IS NOT NULL
GROUP BY value
ORDER BY record_count DESC
LIMIT 25

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.