FPDS Query Library
About Us
Contact Us

Last Modified Date

Timestamp indicating when the award transaction record was most recently updated in FPDS. It reflects the last modification event for that transaction, not necessarily the original award date or the current contract performance date.

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__transactionInformation__lastModifiedDate
Title
Last Modified Date
FPDS Path
award/transactionInformation/lastModifiedDate
Description
Timestamp indicating when the award transaction record was most recently updated in FPDS. It reflects the last modification event for that transaction, not necessarily the original award date or the current contract performance date.
Business Meaning
This field is useful for identifying record freshness, tracking late corrections, and building incremental refresh or change-detection workflows. Analysts use it to understand when procurement data changed, especially when comparing snapshots, auditing updates, or isolating recently edited awards.
Example Value
2023-10-02 21:00:58
Observed Non-Null Count
107,401,777

FPDS Compare

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

Use Cases

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

Common Usage

  • incremental data refresh and change capture
  • sorting records by most recent update
  • auditing or identifying recently edited awards

Common Mistakes

  • confusing last modified time with award date or action date
  • using it as a measure of procurement activity timing

Query Guidance

Parse as a timestamp/datetime type and compare using range predicates for update windows, such as last modified after a given cutoff. For deduplication or latest-record logic, order by this field descending within the award key or transaction group.

SQL Examples

Preview values

SELECT
    content__award__transactionInformation__lastModifiedDate AS last_modified_date
FROM fpds.data
WHERE content__award__transactionInformation__lastModifiedDate IS NOT NULL
LIMIT 25

Top values

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