FPDS Query Library
About Us
Contact Us

State

State of the primary consortia location associated with the Other Transaction Award. This is a geographic attribute for the consortium's main location, represented as a string and typically using a U.S. state or territory abbreviation such as "NY".

Family: Other Transaction Award
Category: General
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaLocation__state
Title
State
FPDS Path
OtherTransactionAward/contractDetail/consortiaInformation/primaryConsortiaLocation/state
Description
State of the primary consortia location associated with the Other Transaction Award. This is a geographic attribute for the consortium's main location, represented as a string and typically using a U.S. state or territory abbreviation such as "NY".
Business Meaning
This field supports geographic analysis of consortia participating in Other Transaction Awards, including concentration by state, regional sourcing patterns, and location-based reporting. It helps analysts understand where awarded consortia are based and whether activity is distributed across particular jurisdictions.
Example Value
NY
Observed Non-Null Count
4,310

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaLocation__state
FPDS XML Path
OtherTransactionAward/contractDetail/consortiaInformation/primaryConsortiaLocation/state
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/consortiaInformation/primaryConsortiaLocation/state' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaLocation__state'.

Use Cases

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

Common Usage

  • State-level aggregation of consortium locations
  • Geographic filtering for regional procurement analysis
  • Joining to a state reference table for normalization

Common Mistakes

  • Using it as a substitute for place of performance
  • Assuming it always contains full state names instead of abbreviations

Query Guidance

Use this field in WHERE clauses, GROUP BY, and joins to geographic dimension tables after normalizing case and code format. When analyzing location patterns, pair it with city, ZIP, or country fields to confirm interpretation and avoid mixing state-level location with performance geography.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaLocation__state AS state
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaLocation__state IS NOT NULL
LIMIT 25

Top values

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