FPDS Query Library
About Us
Contact Us

Href

A URL string that points to the FPDS award information page for the record. It functions as a navigational link rather than a procurement attribute and is stored in the Links section of the XML.

Family: General
Category: Links
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
link__href
Title
Href
FPDS Path
link/href
Description
A URL string that points to the FPDS award information page for the record. It functions as a navigational link rather than a procurement attribute and is stored in the Links section of the XML.
Business Meaning
This field lets analysts jump from a query result to the underlying award record for validation, review, and audit support. It is useful for building repeatable workflows that connect extracted data back to the source FPDS entry.
Example Value
https://www.fpds.gov/ezsearch/search.do?s=FPDS&indexName=awardfull&templateName=1.5.3&q=DEAC2289PC88400+8900+
Observed Non-Null Count
117,423,893

FPDS Compare

FPDS Query Variable
link__href
FPDS XML Path
link/href
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'link/href' into the SQL-ready variable 'link__href'.

Use Cases

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

Common Usage

  • Open the source award record from a search result
  • Preserve a clickable reference in exported datasets
  • Support record-level QA and audit tracing

Common Mistakes

  • Using it as a procurement outcome variable
  • Grouping or counting by the URL instead of the award identifier

Query Guidance

Select it as a reference field and filter only when you need specific record URLs or source links. Because it is a string attribute, compare it exactly and avoid numeric operations; for analytics, pair it with the award identifier or other business keys.

SQL Examples

Preview values

SELECT
    link__href AS href
FROM fpds.data
WHERE link__href IS NOT NULL
LIMIT 25

Top values

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