FPDS Query Library
About Us
Contact Us

Agency Id

Agency-specific identifier used on the award record to identify the agency value associated with the award element. It is a coded key rather than a free-text description, so the actual meaning depends on the agency’s coding scheme or related reference data.

Family: Award
Category: General
Data Type: identifier_or_code
Semantic Type: identifier
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__agencySpecificAwardElements__agencyID
Title
Agency Id
FPDS Path
award/agencySpecificAwardElements/agencyID
Description
Agency-specific identifier used on the award record to identify the agency value associated with the award element. It is a coded key rather than a free-text description, so the actual meaning depends on the agency’s coding scheme or related reference data.
Business Meaning
This field supports agency-level tracking, filtering, and grouping of awards in FPDS-based analysis. Analysts use it to distinguish awards by agency-specific reporting conventions and to align records with agency reference tables, organizational hierarchies, or internal data extracts.
Example Value
8000
Observed Non-Null Count
1,081,116

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards to a specific agency-coded subset
  • Join to agency reference or lookup tables
  • Group awards by agency-specific reporting key

Common Mistakes

  • Interpreting the code as a descriptive agency name
  • Assuming the code has the same meaning across all agencies

Query Guidance

Use this field as a join key or WHERE filter for agency-specific award records, e.g. WHERE content__award__agencySpecificAwardElements__agencyID = '8000'. If you need a readable label, join to the relevant lookup or description field rather than selecting this code alone.

SQL Examples

Preview values

SELECT
    content__award__agencySpecificAwardElements__agencyID AS agency_id
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__agencyID IS NOT NULL
LIMIT 25

Top values

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