U.S. SBA Loan Market Cohorts
SBA 7(a) and 504 approval totals for fiscal years 2020–2025 by state, industry and status, with lender activity and underlying loan records.
- Primary rows
- 143,903
- Primary fields
- 12
- Coverage
- US
- Source snapshot
- Jun 30, 2026
Each primary row: One loan-program, fiscal-year, project-state, NAICS and reported-status combination.
Sample data
Download sample100 sample rows as CSV · all 12 primary fields.
[] / {} Empty collection0 / false Recorded valuesDownload field definitions (CSV)
Download sample documentation (ZIP)Included data
- 143,903 market cohorts include approval counts, exact monetary totals and the number of known values behind each total.
- Lender and CDC activity is grouped separately across fiscal years, project states and loan statuses.
- All 392,242 underlying approvals remain in loan_evidence.csv, including canceled statuses and counted duplicates.
What’s in the package
- market_cohorts.csv143,903 rows · 12 fields
- lender_activity.csv56,387 rows · 14 fields
One program/fiscal-year/project-state/intermediary/status cohort.
- loan_evidence.csv392,242 rows · 32 fields
One captured approval record, including source duplicates and all statuses.
For borrower contacts, institution references and combined borrower/lender profiles, see SBA Loans, Borrowers & Lenders. The approval records overlap. View the related package →
Companion table fields
lender_activity.csv14 fields
| Field | Definition & format |
|---|---|
Lender activity id lender_activity_id | SHA-256 of compact JSON tuple: program, fiscal year, project state, intermediary key, role, status.
|
Program program | Published program, 7A or 504.
|
Approval fiscal year approval_fiscal_year | Approval fiscal year FY2020-FY2025.
|
Project state project_state | Project state, distinct from borrower mailing state.
|
Loan status loan_status | Reported status at source capture, distinct from approval-date status.
|
Intermediary key intermediary_key | 7(a) source lender group key, or 504 CDC location ID; absent CDC IDs use a stated name/address hash.
|
Intermediary role intermediary_role | 7a_lender or 504_cdc; CDCs are distinct from third-party banks.
|
Reported names json reported_names_json | Sorted distinct source spellings of business intermediary names.
|
Loan record count loan_record_count | Captured approval records including the separately identified status and source duplicates.
|
Approvals with amount approvals_with_amount | Number of records with a reported gross approval amount.
|
Gross approval sum usd gross_approval_sum_usd | Exact sum of reported gross approval amounts with cents preserved; blank when no amounts were reported.
|
Approvals with jobs approvals_with_jobs | Number of records with a reported jobs-supported value.
|
Reported jobs sum reported_jobs_sum | Sum of reported jobs supported across approvals; not unique workers, jobs created or current employment.
|
Distinct complete borrower address groups distinct_complete_borrower_address_groups | Distinct complete source name/address groups; not verified legal entities.
|
loan_evidence.csv32 fields
| Field | Definition & format |
|---|---|
Loan id loan_id | Program plus published source-record ID; source duplicates remain distinct.
|
Cohort id cohort_id | SHA-256 of compact JSON tuple: program, fiscal year, project state, NAICS, status.
|
Lender activity id lender_activity_id | SHA-256 of compact JSON tuple: program, fiscal year, project state, intermediary key, role, status.
|
Intermediary key intermediary_key | 7(a) source lender group key, or 504 CDC location ID; absent CDC IDs use a stated name/address hash.
|
Intermediary role intermediary_role | 7a_lender or 504_cdc; CDCs are distinct from third-party banks.
|
Intermediary name intermediary_name | Reported 7(a) lender or 504 CDC name.
|
Source As Of Date source_as_of_date | Source record snapshot date
|
Program program | SBA program; 7A
|
Record ID record_id | Source CSV SHA-256 plus data-row ordinal; not a persistent loan ID
|
Borrower Name borrower_name | Published borrower name
|
Borrower Address borrower_address | Published borrower street address
|
Borrower City borrower_city | Published borrower city
|
Borrower State borrower_state | Published borrower state or territory
|
Borrower ZIP borrower_zip | Published borrower ZIP, retained as text
|
Borrower Address Group ID borrower_address_group_id | SHA-256 of normalized name/address combination, shared by 7(a) and 504 records; not a legal company identity
|
Borrower Group Key Complete borrower_group_key_complete | All five grouping fields present; incomplete records get individual row keys
|
Approval Date approval_date | Published approval date used to select the requested fiscal or calendar period; not a disbursement date.
|
Approval Fiscal Year approval_fiscal_year | SBA fiscal year; October through September
|
Project State project_state | Project state, not necessarily borrower mailing state
|
Project County project_county | Project county, not necessarily borrower mailing county
|
NAICS Code naics_code | Published NAICS identifier; source edition may contain different NAICS vintages
|
NAICS Description naics_description | Published industry description, not a new classification
|
Franchise Code franchise_code | Published franchise code
|
Franchise Name franchise_name | Published franchise name
|
Business Type business_type | Published borrower type; corporation, partnership or individual
|
Business Age Category business_age_category | Reported categorical description, not an exact company age
|
Gross Approval USD gross_approval_usd | Published total loan amount in USD; not cash available or revenue; source decimal precision retained, including disclosed fractions of a cent
|
First Disbursement Date first_disbursement_date | First disbursement date if disclosed
|
Loan Status loan_status | Documented SBA status code; spaced letters are joined only when that forms a documented code, e.g. P I F becomes PIF
|
Loan Status Source loan_status_source | Raw status label after whitespace cleanup
|
Jobs Supported Reported jobs_supported_reported | Lender-reported jobs created plus retained; not verified by SBA
|
Identical Source Record Count identical_source_record_count | Count of identical full source rows in this year, retained as separate records
|
Field coverage
Data notes
Coverage counts use the full tables. They exclude blank cells and empty JSON collections; zero and false count as populated.
- Historical approvals do not establish disbursement, current business operations or creditworthiness. Statuses reflect the later source publication.
- Reported jobs can overlap across approvals; totals are not unique employment or jobs created.
- Borrower address groups and CDC name/address groups do not verify legal identities. Identical published records remain included.
- This package has no place-contact enrichment. It summarizes the same fiscal-year loan population as the combined SBA package.