FPDS Query Library
About Us
Contact Us

Country of Origin Name

Human-readable name of the country recorded as the product's country of origin in the award record. It is the label version of a coded country value, typically used to display the origin country without requiring code translation.

Family: Award
Category: Product Or Service Information
Data Type: string
Semantic Type: label
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__productOrServiceInformation__countryOfOrigin__name
Title
Country of Origin Name
FPDS Path
award/productOrServiceInformation/countryOfOrigin/name
Description
Human-readable name of the country recorded as the product's country of origin in the award record. It is the label version of a coded country value, typically used to display the origin country without requiring code translation.
Business Meaning
This field helps analysts assess where awarded products originate, which can inform supply chain analysis, trade compliance reviews, sourcing patterns, and domestic-vs-foreign procurement assessments. It is also useful for identifying dependencies on specific countries in award activity.
Example Value
UNITED STATES
Observed Non-Null Count
96,854,445

FPDS Compare

FPDS Query Variable
content__award__productOrServiceInformation__countryOfOrigin__name
FPDS XML Path
award/productOrServiceInformation/countryOfOrigin/name
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/productOrServiceInformation/countryOfOrigin/name' into the SQL-ready variable 'content__award__productOrServiceInformation__countryOfOrigin__name'.

Use Cases

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

Common Usage

  • Count awards by country of origin
  • Compare domestic versus foreign sourcing
  • Flag procurements tied to specific countries

Common Mistakes

  • Assuming the text value is a stable code
  • Grouping without normalizing spelling or variant labels

Query Guidance

Use for display, grouping, and filtering on country labels after normalizing values with UPPER/TRIM or a mapping table. If a coded companion field exists, join or map on the code for analysis and use this field only as the human-readable output.

SQL Examples

Preview values

SELECT
    content__award__productOrServiceInformation__countryOfOrigin__name AS country_of_origin_name
FROM fpds.data
WHERE content__award__productOrServiceInformation__countryOfOrigin__name IS NOT NULL
LIMIT 25

Top values

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