FPDS Query Library
About Us
Contact Us

Street Address1

Street address line 1 for the primary consortia location associated with the other transaction award. It captures the first address line of the location record, such as a building number, street name, suite, or office designation when included on that line.

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__streetAddress1
Title
Street Address1
FPDS Path
OtherTransactionAward/contractDetail/consortiaInformation/primaryConsortiaLocation/streetAddress1
Description
Street address line 1 for the primary consortia location associated with the other transaction award. It captures the first address line of the location record, such as a building number, street name, suite, or office designation when included on that line.
Business Meaning
This field supports location-based analysis of consortia participants involved in other transaction awards, including geographic profiling, regional concentration, and due diligence on awardee locations. It can help analysts distinguish physical operating addresses from mailing or billing information when evaluating award structures and participant footprints.
Example Value
1510 CHESTER PIKE STE 380
Observed Non-Null Count
4,318

FPDS Compare

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

Use Cases

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

Common Usage

  • location-based grouping of consortia participants
  • address normalization and geocoding workflows
  • screening award records for geographic patterns

Common Mistakes

  • treating the value as a fully standardized postal address
  • assuming it uniquely identifies a physical site without checking other address lines

Query Guidance

Filter and group on the raw string only after normalizing case, punctuation, and whitespace. For address matching or deduplication, combine it with city, state, ZIP, and country fields; use LIKE or regex only for partial matching, not for authoritative location identification.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaLocation__streetAddress1 AS street_address1
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__consortiaInformation__primaryConsortiaLocation__streetAddress1 IS NOT NULL
LIMIT 25

Top values

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