FPDS Query Library
About Us
Contact Us

Country of Origin

Identifies the country associated with the awarded product or service in the Product or Service Information section of the record. The value is typically a country name or abbreviation such as 'USA' and may reflect origin as captured in FPDS rather than a separately normalized trade or compliance classification.

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

Variable Overview

FPDS Query Variable
content__award__productOrServiceInformation__countryOfOrigin
Title
Country of Origin
FPDS Path
award/productOrServiceInformation/countryOfOrigin
Description
Identifies the country associated with the awarded product or service in the Product or Service Information section of the record. The value is typically a country name or abbreviation such as 'USA' and may reflect origin as captured in FPDS rather than a separately normalized trade or compliance classification.
Business Meaning
This field supports supply-chain, domestic sourcing, trade compliance, and geographic sourcing analysis. Analysts use it to assess whether awarded items are domestically or foreign sourced, to segment awards by origin, and to support reporting on supply risk, industrial base dependence, and acquisition policy outcomes.
Example Value
USA
Observed Non-Null Count
96,901,897

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards by domestic versus foreign origin
  • Group obligations by country or region of origin
  • Support sourcing and supply-chain risk analysis

Common Mistakes

  • Confusing country of origin with contractor address or place of performance
  • Assuming all values use the same standard coding or naming convention

Query Guidance

Use this field in WHERE, GROUP BY, and CASE logic after normalizing observed values to a controlled country set. For example, map variants like 'USA', 'United States', and 'US' to one canonical value before aggregating, and avoid using it alone as proof of statutory domestic-content status.

SQL Examples

Preview values

SELECT
    content__award__productOrServiceInformation__countryOfOrigin AS country_of_origin
FROM fpds.data
WHERE content__award__productOrServiceInformation__countryOfOrigin IS NOT NULL
LIMIT 25

Top values

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