FPDS Query Library
About Us
Contact Us

Funded Through Date

Date through which the NASA award is funded. It indicates the current funding endpoint recorded for the award in the agency-specific NASA award elements.

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

Variable Overview

FPDS Query Variable
content__award__agencySpecificAwardElements__NASASpecificAwardElements__fundedThroughDate
Title
Funded Through Date
FPDS Path
award/agencySpecificAwardElements/NASASpecificAwardElements/fundedThroughDate
Description
Date through which the NASA award is funded. It indicates the current funding endpoint recorded for the award in the agency-specific NASA award elements.
Business Meaning
This field helps analysts understand the funded period attached to a NASA award, which supports budget timing, obligation coverage, and award lifecycle analysis. It is useful for identifying whether an award’s funding is current, expiring, or extended across reporting periods.
Example Value
2024-07-05 00:00:00
Observed Non-Null Count
297,835

FPDS Compare

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

Use Cases

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

Common Usage

  • Measure remaining funded time on NASA awards
  • Filter awards by funding cutoff date
  • Compare funding coverage to obligation or performance periods

Common Mistakes

  • Confusing funded through date with period of performance end date
  • Using the raw string without casting or date normalization

Query Guidance

Parse the field to a date in SQL before filtering or aggregating, and use it as an upper boundary for funding-related analysis. Example pattern: WHERE CAST(fundedThroughDate AS DATE) >= CURRENT_DATE for active funding, or group by fundedThroughDate month/year after converting to a date.

SQL Examples

Preview values

SELECT
    content__award__agencySpecificAwardElements__NASASpecificAwardElements__fundedThroughDate AS funded_through_date
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__fundedThroughDate IS NOT NULL
LIMIT 25

Top values

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