FPDS Query Library
About Us
Contact Us

Is Sba Certified Hub Zone

Boolean indicator showing whether the vendor associated with the award record is SBA-certified as a HUBZone firm. It is a status flag captured at the vendor site level within the award detail structure.

Family: Other Transaction Award
Category: Vendor Site Details
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorCertifications__isSBACertifiedHUBZone
Title
Is Sba Certified Hub Zone
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/vendorCertifications/isSBACertifiedHUBZone
Description
Boolean indicator showing whether the vendor associated with the award record is SBA-certified as a HUBZone firm. It is a status flag captured at the vendor site level within the award detail structure.
Business Meaning
This field helps analysts identify awards involving HUBZone-certified vendors, which is relevant for small business utilization tracking, socioeconomic reporting, and policy compliance analysis. It supports measurement of how often HUBZone-certified firms participate in federal procurement and where set-aside or preference objectives are being met.
Example Value
0
Observed Non-Null Count
38,894

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards involving HUBZone-certified vendors
  • Calculate socioeconomic participation rates
  • Segment vendor populations by certification status

Common Mistakes

  • Assuming null means the vendor is not HUBZone-certified
  • Using the field without checking whether the dataset stores boolean values as 0/1 or true/false

Query Guidance

Use this field in WHERE clauses to isolate HUBZone-certified records, for example WHERE isSBACertifiedHUBZone = 1. If nulls are present, explicitly decide whether to exclude them or treat them as unknown, and normalize values when combining sources with different boolean encodings.

SQL Examples

Preview values

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

Flag distribution

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorCertifications__isSBACertifiedHUBZone AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__vendorCertifications__isSBACertifiedHUBZone IS NOT NULL
GROUP BY flag_value
ORDER BY record_count DESC

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.