SpringDB Data Exchange Search data fieldsData vendorsAI Data ConsultantList your data

Bulk Data Feed - SBA 7(a) & 504 Loans

A BrightQuery dataset with 53 fields. View the BrightQuery profile.

Product details

API typeBulkFeed
Match keysbq_id, company_name, domain
Geo coverageUS
Refresh cadenceMonthly
Historical depthPoint-in-time + MR/TS/TSQ/TSM time-series
PII sensitivityFirmographic
ComplianceGovernment-filing-sourced (IRS/SEC/SoS/SBA/DOT/CMS); public record
DeliveryBulk file (S3/Snowflake)
LifecycleGA
Pricing modelbulk_flat - Flat bulk licence (uncredited)
Last verified2026-07-18

Bulk Data Feed - SBA 7(a) & 504 Loans fields

FieldAPI nameCategoryTypeFill rateDescription
NAICS Codesbq_sba_naics_codeIndustry ClassificationNumber (Integer)88%Code/ID of the entry.
Lender Name/Detailsbq_sba_bank_nameGovernment Filings & LoansString94%Name of the third party lender
Address Geo-Coordinatesbq_sba_cdc_address1_longitudeLocation & GeographyNumber (Decimal)-Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Address Countybq_sba_cdc_address1_county_fipsLocation & GeographyNumber (Integer)-County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Address Geo-Coordinatesbq_sba_bank_address1_latitudeLocation & GeographyNumber (Decimal)11%Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Loan Record Attributebq_sba_franchise_codeGovernment Filings & LoansString8%Franchise Code
Address Line 1bq_sba_bank_address1_line_1Location & GeographyString89%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 2bq_sba_bank_address1_secondary_numberLocation & GeographyString43%Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated.
Address Line 2bq_sba_bank_address1_line_2Location & GeographyString-Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated.
Address Citybq_sba_bank_address1_cityLocation & GeographyString94%City of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Statebq_sba_project_stateLocation & GeographyString100%State of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Loan Record Attributebq_sba_project_countyGovernment Filings & LoansNumber (Integer)100%County where project occurs
Loan Datebq_sba_paid_in_full_dateGovernment Filings & LoansDate58%Date on which the loan was approved
Loan Datebq_sba_approval_dateGovernment Filings & LoansDate100%Date on which the loan was approved
Lender Name/Detailsbq_sba_bank_fdic_numberGovernment Filings & LoansNumber (Integer)81%Name of the third party lender
Loan Program & Termsbq_sba_term_in_monthsGovernment Filings & LoansNumber (Integer)100%Indicator of whether loan was approved under SBA's 7(a) or 504 loan program
Loan Program & Termsbq_sba_loan_programGovernment Filings & LoansString100%Indicator of whether loan was approved under SBA's 7(a) or 504 loan program
Loan Amountbq_sba_gross_charge_off_amountGovernment Filings & LoansNumber (Integer)100%Total loan amount
Lender Name/Detailsbq_sba_bank_ncua_numberGovernment Filings & LoansString2%Name of the third party lender
Address Zip Type (USPS)bq_sba_bank_address1_zip_typeLocation & GeographyString11%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_indicatorLocation & GeographyBoolean7%Indicates whether an address is the "default" address for a building (e.g. the main lobby).
Address Geo-Coordinatesbq_sba_cdc_address1_latitudeLocation & GeographyNumber (Decimal)-Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Loan Record Attributebq_sba_delivery_methodGovernment Filings & LoansString100%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 Attributebq_sba_idGovernment Filings & LoansString100%Unique Identifier of the loan record
Loan Record Attributebq_sba_business_typeGovernment Filings & LoansString100%Borrower's Business Type - Individual, Partnership, or Corporation
Loan Statusbq_sba_loan_statusGovernment Filings & LoansString100%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 Statusbq_sba_revolver_statusGovernment Filings & LoansNumber (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 2bq_sba_cdc_address1_secondary_numberLocation & GeographyString-Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated.
Loan Record Attributebq_sba_approval_fiscal_yearGovernment Filings & LoansNumber (Integer)100%Fiscal year in which the loan was approved
Address Zipbq_sba_bank_address1_zip9Location & GeographyString89%5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Loan Record Attributebq_sba_franchise_nameGovernment Filings & LoansString8%Franchise Name (if applicable)
Address Zipbq_sba_bank_address1_zip5Location & GeographyNumber (Integer)89%5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Geo-Coordinatesbq_sba_bank_address1_longitudeLocation & GeographyNumber (Decimal)11%Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Address Countybq_sba_cdc_address1_county_nameLocation & GeographyNumber (Integer)-County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Address Statebq_sba_bank_address1_stateLocation & GeographyString94%State of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Loan Interest Ratebq_sba_initial_interest_rateGovernment Filings & LoansNumber (Integer)37%Initial interest rate - total interest rate (base rate plus spread) at the time the loan was approved
Company IDbq_idIdentity & IdentifiersString100%ZoomInfo ID of the prior company.
Loan Datebq_sba_charge_off_dateGovernment Filings & LoansDate12%Date on which the loan was approved
Loan Record Attributebq_sba_subpgmdescGovernment Filings & LoansString100%Subprogram description - specific subprogram under which the loan was aproved under. See SOP 50 10 5 for definitions and rules for each subprogram.
Loan Amountbq_sba_gross_approval_amountGovernment Filings & LoansNumber (Integer)100%Total loan amount
Address Countybq_sba_bank_address1_county_fipsLocation & GeographyNumber (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_indicatorLocation & GeographyBoolean-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_codeLocation & GeographyString10%Indicates whether an address is verified deliverable per USPS Delivery Point Validation (DPV).
Address Zip Type (USPS)bq_sba_cdc_address1_zip_typeLocation & GeographyString-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_codeLocation & GeographyString-Indicates whether an address is verified deliverable per USPS Delivery Point Validation (DPV).
Address Residential Delivery Indicator (RDI)bq_sba_bank_address1_rdiLocation & GeographyString11%Indicates whether an address is Residential, Commercial, P.O. Box, or Unknown, per USPS reporting.
Address Residential Delivery Indicator (RDI)bq_sba_cdc_address1_rdiLocation & GeographyString-Indicates whether an address is Residential, Commercial, P.O. Box, or Unknown, per USPS reporting.
NAICS Namesbq_sba_naics_nameIndustry ClassificationString88%Name/description of the NAICS entry.
Loan Datebq_sba_first_disbursement_dateGovernment Filings & LoansDate87%Date on which the loan was approved
Loan Record Attributebq_sba_district_officeGovernment Filings & LoansString100%SBA district office
Loan Record Attributebq_sba_guaranteed_approvalGovernment Filings & LoansNumber (Integer)89%Amount of SBA's loan guaranty
Loan Record Attributebq_sba_business_ageGovernment Filings & LoansString14%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 Countybq_sba_bank_address1_county_nameLocation & GeographyNumber (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 - 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.