FPDS Query Library
About Us
Contact Us

Place of Performance ZIP Code

ZIP code reported for the location where contract performance occurs. In FPDS this is a location identifier, not a free-text address, and may reflect a 5-digit ZIP or extended ZIP+4-style value when available.

Family: Award
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__award__placeOfPerformance__placeOfPerformanceZIPCode
Title
Place of Performance ZIP Code
FPDS Path
award/placeOfPerformance/placeOfPerformanceZIPCode
Description
ZIP code reported for the location where contract performance occurs. In FPDS this is a location identifier, not a free-text address, and may reflect a 5-digit ZIP or extended ZIP+4-style value when available.
Business Meaning
This field supports geographic analysis of federal contract activity, including local economic impact, regional award concentration, and compliance with place-of-performance requirements. It is useful for mapping performance locations and comparing where work is actually performed versus where an award is issued.
Example Value
100071823
Observed Non-Null Count
90,108,359

FPDS Compare

FPDS Query Variable
content__award__placeOfPerformance__placeOfPerformanceZIPCode
FPDS XML Path
award/placeOfPerformance/placeOfPerformanceZIPCode
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/placeOfPerformance/placeOfPerformanceZIPCode' into the SQL-ready variable 'content__award__placeOfPerformance__placeOfPerformanceZIPCode'.

Use Cases

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

Common Usage

  • Geographic distribution of contract performance
  • ZIP-level aggregation of award activity
  • Linking to external county, state, or census reference data

Common Mistakes

  • Assuming the ZIP code represents the vendor location or contract office instead of the place of performance
  • Grouping without cleaning formatting differences such as ZIP+4, spaces, or punctuation

Query Guidance

Use this field for exact matches, prefix filters, and geographic joins after normalization. In SQL, apply consistent cleaning (for example, remove non-digits and standardize to 5 digits or ZIP+4 as needed) before grouping or joining to reference tables; do not use it as a proxy for state or city unless validated against a location crosswalk.

SQL Examples

Preview values

SELECT
    content__award__placeOfPerformance__placeOfPerformanceZIPCode AS place_of_performance_z_i_p_code
FROM fpds.data
WHERE content__award__placeOfPerformance__placeOfPerformanceZIPCode IS NOT NULL
LIMIT 25

Top values

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