FPDS Query Library
About Us
Contact Us

Country Code Name

Human-readable country name for the principal place of performance associated with the Other Transaction IDV record. This is the label counterpart to the country code in the place-of-performance structure, not the coded value itself.

Family: Other Transaction IDV
Category: Place Of Performance
Data Type: string
Semantic Type: label
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__placeOfPerformance__principalPlaceOfPerformance__countryCode__name
Title
Country Code Name
FPDS Path
OtherTransactionIDV/contractDetail/placeOfPerformance/principalPlaceOfPerformance/countryCode/name
Description
Human-readable country name for the principal place of performance associated with the Other Transaction IDV record. This is the label counterpart to the country code in the place-of-performance structure, not the coded value itself.
Business Meaning
This field helps analysts identify where work is expected to occur and supports geographic reporting, domestic versus overseas performance analysis, and contractor footprint assessments. It is useful for aggregating obligations and comparing performance locations across awards.
Example Value
UNITED STATES
Observed Non-Null Count
13,413

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__placeOfPerformance__principalPlaceOfPerformance__countryCode__name
FPDS XML Path
OtherTransactionIDV/contractDetail/placeOfPerformance/principalPlaceOfPerformance/countryCode/name
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/placeOfPerformance/principalPlaceOfPerformance/countryCode/name' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__placeOfPerformance__principalPlaceOfPerformance__countryCode__name'.

Use Cases

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

Common Usage

  • Geographic distribution of principal performance locations
  • Domestic vs. foreign performance analysis
  • Normalization of place-of-performance country labels

Common Mistakes

  • Using the country name as a join key instead of the code
  • Assuming the label is standardized across all records or time periods

Query Guidance

Use this field for display, grouping, or validation of the country code, but filter and join on the corresponding country code when possible. In SQL, normalize case and trim whitespace if comparing labels, and handle null or blank values explicitly.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__placeOfPerformance__principalPlaceOfPerformance__countryCode__name AS country_code_name
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__placeOfPerformance__principalPlaceOfPerformance__countryCode__name IS NOT NULL
LIMIT 25

Top values

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