FPDS Query Library
About Us
Contact Us

Modified

Timestamp indicating when the award record was most recently updated in FPDS. It captures the last modification event for the record, not necessarily the original award date.

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

Variable Overview

FPDS Query Variable
modified
Title
Modified
FPDS Path
modified
Description
Timestamp indicating when the award record was most recently updated in FPDS. It captures the last modification event for the record, not necessarily the original award date.
Business Meaning
This field is useful for identifying record recency, tracking updates to award data over time, and building incremental refresh or audit workflows. In procurement analysis, it helps distinguish newly modified records from older awards that have not changed recently.
Example Value
2006-04-01 02:17:30
Observed Non-Null Count
112,126,470

FPDS Compare

FPDS Query Variable
modified
FPDS XML Path
modified
Mapping Type
project_level_field
Comparison Summary
This variable is exposed directly as a project-level field in FPDS Query.

Use Cases

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

Common Usage

  • incremental data refresh and change detection
  • filtering records modified within a date range
  • identifying recently updated awards for QA or audit review

Common Mistakes

  • mistaking it for the award creation or obligation date
  • comparing it as text instead of a timestamp

Query Guidance

Cast or parse the string to a datetime type before comparing, sorting, or truncating by date. Use it in WHERE clauses for modification windows and in ORDER BY when selecting the most recently updated records; if multiple versions exist, pair it with award identifiers to avoid duplicate counting.

SQL Examples

Preview values

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

Top values

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