FPDS Query Library
About Us
Contact Us

Agency Id

Agency identifier recorded in the contract award ID structure. It is the code used by FPDS to identify the contracting agency or component associated with the award record.

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

Variable Overview

FPDS Query Variable
content__award__awardID__awardContractID__agencyID
Title
Agency Id
FPDS Path
award/awardID/awardContractID/agencyID
Description
Agency identifier recorded in the contract award ID structure. It is the code used by FPDS to identify the contracting agency or component associated with the award record.
Business Meaning
This field lets analysts group, filter, and attribute obligations and awards to the responsible agency organization. It is essential for agency-level spend reporting, trend analysis, and linking awards to organizational hierarchies or reference tables.
Example Value
8900
Observed Non-Null Count
111,509,025

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards for a specific agency or component
  • Aggregate obligation dollars by agency
  • Join to a lookup table for agency names or hierarchy

Common Mistakes

  • Assuming the code is the same as a textual agency name
  • Comparing agency IDs across periods without accounting for reorganizations or reference updates

Query Guidance

Use in WHERE clauses for agency scoping and in JOINs to agency reference tables. If analyzing trends, group by the code only after confirming consistent mapping across the date range; when possible, pair it with the human-readable agency name field or a reference dimension to avoid misclassification.

SQL Examples

Preview values

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

Top values

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