FPDS Query Library
About Us
Contact Us

Region Code

Code identifying the geographic region associated with the contracting office that issued or administers the IDV. It is a coded location attribute, not a narrative description, and should be read as a reference key tied to an FPDS region classification.

Family: IDV
Category: Purchaser Information
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__purchaserInformation__contractingOfficeID__regionCode
Title
Region Code
FPDS Path
IDV/purchaserInformation/contractingOfficeID/regionCode
Description
Code identifying the geographic region associated with the contracting office that issued or administers the IDV. It is a coded location attribute, not a narrative description, and should be read as a reference key tied to an FPDS region classification.
Business Meaning
This field helps analysts group obligations and awards by contracting office geography, supporting oversight of regional acquisition activity, workload distribution, and spatial comparisons across offices. It is useful for identifying where contracting activity is concentrated and for comparing regional procurement patterns, performance, or compliance.
Example Value
36
Observed Non-Null Count
2,068,507

FPDS Compare

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

Use Cases

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

Common Usage

  • Regional rollups of IDV activity by contracting office
  • Filtering awards or IDs to a specific FPDS region
  • Joining to geography or office reference data for reporting

Common Mistakes

  • Assuming the code is the office location itself rather than the office's region classification
  • Grouping on the raw code without confirming the valid lookup set or data type

Query Guidance

Use this field in WHERE, GROUP BY, and JOIN clauses when segmenting data by contracting office region. Compare it to the canonical code values from the reference data table, and cast carefully if your database stores the code as text but your source has numeric-looking values.

SQL Examples

Preview values

SELECT
    content__IDV__purchaserInformation__contractingOfficeID__regionCode AS region_code
FROM fpds.data
WHERE content__IDV__purchaserInformation__contractingOfficeID__regionCode IS NOT NULL
LIMIT 25

Top values

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