FPDS Query Library
About Us
Contact Us

Title

Human-readable award title stored as a free-text string. It typically combines the contract number, vendor name, award type, and sometimes modification or action information, serving as an identifying label for the FPDS record.

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

Variable Overview

FPDS Query Variable
title
Title
Title
FPDS Path
title
Description
Human-readable award title stored as a free-text string. It typically combines the contract number, vendor name, award type, and sometimes modification or action information, serving as an identifying label for the FPDS record.
Business Meaning
This field helps analysts quickly recognize and distinguish awards in searches, reporting, and review workflows. It is useful for grouping records by recognizable award labels, validating award identity, and supporting narrative inspection of procurement activity.
Example Value
DEFINITIVE CONTRACT DEAC2289PC88400 (A056) awarded to BURNS & ROE INC, was modified for the amount of $217,801
Observed Non-Null Count
117,423,893

FPDS Compare

FPDS Query Variable
title
FPDS XML Path
title
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

  • record identification
  • text-based filtering
  • report display labels

Common Mistakes

  • using it as a unique key
  • assuming a fixed format across all records

Query Guidance

Use LIKE, ILIKE, or full-text search for pattern-based retrieval, and combine with structured identifiers such as contract number, vendor name, or action dates for precise results. Do not rely on exact string matching unless you have normalized the text and confirmed consistent formatting.

SQL Examples

Preview values

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

Top values

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