Country of Incorporation
Country value recorded for the vendor's place of incorporation in the Other Transaction IDV vendor site details. It identifies the jurisdiction where the vendor was legally incorporated, typically stored as a short code or abbreviated country value such as "USA".
FPDS Compare
Use Cases
- Dictionary lookup and field explanation
- SQL filtering and grouping
- Analytical reporting and reusable query building
- Contractor profiling and competitor analysis
Common Usage
- Group vendors by incorporation country
- Filter foreign-incorporated entities
- Support domestic vs. international sourcing analysis
Common Mistakes
- Confusing incorporation country with headquarters or place of performance
- Assuming all values are full country names when they may be codes or abbreviations
Query Guidance
Use this field in WHERE clauses, GROUP BYs, and joins to a country reference table after normalizing codes and abbreviations. For analysis, classify USA separately from non-USA values and exclude null or unknown entries only after confirming they are truly missing rather than unmapped codes.
SQL Examples
Preview values
SELECT
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorOrganizationFactors__countryOfIncorporation AS country_of_incorporation
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorOrganizationFactors__countryOfIncorporation IS NOT NULL
LIMIT 25
Top values
SELECT
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorOrganizationFactors__countryOfIncorporation AS value,
count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorOrganizationFactors__countryOfIncorporation 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.