FPDS Query Library
About Us
Contact Us

Number of Offers Received

Count of offers or bids recorded as received for the IDV action. This is a stored text field that captures the reported number of offers received, such as "1".

Family: IDV
Category: Competition
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__competition__numberOfOffersReceived
Title
Number of Offers Received
FPDS Path
IDV/competition/numberOfOffersReceived
Description
Count of offers or bids recorded as received for the IDV action. This is a stored text field that captures the reported number of offers received, such as "1".
Business Meaning
This field helps assess the level of competition associated with an IDV record. Analysts use it to distinguish single-offer actions from more competitive procurements and to support metrics on market response, sourcing patterns, and potential noncompetitive conditions.
Example Value
1
Observed Non-Null Count
5,247,195

FPDS Compare

FPDS Query Variable
content__IDV__competition__numberOfOffersReceived
FPDS XML Path
IDV/competition/numberOfOffersReceived
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/competition/numberOfOffersReceived' into the SQL-ready variable 'content__IDV__competition__numberOfOffersReceived'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Competition and sole-source analysis

Common Usage

  • Count records with one or more offers received
  • Compare competition levels across awarding agencies or product/service groups
  • Flag actions with unusually low or missing offer counts

Common Mistakes

  • Assuming every value is a clean integer without checking for blanks or non-numeric text
  • Using this field alone as proof of full competition without reviewing related competition attributes

Query Guidance

Filter and aggregate cautiously because the field is stored as string. Cast to numeric only after validating values, and join or compare with other competition-related fields to interpret whether the count reflects competitive solicitation, sole source, or other recorded conditions.

SQL Examples

Preview values

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

Top values

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