FPDS Query Library
About Us
Contact Us

State Code

Two-character state or territory code for the principal place where the work is performed under the Other Transaction IDV. It identifies the geographic location recorded in the award at the state level, using a coded value such as SC.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__placeOfPerformance__principalPlaceOfPerformance__stateCode
Title
State Code
FPDS Path
OtherTransactionIDV/contractDetail/placeOfPerformance/principalPlaceOfPerformance/stateCode
Description
Two-character state or territory code for the principal place where the work is performed under the Other Transaction IDV. It identifies the geographic location recorded in the award at the state level, using a coded value such as SC.
Business Meaning
This field supports geographic analysis of federal procurement and other transactions by showing where contract work is expected to occur. Analysts use it to study regional award distribution, local economic impact, concentration of spending, and mission footprint across states.
Example Value
SC
Observed Non-Null Count
13,126

FPDS Compare

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

Use Cases

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

Common Usage

  • State-level spend and award counts
  • Geographic mapping of performance locations
  • Filtering awards by principal place of performance

Common Mistakes

  • Confusing place of performance with the contractor's address or awardee location
  • Assuming the code is a full state name rather than an abbreviation or other coded value

Query Guidance

Use the field as a grouping and filter key, for example in WHERE and GROUP BY clauses. Join or compare it to a reference table of valid state codes when standardizing values, and check for nulls or uncommon codes before producing state-level metrics.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__placeOfPerformance__principalPlaceOfPerformance__stateCode AS state_code
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__placeOfPerformance__principalPlaceOfPerformance__stateCode IS NOT NULL
LIMIT 25

Top values

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