Bulk Data Feed - SBA 7(a) & 504 Loans
A BrightQuery dataset with 53 fields. View the BrightQuery profile.
Product details
| API type | BulkFeed |
|---|---|
| Match keys | bq_id, company_name, domain |
| Geo coverage | US |
| Refresh cadence | Monthly |
| Historical depth | Point-in-time + MR/TS/TSQ/TSM time-series |
| PII sensitivity | Firmographic |
| Compliance | Government-filing-sourced (IRS/SEC/SoS/SBA/DOT/CMS); public record |
| Delivery | Bulk file (S3/Snowflake) |
| Lifecycle | GA |
| Pricing model | bulk_flat - Flat bulk licence (uncredited) |
| Last verified | 2026-07-18 |
Bulk Data Feed - SBA 7(a) & 504 Loans fields
| Field | API name | Category | Type | Fill rate | Description |
|---|---|---|---|---|---|
| NAICS Codes | bq_sba_naics_code | Industry Classification | Number (Integer) | 88% | Code/ID of the entry. |
| Lender Name/Details | bq_sba_bank_name | Government Filings & Loans | String | 94% | Name of the third party lender |
| Address Geo-Coordinates | bq_sba_cdc_address1_longitude | Location & Geography | Number (Decimal) | - | Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address County | bq_sba_cdc_address1_county_fips | Location & Geography | Number (Integer) | - | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address Geo-Coordinates | bq_sba_bank_address1_latitude | Location & Geography | Number (Decimal) | 11% | Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Loan Record Attribute | bq_sba_franchise_code | Government Filings & Loans | String | 8% | Franchise Code |
| Address Line 1 | bq_sba_bank_address1_line_1 | Location & Geography | String | 89% | The street address line 1 (primary street/building address) of an entity's address, distinct from address line 2, city, state, and ZIP. |
| Address Line 2 | bq_sba_bank_address1_secondary_number | Location & Geography | String | 43% | Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated. |
| Address Line 2 | bq_sba_bank_address1_line_2 | Location & Geography | String | - | Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated. |
| Address City | bq_sba_bank_address1_city | Location & Geography | String | 94% | City of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address State | bq_sba_project_state | Location & Geography | String | 100% | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Loan Record Attribute | bq_sba_project_county | Government Filings & Loans | Number (Integer) | 100% | County where project occurs |
| Loan Date | bq_sba_paid_in_full_date | Government Filings & Loans | Date | 58% | Date on which the loan was approved |
| Loan Date | bq_sba_approval_date | Government Filings & Loans | Date | 100% | Date on which the loan was approved |
| Lender Name/Details | bq_sba_bank_fdic_number | Government Filings & Loans | Number (Integer) | 81% | Name of the third party lender |
| Loan Program & Terms | bq_sba_term_in_months | Government Filings & Loans | Number (Integer) | 100% | Indicator of whether loan was approved under SBA's 7(a) or 504 loan program |
| Loan Program & Terms | bq_sba_loan_program | Government Filings & Loans | String | 100% | Indicator of whether loan was approved under SBA's 7(a) or 504 loan program |
| Loan Amount | bq_sba_gross_charge_off_amount | Government Filings & Loans | Number (Integer) | 100% | Total loan amount |
| Lender Name/Details | bq_sba_bank_ncua_number | Government Filings & Loans | String | 2% | Name of the third party lender |
| Address Zip Type (USPS) | bq_sba_bank_address1_zip_type | Location & Geography | String | 11% | Zip code classification of an address indicating whether it is a P.O. Box or not. |
| Address Building Default Indicator (USPS) | bq_sba_bank_address1_building_default_indicator | Location & Geography | Boolean | 7% | Indicates whether an address is the "default" address for a building (e.g. the main lobby). |
| Address Geo-Coordinates | bq_sba_cdc_address1_latitude | Location & Geography | Number (Decimal) | - | Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Loan Record Attribute | bq_sba_delivery_method | Government Filings & Loans | String | 100% | Specific delivery method loan was approved under. See SOP 50 10 5 for definitions and rules for each delivery method. 7(a) Delivery Methods: CA = Community Advantage CLP = Certified Lenders Program COMM EXPRS =… |
| Loan Record Attribute | bq_sba_id | Government Filings & Loans | String | 100% | Unique Identifier of the loan record |
| Loan Record Attribute | bq_sba_business_type | Government Filings & Loans | String | 100% | Borrower's Business Type - Individual, Partnership, or Corporation |
| Loan Status | bq_sba_loan_status | Government Filings & Loans | String | 100% | Current status of loan: COMMIT = Undisbursed PIF = Paid In Full CHGOFF = Charged Off CANCLD = Cancelled EXEMPT = The status of loans that have been disbursed but have not been cancelled, paid in full, or charged off… |
| Loan Status | bq_sba_revolver_status | Government Filings & Loans | Number (Integer) | 89% | Current status of loan: COMMIT = Undisbursed PIF = Paid In Full CHGOFF = Charged Off CANCLD = Cancelled EXEMPT = The status of loans that have been disbursed but have not been cancelled, paid in full, or charged off… |
| Address Line 2 | bq_sba_cdc_address1_secondary_number | Location & Geography | String | - | Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated. |
| Loan Record Attribute | bq_sba_approval_fiscal_year | Government Filings & Loans | Number (Integer) | 100% | Fiscal year in which the loan was approved |
| Address Zip | bq_sba_bank_address1_zip9 | Location & Geography | String | 89% | 5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Loan Record Attribute | bq_sba_franchise_name | Government Filings & Loans | String | 8% | Franchise Name (if applicable) |
| Address Zip | bq_sba_bank_address1_zip5 | Location & Geography | Number (Integer) | 89% | 5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address Geo-Coordinates | bq_sba_bank_address1_longitude | Location & Geography | Number (Decimal) | 11% | Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address County | bq_sba_cdc_address1_county_name | Location & Geography | Number (Integer) | - | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address State | bq_sba_bank_address1_state | Location & Geography | String | 94% | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Loan Interest Rate | bq_sba_initial_interest_rate | Government Filings & Loans | Number (Integer) | 37% | Initial interest rate - total interest rate (base rate plus spread) at the time the loan was approved |
| Company ID | bq_id | Identity & Identifiers | String | 100% | ZoomInfo ID of the prior company. |
| Loan Date | bq_sba_charge_off_date | Government Filings & Loans | Date | 12% | Date on which the loan was approved |
| Loan Record Attribute | bq_sba_subpgmdesc | Government Filings & Loans | String | 100% | Subprogram description - specific subprogram under which the loan was aproved under. See SOP 50 10 5 for definitions and rules for each subprogram. |
| Loan Amount | bq_sba_gross_approval_amount | Government Filings & Loans | Number (Integer) | 100% | Total loan amount |
| Address County | bq_sba_bank_address1_county_fips | Location & Geography | Number (Integer) | 11% | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address Building Default Indicator (USPS) | bq_sba_cdc_address1_building_default_indicator | Location & Geography | Boolean | - | Indicates whether an address is the "default" address for a building (e.g. the main lobby). |
| Address DPV Match Code (USPS) | bq_sba_bank_address1_dpv_match_code | Location & Geography | String | 10% | Indicates whether an address is verified deliverable per USPS Delivery Point Validation (DPV). |
| Address Zip Type (USPS) | bq_sba_cdc_address1_zip_type | Location & Geography | String | - | Zip code classification of an address indicating whether it is a P.O. Box or not. |
| Address DPV Match Code (USPS) | bq_sba_cdc_address1_dpv_match_code | Location & Geography | String | - | Indicates whether an address is verified deliverable per USPS Delivery Point Validation (DPV). |
| Address Residential Delivery Indicator (RDI) | bq_sba_bank_address1_rdi | Location & Geography | String | 11% | Indicates whether an address is Residential, Commercial, P.O. Box, or Unknown, per USPS reporting. |
| Address Residential Delivery Indicator (RDI) | bq_sba_cdc_address1_rdi | Location & Geography | String | - | Indicates whether an address is Residential, Commercial, P.O. Box, or Unknown, per USPS reporting. |
| NAICS Names | bq_sba_naics_name | Industry Classification | String | 88% | Name/description of the NAICS entry. |
| Loan Date | bq_sba_first_disbursement_date | Government Filings & Loans | Date | 87% | Date on which the loan was approved |
| Loan Record Attribute | bq_sba_district_office | Government Filings & Loans | String | 100% | SBA district office |
| Loan Record Attribute | bq_sba_guaranteed_approval | Government Filings & Loans | Number (Integer) | 89% | Amount of SBA's loan guaranty |
| Loan Record Attribute | bq_sba_business_age | Government Filings & Loans | String | 14% | SBA began collecting the following business age information in fiscal year 2018: Change of Ownership Existing or more than 2 years old New Business or 2 years or less Startup, Loan Funds will Open Business |
| Address County | bq_sba_bank_address1_county_name | Location & Geography | Number (Integer) | 11% | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
More from BrightQuery
- Bulk Data Feed - Organization Executives
- Bulk Data Feed - Organization Contacts
- Bulk Data Feed - Franchise: Franchisor Affiliates
- Bulk Data Feed - Stock Filings: Legal Entity
- Bulk Data Feed - Healthcare: Provider Individuals
- Bulk Data Feed - Dept. of Transportation
- Bulk Data Feed - Organization All Names
- Bulk Data Feed - Firmographics
- Bulk Data Feed - Legal Entity Officers & Directors
- Bulk Data Feed - Financials & Employment (Most Recent)
- Bulk Data Feed - Franchise: Franchisee / Controlled Entity
- Bulk Data Feed - Family Tree / Legal Entity
- Bulk Data Feed - Address Universe: Building Unit Address
- Bulk Data Feed - Establishments
- Bulk Data Feed - Organization Locations
- Bulk Data Feed - Stock Filings: Transaction Filing Types
- Bulk Data Feed - Stock Filings: Class Series (Time Series)
- Bulk Data Feed - Stock Filings: Corporate Status & Fees
- Bulk Data Feed - Healthcare: Provider Organization Firmographics
- Bulk Data Feed - Stock Filings: Stock Events
- Bulk Data Feed - Employment (Monthly Time Series)
- Bulk Data Feed - Stock Filings: Classes of Stock Issued
- Bulk Data Feed - Stock Filings: Stock Group (Time Series)
- Bulk Data Feed - Franchise: Franchisor / Controlling Entity
- Bulk Data Feed - Franchise: Brand & Franchisor Parent
- Bulk Data Feed - Healthcare: Provider Location
- Bulk Data Feed - Healthcare: Individual Details
- Bulk Data Feed - Franchise: Brands
- Bulk Data Feed - Address Universe: Building Address
- Bulk Data Feed - Organization Mapping
- Bulk Data Feed - Stock Filings: Event Timeline
- Bulk Data Feed - Franchise: Affiliates Mapping
- Bulk Data Feed - Address Universe: Unit-Organization Mapping
- Bulk Data Feed - Address Universe: Unit-Location Mapping
- Bulk Data Feed - Healthcare: Group-Individual Mapping
- Bulk Data Feed - Address Universe: Unit-Legal Entity Mapping
- Bulk Data Feed - Healthcare: Group Practice
- Bulk Data Feed - Healthcare: Org-Individual Mapping
Bulk Data Feed - SBA 7(a) & 504 Loans FAQ
What fields are in Bulk Data Feed - SBA 7(a) & 504 Loans?
Bulk Data Feed - SBA 7(a) & 504 Loans from BrightQuery has 53 fields across industry classification, government filings & loans, location & geography and identity & identifiers, including Address State, Loan Record Attribute and Loan Date. Average fill rate: 66%.
What do I need to match against Bulk Data Feed - SBA 7(a) & 504 Loans?
Bulk Data Feed - SBA 7(a) & 504 Loans matches on bq_id, company_name and domain.
How is Bulk Data Feed - SBA 7(a) & 504 Loans priced?
bulk_flat - Flat bulk licence (uncredited). Request a quote or a sample on SpringDB.