Source catalog
FPDS Contract Actions and Awards
Federal contract award and modification records.
Source, grain and coverage
FPDS Contract Actions and Awards ↗
Reported contract actions from the FPDS feed. One award can have multiple actions and modifications.
Mixed source schemas and repeated observations are normalized into separate contract-action and latest-award projections. Native transaction/award identifiers take precedence; qualified fallback keys can retain unresolved variants. Missing source identities preserve separate observations. Obligation fields omitted by earlier producers remain unknown, and award ceilings are not additive action spending.
Collection schedule: Daily.
Records describe public source observations. Missing values remain unknown; historical observations do not establish current status.
Definitions audited . Use source status and the returned watermarks to inspect current collection health.
REST and MCP access
Use a credential with search scope and enable that data domain in your workspace.
curl 'https://www.govbiz.ai/api/v2/catalogue/sources/fpds-incremental/records?limit=2' \ -H "Authorization: Bearer $GOVBIZ_API_KEY"
The primary dataset is contract_actions. Select another dataset from this source with dataset_id. Supported field names can be used as exact filters; the versioned query endpoint also supports declared ranges and list operators.
Through canonical /mcp, use govbiz_discover_datasets, govbiz_describe_dataset, govbiz_search_records, and govbiz_get_evidence. Cross-source relationships use govbiz_get_related_records and require access to every involved domain.
API contracts · MCP setup · Workspace data domains
Query this source →Contract Actions
contract_actions · Schema 1
One normalized retained contract-action identity per action_key across base-award and modification files. Native keys take precedence; ambiguous fallback variants and unqualified observations can remain.
Search modes: structured, lexical. History: Current retained projection; exact historical reconstruction is unsupported.
Measures: record_count, sum:federal_action_obligation. Monetary values use decimal strings with declared units. Unknown amounts do not become zero.
Field definitions and supported filters · 48 fields
| Field | Type / unit | Meaning | Availability and filters |
|---|---|---|---|
_ingested_at | string | Incremental FPDS processing timestamp text.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
action_date | date | Reported award action date; USAspending summary mapping currently uses Start Date instead.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
action_date_fiscal_year | string | Publisher federal fiscal year of the action in older FPDS files.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
award_id_piid | string | Procurement Instrument Identifier of a contract/order; source award identity includes issuer/parent context.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
award_type | string | Source instrument category label; decode within the source export version.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
award_type_code | string | Source instrument category code; code sets differ across FPDS/USAspending contexts.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
awarding_agency_code | string | Reported awarding agency code identifier; keep its source namespace and buying-versus-funding role.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
awarding_agency_name | string | Reported awarding agency name label; resolve identifiers separately.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
awarding_sub_agency_code | string | Reported awarding sub agency code identifier; keep its source namespace and buying-versus-funding role.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
base_and_exercised_options_value | decimal / USD | Reported base/exercised-options contractual value on this action; distinguish action change from cumulative source total. Not an action obligation or an all-options ceiling.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
cage_code | string | Commercial and Government Entity code; a separate entity/site identifier namespace.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ.CAGE/NCAGE is ordinarily a 5-character code; wider storage is not a source format guarantee. | Values can be missingeq, in, is_null, contains |
consolidated_contract | string | Reported consolidated-contract indicator, often represented as source text.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
contract_award_unique_key | string | USAspending source key identifying a prime contract award across its transactions.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
contract_transaction_unique_key | string | USAspending source key identifying a contract transaction/action when present.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
current_total_value_of_award | decimal / USD | Current reported contract amount including base and exercised options; distinct from potential all-options value and action obligation. Select once at award/as-of grain, not SUM across modifications.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
extent_competed | string | Source competition-method label.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
extent_competed_code | string | Source competition-method code; preserve the code and source dictionary version.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
federal_action_obligation | decimal / USD | Signed action-level obligation/deobligation delta; missing is not zero.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
funding_agency_code | string | Reported funding agency code identifier; keep its source namespace and buying-versus-funding role.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
labor_standards | string | Reported labor-standards applicability indicator; verify actual referenced provisions.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
last_modified_date | date | Publisher-reported record update date in older FPDS files.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
modification_number | string | Source action/modification label; P/A prefixes do not determine modification reason or a performance extension.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
multi_year_contract | string | Reported multi-year contract indicator; not the same as a contract having options.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
naics_code | string | Source industry classification code; link with the NAICS edition and declared precision.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ.Require a classification edition; do not join broad prefixes as exact identities. | Values can be missingeq, in, is_null, contains |
naics_description | string | Industry classification description; it is not an award requirement narrative.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
number_of_offers_received | string | Reported count of offers received; one offer alone does not prove a sole-source procurement.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
parent_award_id_piid | string | Referenced parent IDV/award PIID; not the child task order identity.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
period_of_performance_current_end_date | date | Current award completion date excluding unexercised options.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
period_of_performance_potential_end_date | date | Potential award completion date including possible options; not the current completion date.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
period_of_performance_start_date | date | Reported award performance start date.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
primary_place_of_performance_state_code | string | Source state/territory code of the place of performance; distinct from recipient legal address.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
primary_place_of_performance_zip_4 | string | Source ZIP+4 of the place of performance; distinct from recipient legal address.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
product_or_service_code | string | Source FPDS/USAspending product/service classification.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
recipient_name | string | Reported award recipient label; not a unique entity identifier.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
recipient_state_code | string | Reported recipient address state code; not the contract place of performance.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
recipient_uei | string | Source UEI identifying the recipient participant; missing/empty values cannot support an exact entity join.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ.Logical UEI length is 12; a wider varchar is not broader identity support. | Values can be missingeq, in, is_null, contains |
solicitation_identifier | string | FPDS source solicitation reference for linking a reported action to a notice.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
solicitation_procedures | string | Reported solicitation procedure label/code.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
total_dollars_obligated | decimal / USD | Cumulative award obligations at a reported snapshot; do not sum across modifications.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
transaction_description | string | Reported transaction description retained by incremental exports.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
type_of_contract_pricing_code | string | Source contract pricing arrangement code; not a bid or rate recommendation.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
type_of_set_aside | string | FPDS/USAspending set-aside label.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
type_of_set_aside_code | string | FPDS/USAspending set-aside code.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
agency_code | string | Source awarding-agency identifier; source namespace must be preserved.Storage and value limits: Bounded by the public query contract. | Values can be missingeq, in, is_null |
action_key | string | Generated SHA-256 of a retained native transaction key when available, otherwise a qualified issuer/parent/PIID/modification reference. Unresolved variants can retain additional observations.Storage and value limits: Bounded by the public query contract. | Values can be missingeq, in, is_null |
award_key | string | Generated SHA-256 of a retained native award key when available, otherwise a qualified issuer/parent/PIID reference. Unresolved variants can retain additional observations.Storage and value limits: Bounded by the public query contract. | Values can be missingeq, in, is_null |
fiscal_year | integer | Collector partition fiscal year; distinct from a calendar year.Storage and value limits: Bounded by the public query contract. | Values can be missingeq, in, is_null, gte, lte |
action_month | string | Calendar YYYY-MM of the reported action date; not a federal fiscal-year label.Storage and value limits: YYYY-MM when a source action date is usable.Unknown action dates remain unknown. | Values can be missingeq, in, is_null |
Contract Awards
contract_awards · Schema 1
One retained award state per award_key, selected from the latest dated corrected contract action. Award amounts are not sums across actions, and unresolved fallback variants can remain.
Search modes: structured, lexical. History: Current retained projection; exact historical reconstruction is unsupported.
Measures: record_count. Monetary values use decimal strings with declared units. Unknown amounts do not become zero.
Field definitions and supported filters · 48 fields
| Field | Type / unit | Meaning | Availability and filters |
|---|---|---|---|
_ingested_at | string | Incremental FPDS processing timestamp text.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
action_date | date | Reported award action date; USAspending summary mapping currently uses Start Date instead.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
action_date_fiscal_year | string | Publisher federal fiscal year of the action in older FPDS files.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
award_id_piid | string | Procurement Instrument Identifier of a contract/order; source award identity includes issuer/parent context.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
award_type | string | Source instrument category label; decode within the source export version.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
award_type_code | string | Source instrument category code; code sets differ across FPDS/USAspending contexts.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
awarding_agency_code | string | Reported awarding agency code identifier; keep its source namespace and buying-versus-funding role.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
awarding_agency_name | string | Reported awarding agency name label; resolve identifiers separately.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
awarding_sub_agency_code | string | Reported awarding sub agency code identifier; keep its source namespace and buying-versus-funding role.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
base_and_exercised_options_value | decimal / USD | Reported base/exercised-options contractual value on this action; distinguish action change from cumulative source total. Not an action obligation or an all-options ceiling.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
cage_code | string | Commercial and Government Entity code; a separate entity/site identifier namespace.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ.CAGE/NCAGE is ordinarily a 5-character code; wider storage is not a source format guarantee. | Values can be missingeq, in, is_null, contains |
consolidated_contract | string | Reported consolidated-contract indicator, often represented as source text.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
contract_award_unique_key | string | USAspending source key identifying a prime contract award across its transactions.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
contract_transaction_unique_key | string | USAspending source key identifying a contract transaction/action when present.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
current_total_value_of_award | decimal / USD | Current reported contract amount including base and exercised options; distinct from potential all-options value and action obligation. Select once at award/as-of grain, not SUM across modifications.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
extent_competed | string | Source competition-method label.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
extent_competed_code | string | Source competition-method code; preserve the code and source dictionary version.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
federal_action_obligation | decimal / USD | Signed action-level obligation/deobligation delta; missing is not zero.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
funding_agency_code | string | Reported funding agency code identifier; keep its source namespace and buying-versus-funding role.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
labor_standards | string | Reported labor-standards applicability indicator; verify actual referenced provisions.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
last_modified_date | date | Publisher-reported record update date in older FPDS files.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
modification_number | string | Source action/modification label; P/A prefixes do not determine modification reason or a performance extension.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
multi_year_contract | string | Reported multi-year contract indicator; not the same as a contract having options.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
naics_code | string | Source industry classification code; link with the NAICS edition and declared precision.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ.Require a classification edition; do not join broad prefixes as exact identities. | Values can be missingeq, in, is_null, contains |
naics_description | string | Industry classification description; it is not an award requirement narrative.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
number_of_offers_received | string | Reported count of offers received; one offer alone does not prove a sole-source procurement.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
parent_award_id_piid | string | Referenced parent IDV/award PIID; not the child task order identity.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
period_of_performance_current_end_date | date | Current award completion date excluding unexercised options.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
period_of_performance_potential_end_date | date | Potential award completion date including possible options; not the current completion date.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
period_of_performance_start_date | date | Reported award performance start date.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
primary_place_of_performance_state_code | string | Source state/territory code of the place of performance; distinct from recipient legal address.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
primary_place_of_performance_zip_4 | string | Source ZIP+4 of the place of performance; distinct from recipient legal address.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
product_or_service_code | string | Source FPDS/USAspending product/service classification.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
recipient_name | string | Reported award recipient label; not a unique entity identifier.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
recipient_state_code | string | Reported recipient address state code; not the contract place of performance.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
recipient_uei | string | Source UEI identifying the recipient participant; missing/empty values cannot support an exact entity join.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ.Logical UEI length is 12; a wider varchar is not broader identity support. | Values can be missingeq, in, is_null, contains |
solicitation_identifier | string | FPDS source solicitation reference for linking a reported action to a notice.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
solicitation_procedures | string | Reported solicitation procedure label/code.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
total_dollars_obligated | decimal / USD | Cumulative award obligations at a reported snapshot; do not sum across modifications.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, gte, lte |
transaction_description | string | Reported transaction description retained by incremental exports.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
type_of_contract_pricing_code | string | Source contract pricing arrangement code; not a bid or rate recommendation.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
type_of_set_aside | string | FPDS/USAspending set-aside label.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
type_of_set_aside_code | string | FPDS/USAspending set-aside code.Storage and value limits: large_string: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
agency_code | string | Source awarding-agency identifier; source namespace must be preserved.Storage and value limits: Bounded by the public query contract. | Values can be missingeq, in, is_null |
action_key | string | Generated SHA-256 of a retained native transaction key when available, otherwise a qualified issuer/parent/PIID/modification reference. Unresolved variants can retain additional observations.Storage and value limits: Bounded by the public query contract. | Values can be missingeq, in, is_null |
award_key | string | Generated SHA-256 of a retained native award key when available, otherwise a qualified issuer/parent/PIID reference. Unresolved variants can retain additional observations.Storage and value limits: Bounded by the public query contract. | Values can be missingeq, in, is_null |
fiscal_year | integer | Collector partition fiscal year; distinct from a calendar year.Storage and value limits: Bounded by the public query contract. | Values can be missingeq, in, is_null, gte, lte |
action_month | string | Calendar YYYY-MM of the reported action date; not a federal fiscal-year label.Storage and value limits: YYYY-MM when a source action date is usable.Unknown action dates remain unknown. | Values can be missingeq, in, is_null |
Award Descriptions
award_descriptions · Schema 1
One retained award-description observation per id, with its reported PIID, modification and issuer context.
Search modes: structured, lexical. History: Current retained projection; exact historical reconstruction is unsupported.
Measures: record_count. Monetary values use decimal strings with declared units. Unknown amounts do not become zero.
Field definitions and supported filters · 12 fields
| Field | Type / unit | Meaning | Availability and filters |
|---|---|---|---|
id | integer | GovBiz surrogate row identifier; interpret together with its relation, not as a source-native key.Storage and value limits: Signed 64-bit integer; values beyond 2^53-1 require a string for JavaScript-safe exactness. | Values can be missingeq, in, is_null, gte, lte |
award_id_piid | string | Procurement Instrument Identifier of a contract/order; source award identity includes issuer/parent context.Storage and value limits: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
modification_number | string | Source action/modification label; P/A prefixes do not determine modification reason or a performance extension.Storage and value limits: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
recipient_uei | string | Source UEI identifying the recipient participant; missing/empty values cannot support an exact entity join.Storage and value limits: No declared field-length cap here; API/output budgets must apply; empty and null differ.Logical UEI length is 12; a wider varchar is not broader identity support. | Values can be missingeq, in, is_null, contains |
recipient_name | string | Reported award recipient label; not a unique entity identifier.Storage and value limits: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
agency_code | string | Stored source agency identifier; namespace can be CGAC, FPDS, top-tier or publisher-specific and must be declared.Storage and value limits: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
naics_code | string | Source industry classification code; link with the NAICS edition and declared precision.Storage and value limits: No declared field-length cap here; API/output budgets must apply; empty and null differ.Require a classification edition; do not join broad prefixes as exact identities. | Values can be missingeq, in, is_null, contains |
psc_code | string | Product and Service Code classification; it is not a NAICS industry code.Storage and value limits: No declared field-length cap here; API/output budgets must apply; empty and null differ.Classification overlap is contextual, not record identity. | Values can be missingeq, in, is_null, contains |
set_aside_code | string | Source set-aside code; use an explicit source/code-version mapping.Storage and value limits: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
action_date | date | Reported award action date; USAspending summary mapping currently uses Start Date instead.Storage and value limits: Calendar date without time of day or timezone; source precision can be month/quarter instead. | Values can be missingeq, in, is_null, gte, lte |
description | string | Source description in the relation context; distinguish from generated interpretation.Storage and value limits: No declared field-length cap here; API/output budgets must apply; empty and null differ. | Values can be missingeq, in, is_null, contains |
updated_at | datetime | GovBiz last row update time.Storage and value limits: Instant with timezone only if declared; otherwise local/producer time must be explicitly interpreted. Do not invent clock precision. | Values can be missingeq, in, is_null, gte, lte |