FPDS Query Library
About Us
Contact Us

State

State is the vendor location state recorded in the Vendor Site Details section of an Other Transaction Award. It identifies the U.S. state or analogous jurisdiction associated with the vendor site address, typically using a short code such as VA.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorLocation__state
Title
State
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorLocation/state
Description
State is the vendor location state recorded in the Vendor Site Details section of an Other Transaction Award. It identifies the U.S. state or analogous jurisdiction associated with the vendor site address, typically using a short code such as VA.
Business Meaning
This field supports geographic analysis of vendor presence, award distribution, and sourcing patterns. Analysts use it to evaluate regional contracting activity, supplier concentration, and state-level participation in federal procurement and other transaction awards.
Example Value
VA
Observed Non-Null Count
38,730

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorLocation__state
FPDS XML Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorLocation/state
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorLocation/state' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorLocation__state'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • State-level award counts and obligation totals
  • Vendor geography and market concentration analysis
  • Filtering awards by vendor site location

Common Mistakes

  • Assuming the value always represents the contractor's principal place of business
  • Grouping without normalizing abbreviations, blanks, and non-U.S. location values

Query Guidance

Use this field in WHERE clauses and GROUP BY operations for geographic segmentation, and normalize the code set before aggregation if the data contains mixed formatting. When joining to reference data or building dashboards, preserve the raw state value and compare it with other location fields to avoid misclassification.

SQL Examples

Preview values

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

Top values

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