FPDS Query Library
About Us
Contact Us

Closeout PR

Binary NASA-specific indicator showing whether the award record is marked as a closeout purchase request. A value of 0 means false and 1 means true. It is an attribute on the award record rather than a transaction amount or date.

Family: Award
Category: General
Data Type: numeric
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__agencySpecificAwardElements__NASASpecificAwardElements__closeoutPR
Title
Closeout PR
FPDS Path
award/agencySpecificAwardElements/NASASpecificAwardElements/closeoutPR
Description
Binary NASA-specific indicator showing whether the award record is marked as a closeout purchase request. A value of 0 means false and 1 means true. It is an attribute on the award record rather than a transaction amount or date.
Business Meaning
This field helps identify awards associated with NASA closeout activity, which can be useful for lifecycle analysis, workload segmentation, and tracking obligations tied to contract closeout processes. It supports filtering NASA records from broader FPDS extracts when analysts need to distinguish operational awards from closeout-related actions.
Example Value
0
Observed Non-Null Count
741,370

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter NASA awards flagged for closeout processing
  • Group records by closeout versus non-closeout status
  • Validate NASA-specific award lifecycle reporting

Common Mistakes

  • Interpreting 0 as missing rather than false
  • Using the flag as a proxy for award termination or contract completion

Query Guidance

In SQL, compare against numeric values directly, for example `WHERE closeoutPR = 1` for closeout awards or `WHERE closeoutPR = 0` for non-closeout records. If your dataset may contain nulls, handle them explicitly with `COALESCE` or `IS NULL` checks before aggregating.

SQL Examples

Preview values

SELECT
    content__award__agencySpecificAwardElements__NASASpecificAwardElements__closeoutPR AS closeout_p_r
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__closeoutPR IS NOT NULL
LIMIT 25

Aggregate total

SELECT
    sum(content__award__agencySpecificAwardElements__NASASpecificAwardElements__closeoutPR) AS total_value
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__closeoutPR IS NOT NULL

Distribution overview

SELECT
    min(content__award__agencySpecificAwardElements__NASASpecificAwardElements__closeoutPR) AS min_value,
    avg(content__award__agencySpecificAwardElements__NASASpecificAwardElements__closeoutPR) AS avg_value,
    max(content__award__agencySpecificAwardElements__NASASpecificAwardElements__closeoutPR) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__closeoutPR IS NOT NULL

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.