FPDS Query Library
About Us
Contact Us

Contractor Name

Legal name of the contractor or vendor identified as the recipient of the Other Transaction award. This is the human-readable label used to identify the awardee in the record.

Family: Other Transaction Award
Category: General
Data Type: string
Semantic Type: label
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__contractorName
Title
Contractor Name
FPDS Path
OtherTransactionAward/contractDetail/vendor/contractorName
Description
Legal name of the contractor or vendor identified as the recipient of the Other Transaction award. This is the human-readable label used to identify the awardee in the record.
Business Meaning
It enables analysts to identify who received the award, aggregate obligations by vendor, and assess recipient concentration, repeat awards, and vendor performance patterns across Other Transaction activity.
Example Value
ANEEVE LLC
Observed Non-Null Count
1,130

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__contractorName
FPDS XML Path
OtherTransactionAward/contractDetail/vendor/contractorName
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/vendor/contractorName' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__vendor__contractorName'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • Vendor-level spend aggregation
  • Award recipient identification
  • Trend analysis by contractor

Common Mistakes

  • Assuming the name is unique across all records
  • Using the text value alone for entity matching without identifier cross-checks

Query Guidance

Select and group by this field only for reporting and display; for reliable vendor joins or de-duplication, pair it with vendor identifiers or other stable IDs. In SQL, consider trimming, uppercasing, and removing extra punctuation when comparing names, and inspect observed values for abbreviations or alternate spellings.

SQL Examples

Preview values

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

Top values

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