FPDS Query Library
About Us
Contact Us

ZIP Code

Postal ZIP code for the primary consortia member's location recorded in the Other Transaction IDV award. It is a location identifier, not a narrative address, and may appear in 5-digit or ZIP+4 format.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__consortiaInformation__primaryConsortiaLocation__ZIPCode
Title
ZIP Code
FPDS Path
OtherTransactionIDV/contractDetail/consortiaInformation/primaryConsortiaLocation/ZIPCode
Description
Postal ZIP code for the primary consortia member's location recorded in the Other Transaction IDV award. It is a location identifier, not a narrative address, and may appear in 5-digit or ZIP+4 format.
Business Meaning
This field supports geographic analysis of consortium members involved in Other Transaction IDVs, including regional concentration, market footprint, and location-based matching to socioeconomic or demographic data. It can also help identify where the primary member is based for vendor-network and footprint analysis.
Example Value
46725-8861
Observed Non-Null Count
294

FPDS Compare

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

Use Cases

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

Common Usage

  • Geographic distribution of primary consortia members
  • ZIP-to-state or ZIP-to-region rollups
  • Linking award records to external geographic reference files

Common Mistakes

  • Casting the value to numeric and losing leading zeros or ZIP+4 formatting
  • Using ZIP code as a substitute for full address or exact facility location

Query Guidance

Store and filter this field as a string. Use LEFT, SUBSTRING, or ZIP crosswalk tables for aggregation, and normalize to 5-digit ZIP when comparing across datasets if ZIP+4 values are present.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__consortiaInformation__primaryConsortiaLocation__ZIPCode AS z_i_p_code
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__consortiaInformation__primaryConsortiaLocation__ZIPCode IS NOT NULL
LIMIT 25

Top values

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