U.S. SBA Loans, Borrowers & Lenders
SBA 7(a) and 504 loan approvals for fiscal years 2020–2025, with borrower groups and lender summaries.
- Primary rows
- 351,984
- Primary fields
- 82
- Coverage
- US
- Source snapshot
- Jun 30, 2026
- Fiscal years 2020–2025
- Oct 1, 2019 – Sep 30, 2025
- Place reference
- Sep 23, 2026
Each primary row: One conservative borrower name/address group across all covered fiscal years.
Sample data
Download sampleDownload 100 rows as CSV with all 82 primary fields.
[] / {} Empty collection0 / false Recorded valuesDownload field definitions (CSV)
About this sample
Primary table only, all columns. Columns of type json contain JSON text within CSV cells.
Included data
- Separate 7(a) and 504 loan tables connect to borrower groups across programs and years; borrower groups describe normalized names and addresses rather than verified companies.
- Lender summaries, fiscal-year activity, industry segments and borrower-state breakdowns include exact FDIC and NCUA identifier matches and dated financial reports.
- Borrowers carry loan counts and amounts, industries, published lender and CDC names, place contacts and labeled name/address links to Form 5500 sponsors and OSHA establishments.
What’s in the package
- borrowers.csv351,984 rows · 82 fields
- loans_7a.csv347,514 rows · 53 fields
One published 7(a) approval record; joins to borrowers on borrower_address_group_id and to lenders on lender_key.
- loans_504.csv44,728 rows · 48 fields
One published 504 approval record with its CDC and third-party lender; joins to borrowers on borrower_address_group_id.
- lenders.csv2,301 rows · 64 fields
One identifier-based lender across all covered fiscal years.
- lender_fiscal_years.csv8,829 rows · 62 fields
One lender within one approval fiscal year, with that year's September 30 financials.
- lender_industries.csv126,239 rows · 6 fields
One lender/NAICS segment within one fiscal year; approval_record_count measures loans.
- lender_borrower_states.csv28,880 rows · 5 fields
One lender/borrower-state segment within one fiscal year; approval_record_count measures loans.
Companion table fields
loans_7a.csv53 fields
| Field | Definition & format |
|---|---|
Source As Of Date source_as_of_date | Source record snapshot date
|
Program program | SBA program; 7A
|
Lender Location ID lender_location_id | SBA lender identifier, not a loan or borrower identifier
|
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
|
Lender Name lender_name | Lender currently assigned to the loan at the source date
|
Lender FDIC Certificate lender_fdic_certificate | FDIC certificate, retained as source text including leading zeros
|
Lender NCUA Charter lender_ncua_charter | NCUA charter, retained as text
|
Lender Address lender_address | Published bank street address
|
Lender City lender_city | Published bank city
|
Lender State lender_state | Published bank state
|
Lender ZIP lender_zip | Published bank ZIP
|
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
|
SBA Guaranteed Approval USD sba_guaranteed_approval_usd | Published SBA-guaranteed loan amount in USD; source decimal precision retained, including disclosed fractions of a cent
|
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
|
First Disbursement Date first_disbursement_date | First disbursement date if disclosed
|
Processing Method processing_method | Published loan processing method description
|
Initial Interest Rate Percent initial_interest_rate_percent | Initial total interest rate in percentage points; 11.04 means 11.04%
|
Interest Rate Type Source interest_rate_type_source | Source fixed/variable indicator
|
Term Months term_months | Published loan term in months
|
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
|
Project County project_county | Project county, not necessarily borrower mailing county
|
Project State project_state | Project state, not necessarily borrower mailing state
|
SBA District Office sba_district_office | SBA district office
|
Congressional District congressional_district | Published project congressional district; keep leading zeros
|
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
|
Loan Status Source loan_status_source | Raw status label after whitespace cleanup
|
Paid In Full Date paid_in_full_date | Paid-in-full date when disclosed
|
Charge Off Date charge_off_date | Charge-off date when disclosed
|
Gross Charge Off USD gross_charge_off_usd | Published total balance charged off, including guaranteed and non-guaranteed portions; source decimal precision retained, including disclosed fractions of a cent
|
Is Revolving is_revolving | Y/1 revolving line of credit; N/0 term loan; source dictionary and CSV use different representations
|
Jobs Supported Reported jobs_supported_reported | Lender-reported jobs created plus retained; not verified by SBA
|
Has Collateral Reported has_collateral_reported | Lender-reported collateral indicator
|
Sold Secondary Market Reported sold_secondary_market_reported | Source Y remains Y once sold; blank remains unknown
|
Record ID record_id | Source CSV SHA-256 plus data-row ordinal; not a persistent loan ID
|
Source Row Number source_row_number | One-based CSV data-row ordinal, excluding header
|
Source Snapshot source_snapshot | Immutable local raw snapshot ID
|
Approval Calendar Year approval_calendar_year | Year of approval_date, not approval_fiscal_year
|
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 Description loan_status_description | Decoded status according to the SBA source dictionary for this record's program
|
Interest Rate Type interest_rate_type | fixed or variable from F/V; blank remains unknown
|
Borrower Address Group ID borrower_address_group_id | SHA-256 of conservatively normalized name/address tuple, 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
|
Identical Source Record Count identical_source_record_count | Count of identical full source rows in this year, retained as separate records
|
Lender Key lender_key | Lender key; joins to lenders.csv and the per-year lender tables
|
loans_504.csv48 fields
| Field | Definition & format |
|---|---|
Source As Of Date source_as_of_date | Source record snapshot date
|
Program program | SBA program; 504
|
SBA Location ID sba_location_id | SBA's published lender location ID for the 504 record (SBA dictionary: unique lender ID code); not a loan or borrower identifier
|
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
|
CDC Name cdc_name | Certified development company (CDC) the loan is currently assigned to at the source date
|
CDC Address cdc_address | Published CDC street address
|
CDC City cdc_city | Published CDC city
|
CDC State cdc_state | Published CDC state
|
CDC ZIP cdc_zip | Published CDC ZIP, retained as text
|
Third-Party Lender Name third_party_lender_name | Published name of the third-party lender in the 504 project
|
Third-Party Lender City third_party_lender_city | Published third-party lender city
|
Third-Party Lender State third_party_lender_state | Published third-party lender state
|
Third-Party Loan USD third_party_loan_usd | Published third-party loan amount in USD, separate from the SBA/CDC amount in gross_approval_usd; source decimal precision retained, including disclosed fractions of a cent
|
Gross Approval USD gross_approval_usd | Published SBA/CDC loan amount in USD; excludes the third-party loan; not cash available or revenue; source decimal precision retained, including disclosed fractions of a cent
|
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
|
First Disbursement Date first_disbursement_date | First disbursement date if disclosed
|
Processing Method processing_method | Published 504 processing method description
|
Term Months term_months | Published loan term in months
|
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
|
Project County project_county | Project county, not necessarily borrower mailing county
|
Project State project_state | Project state, not necessarily borrower mailing state
|
SBA District Office sba_district_office | SBA district office
|
Congressional District congressional_district | Published project congressional district; keep leading zeros
|
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
|
Loan Status Source loan_status_source | Raw status label after whitespace cleanup
|
Paid In Full Date paid_in_full_date | Paid-in-full date when disclosed
|
Charge Off Date charge_off_date | Charge-off date when disclosed
|
Gross Charge Off USD gross_charge_off_usd | Published total SBA/CDC loan balance charged off; source decimal precision retained, including disclosed fractions of a cent
|
Jobs Supported Reported jobs_supported_reported | Lender-reported jobs created plus retained; not verified by SBA
|
Has Collateral Reported has_collateral_reported | Lender-reported collateral indicator
|
Record ID record_id | Source CSV SHA-256 plus data-row ordinal; not a persistent loan ID
|
Source Row Number source_row_number | One-based CSV data-row ordinal, excluding header
|
Source Snapshot source_snapshot | Immutable local raw snapshot ID
|
Approval Calendar Year approval_calendar_year | Year of approval_date, not approval_fiscal_year
|
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 Description loan_status_description | Decoded status according to the SBA source dictionary for this record's program
|
Borrower Address Group ID borrower_address_group_id | SHA-256 of conservatively normalized name/address tuple, 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
|
Identical Source Record Count identical_source_record_count | Count of identical full source rows in this year, retained as separate records
|
lenders.csv64 fields
| Field | Definition & format |
|---|---|
Lender Key lender_key | FDIC certificate, otherwise NCUA charter, otherwise SBA lender ID; no name-based merges
|
Lender Key Basis lender_key_basis | Identifier family used to group lender records
|
FDIC Certificate fdic_certificate | Canonical decimal certificate identifier, not branch ID
|
NCUA Charter ncua_charter | Canonical decimal NCUA charter (leading zeros removed) from SBA BankNCUANumber; joins exactly to NCUA CU_NUMBER. Present with an FDIC certificate only when SBA publishes both.
|
SBA Reported Lender Names sba_reported_lender_names | Distinct lender names reported by SBA for this lender key, separated by semicolons; aliases are retained.
|
SBA Lender IDs sba_lender_ids | Distinct SBA lender LocationID values grouped under this lender key, separated by semicolons.
|
SBA Lender States sba_lender_states | Distinct SBA-reported lender address state/territory codes, separated by semicolons; not borrower markets.
|
FDIC Match Status fdic_match_status | exact_certificate, no_fdic_identifier or certificate_not_found
|
FDIC Name Current Or Last Known fdic_name_current_or_last_known | FDIC-reported current or last-known institution name for the exact certificate; not necessarily the approval-year name.
|
FDIC Website Source fdic_website_source | Original FDIC WEBADDR text
|
FDIC Website URL Current fdic_website_url_current | FDIC-reported institution website, with scheme added when absent; not independently verified
|
FDIC Active At Retrieval fdic_active_at_retrieval | FDIC ACTIVE at current retrieval; not historical fiscal-year activity
|
FDIC Hq Address fdic_hq_address | FDIC institution headquarters street address from the current/last-known reference; not an SBA borrower address.
|
FDIC Hq City fdic_hq_city | FDIC institution headquarters city from the current/last-known reference.
|
FDIC Hq State fdic_hq_state | FDIC institution headquarters state/territory from the current/last-known reference; blank for unmatched lenders.
|
FDIC Hq ZIP fdic_hq_zip | FDIC institution headquarters postal code retained as text; not independently deliverability-verified.
|
FDIC LEI fdic_lei | Original FDIC LEI text; retained even when malformed
|
FDIC LEI Normalized fdic_lei_normalized | Uppercase, whitespace-trimmed LEI; original retained in fdic_lei
|
FDIC LEI Validation Status fdic_lei_validation_status | source_missing, invalid_format, invalid_checksum, or format_checksum_passed; checksum does not verify registration or entity identity
|
FDIC RSSD ID fdic_rssd_id | Federal Reserve RSSD institution identifier reported by FDIC; text identifier, not a numeric measure.
|
FDIC Holding Company fdic_holding_company | FDIC-reported holding-company name, when available.
|
FDIC Holding Company RSSD fdic_holding_company_rssd | Federal Reserve RSSD identifier for the FDIC-reported holding company; keep as text.
|
FDIC Record Run Date fdic_record_run_date | Run date for current/last-known institution reference
|
SBA Source As Of sba_source_as_of | SBA attribution/status snapshot date, not original loan approval date
|
NCUA Match Status ncua_match_status | exact_charter when the lender's NCUA charter is in the latest captured NCUA Call Report quarter; charter_not_found when it is not (for example after a merger, liquidation or charter conversion); no_ncua_identifier when SBA publishes no NCUA charter for the lender.
|
NCUA Name Current ncua_name_current | Credit union name in the latest captured NCUA Call Report quarter for the exact charter. NCUA's short form: at most 35 characters and usually without "Credit Union" or "Federal Credit Union". Not necessarily the approval-year name.
|
NCUA Main Office Address ncua_main_office_address | Physical street address of the site NCUA flags as the main office in the latest captured quarter; source-preserving text, not a certified postal address. Blank when unmatched or when no main office is listed.
|
NCUA Main Office Address Line 2 ncua_main_office_address_line2 | Second physical address line of the NCUA main office, such as a suite, when published.
|
NCUA Main Office City ncua_main_office_city | Physical city of the NCUA main office in the latest captured quarter.
|
NCUA Main Office State ncua_main_office_state | Physical state/territory of the NCUA main office in the latest captured quarter.
|
NCUA Main Office ZIP ncua_main_office_zip | Physical ZIP code of the NCUA main office, retained as published text; not independently deliverability-verified.
|
NCUA Phone Source ncua_phone_source | Credit union telephone number reported in the latest captured NCUA Call Report (FS220D), as published; reachability not verified.
|
NCUA Phone E164 ncua_phone_e164 | ncua_phone_source formatted as +1 E.164 when it has valid NANP syntax, otherwise blank; any extension stays in ncua_phone_extension. Not reachability-verified.
|
NCUA Phone Extension ncua_phone_extension | Telephone extension reported with the NCUA telephone number, when any.
|
NCUA Website Source ncua_website_source | Original website text from NCUA Call Report account 891 in the latest captured quarter.
|
NCUA Website URL Current ncua_website_url_current | NCUA-reported website with the published scheme when it is one syntactically valid HTTP(S) URL; scheme and host case normalized, otherwise blank. No scheme is added. Not independently verified.
|
NCUA Current Cycle Date ncua_current_cycle_date | Quarter-end cycle date of the NCUA Call Report supplying the current name, address, phone and website.
|
Fiscal Years fiscal_years | Fiscal years with at least one approval for this lender
|
First Fiscal Year first_fiscal_year | First fiscal year with an approval, October 1 through September 30
|
Last Fiscal Year last_fiscal_year | Last fiscal year with an approval, October 1 through September 30
|
Approval Record Count approval_record_count | Published 7(a) loan rows attributed to this lender across all fiscal years in this product; all statuses
|
Gross Approval USD All Statuses gross_approval_usd_all_statuses | Sum of published gross approvals including cancelled and undisbursed records; source precision preserved across all fiscal years in this product
|
SBA Guaranteed Approval USD All Statuses sba_guaranteed_approval_usd_all_statuses | Sum of SBA guarantees, preserving any fractional-cent source values across all fiscal years in this product
|
Gross Approval USD Excluding Cancelled gross_approval_usd_excluding_cancelled | Gross approvals excluding CANCLD only; still includes undisbursed records
|
Cancelled Record Count cancelled_record_count | Number of approval records with normalized SBA status CANCLD; retained in all-status totals.
|
Undisbursed Record Count undisbursed_record_count | Number of approval records with normalized SBA status COMMIT (committed/undisbursed).
|
Exempt Record Count exempt_record_count | Number of records with SBA status EXEMPT (disclosure exemption); not a loan performance or credit rating.
|
Paid In Full Record Count paid_in_full_record_count | Number of approval records with normalized SBA status PIF at the source snapshot date.
|
Charged Off Record Count charged_off_record_count | Number of approval records with normalized SBA status CHGOFF at the source snapshot date.
|
Borrower Address Group Count borrower_address_group_count | Distinct conservative name/address groups across all fiscal years in this product, not verified legal companies
|
Borrower State Count borrower_state_count | Distinct nonblank borrower state/territory codes across all fiscal years in this product
|
Industry Code Count industry_code_count | Distinct nonblank industry codes across all fiscal years in this product
|
Latest FY End Financial Match Status latest_fy_end_financial_match_status | exact_certificate_and_date or no_matching_report (last fiscal year in which this lender had an approval)
|
Latest FDIC Financial Report Date latest_fdic_financial_report_date | Explicit September 30 date of the joined financial record (last fiscal year in which this lender had an approval)
|
Latest FY End Reported Bank Name latest_fy_end_reported_bank_name | Institution name on the FDIC September 30 financial report for this fiscal year. (last fiscal year in which this lender had an approval)
|
Latest FY End Assets USD latest_fy_end_assets_usd | FDIC ASSET at September 30 multiplied by 1,000; original unit is thousands of USD (last fiscal year in which this lender had an approval)
|
Latest FY End Deposits USD latest_fy_end_deposits_usd | FDIC DEP at September 30 multiplied by 1,000 (last fiscal year in which this lender had an approval)
|
Latest FY End Domestic Offices latest_fy_end_domestic_offices | FDIC OFFDOM reported at fiscal-year-end date (last fiscal year in which this lender had an approval)
|
Latest NCUA FY End Financial Match Status latest_ncua_fy_end_financial_match_status | exact_charter_and_date when the NCUA September 30 Call Report for this fiscal year contains the exact charter; otherwise no_matching_report, including charters first issued after that quarter. (last fiscal year in which this lender had an approval)
|
Latest NCUA FY End Report Date latest_ncua_fy_end_report_date | Explicit September 30 cycle date of the joined NCUA Call Report. (last fiscal year in which this lender had an approval)
|
Latest NCUA FY End Reported Name latest_ncua_fy_end_reported_name | Credit union name in the NCUA September 30 Call Report for this fiscal year. (last fiscal year in which this lender had an approval)
|
Latest NCUA FY End Assets USD latest_ncua_fy_end_assets_usd | NCUA account 010, total assets, at September 30; NCUA reports whole US dollars, so no unit conversion is applied. (last fiscal year in which this lender had an approval)
|
Latest NCUA FY End Shares And Deposits USD latest_ncua_fy_end_shares_and_deposits_usd | NCUA account 018, total member and nonmember shares and deposits, at September 30, in whole US dollars. (last fiscal year in which this lender had an approval)
|
Latest NCUA FY End Members latest_ncua_fy_end_members | NCUA account 083, number of current members (not accounts), at September 30. (last fiscal year in which this lender had an approval)
|
lender_fiscal_years.csv62 fields
| Field | Definition & format |
|---|---|
Fiscal Year fiscal_year | Approval fiscal year, October 1 through September 30
|
Lender Key lender_key | FDIC certificate, otherwise NCUA charter, otherwise SBA lender ID; no name-based merges
|
Lender Key Basis lender_key_basis | Identifier family used to group lender records
|
FDIC Certificate fdic_certificate | Canonical decimal certificate identifier, not branch ID
|
NCUA Charter ncua_charter | Canonical decimal NCUA charter (leading zeros removed) from SBA BankNCUANumber; joins exactly to NCUA CU_NUMBER. Present with an FDIC certificate only when SBA publishes both.
|
SBA Reported Lender Names sba_reported_lender_names | Distinct lender names reported by SBA for this lender key, separated by semicolons; aliases are retained.
|
SBA Lender IDs sba_lender_ids | Distinct SBA lender LocationID values grouped under this lender key, separated by semicolons.
|
SBA Lender States sba_lender_states | Distinct SBA-reported lender address state/territory codes, separated by semicolons; not borrower markets.
|
Approval Record Count approval_record_count | Published loan rows attributed to this lender at SBA snapshot date; all statuses
|
Borrower Address Group Count borrower_address_group_count | Distinct conservative name/address tuples, not verified legal companies
|
Gross Approval USD All Statuses gross_approval_usd_all_statuses | Sum of published gross approvals including cancelled and undisbursed records; source precision preserved
|
SBA Guaranteed Approval USD All Statuses sba_guaranteed_approval_usd_all_statuses | Sum of SBA guarantees, preserving any fractional-cent source values
|
Gross Approval USD Excluding Cancelled gross_approval_usd_excluding_cancelled | Gross approvals excluding CANCLD only; still includes undisbursed records
|
Cancelled Record Count cancelled_record_count | Number of approval records with normalized SBA status CANCLD; retained in all-status totals.
|
Undisbursed Record Count undisbursed_record_count | Number of approval records with normalized SBA status COMMIT (committed/undisbursed).
|
Exempt Record Count exempt_record_count | Number of records with SBA status EXEMPT (disclosure exemption); not a loan performance or credit rating.
|
Paid In Full Record Count paid_in_full_record_count | Number of approval records with normalized SBA status PIF at the source snapshot date.
|
Charged Off Record Count charged_off_record_count | Number of approval records with normalized SBA status CHGOFF at the source snapshot date.
|
Borrower State Count borrower_state_count | Count of distinct nonblank borrower state/territory codes in this lender cohort.
|
Industry Code Count industry_code_count | Count of distinct nonblank published NAICS codes in this lender cohort.
|
FDIC Match Status fdic_match_status | exact_certificate, no_fdic_identifier or certificate_not_found
|
FDIC Name Current Or Last Known fdic_name_current_or_last_known | FDIC-reported current or last-known institution name for the exact certificate; not necessarily the approval-year name.
|
FDIC Website Source fdic_website_source | Original FDIC WEBADDR text
|
FDIC Website URL Current fdic_website_url_current | FDIC-reported institution website, with scheme added when absent; not independently verified
|
FDIC Active At Retrieval fdic_active_at_retrieval | FDIC ACTIVE at current retrieval; not historical fiscal-year activity
|
FDIC Hq Address fdic_hq_address | FDIC institution headquarters street address from the current/last-known reference; not an SBA borrower address.
|
FDIC Hq City fdic_hq_city | FDIC institution headquarters city from the current/last-known reference.
|
FDIC Hq State fdic_hq_state | FDIC institution headquarters state/territory from the current/last-known reference; blank for unmatched lenders.
|
FDIC Hq ZIP fdic_hq_zip | FDIC institution headquarters postal code retained as text; not independently deliverability-verified.
|
FDIC LEI fdic_lei | Original FDIC LEI text; retained even when malformed
|
FDIC RSSD ID fdic_rssd_id | Federal Reserve RSSD institution identifier reported by FDIC; text identifier, not a numeric measure.
|
FDIC Holding Company fdic_holding_company | FDIC-reported holding-company name, when available.
|
FDIC Holding Company RSSD fdic_holding_company_rssd | Federal Reserve RSSD identifier for the FDIC-reported holding company; keep as text.
|
FDIC Record Run Date fdic_record_run_date | Run date for current/last-known institution reference
|
FY End Financial Match Status fy_end_financial_match_status | exact_certificate_and_date or no_matching_report
|
FDIC Financial Report Date fdic_financial_report_date | Explicit September 30 date of the joined financial record
|
FY End Reported Bank Name fy_end_reported_bank_name | Institution name on the FDIC September 30 financial report for this fiscal year.
|
FY End Assets USD fy_end_assets_usd | FDIC ASSET at September 30 multiplied by 1,000; original unit is thousands of USD
|
FY End Deposits USD fy_end_deposits_usd | FDIC DEP at September 30 multiplied by 1,000
|
FY End Domestic Offices fy_end_domestic_offices | FDIC OFFDOM reported at fiscal-year-end date
|
SBA Source As Of sba_source_as_of | SBA attribution/status snapshot date, not original loan approval date
|
FDIC LEI Normalized fdic_lei_normalized | Uppercase, whitespace-trimmed LEI; original retained in fdic_lei
|
FDIC LEI Validation Status fdic_lei_validation_status | source_missing, invalid_format, invalid_checksum, or format_checksum_passed; checksum does not verify registration or entity identity
|
NCUA Match Status ncua_match_status | exact_charter when the lender's NCUA charter is in the latest captured NCUA Call Report quarter; charter_not_found when it is not (for example after a merger, liquidation or charter conversion); no_ncua_identifier when SBA publishes no NCUA charter for the lender.
|
NCUA Name Current ncua_name_current | Credit union name in the latest captured NCUA Call Report quarter for the exact charter. NCUA's short form: at most 35 characters and usually without "Credit Union" or "Federal Credit Union". Not necessarily the approval-year name.
|
NCUA Main Office Address ncua_main_office_address | Physical street address of the site NCUA flags as the main office in the latest captured quarter; source-preserving text, not a certified postal address. Blank when unmatched or when no main office is listed.
|
NCUA Main Office Address Line 2 ncua_main_office_address_line2 | Second physical address line of the NCUA main office, such as a suite, when published.
|
NCUA Main Office City ncua_main_office_city | Physical city of the NCUA main office in the latest captured quarter.
|
NCUA Main Office State ncua_main_office_state | Physical state/territory of the NCUA main office in the latest captured quarter.
|
NCUA Main Office ZIP ncua_main_office_zip | Physical ZIP code of the NCUA main office, retained as published text; not independently deliverability-verified.
|
NCUA Phone Source ncua_phone_source | Credit union telephone number reported in the latest captured NCUA Call Report (FS220D), as published; reachability not verified.
|
NCUA Phone E164 ncua_phone_e164 | ncua_phone_source formatted as +1 E.164 when it has valid NANP syntax, otherwise blank; any extension stays in ncua_phone_extension. Not reachability-verified.
|
NCUA Phone Extension ncua_phone_extension | Telephone extension reported with the NCUA telephone number, when any.
|
NCUA Website Source ncua_website_source | Original website text from NCUA Call Report account 891 in the latest captured quarter.
|
NCUA Website URL Current ncua_website_url_current | NCUA-reported website with the published scheme when it is one syntactically valid HTTP(S) URL; scheme and host case normalized, otherwise blank. No scheme is added. Not independently verified.
|
NCUA Current Cycle Date ncua_current_cycle_date | Quarter-end cycle date of the NCUA Call Report supplying the current name, address, phone and website.
|
NCUA FY End Financial Match Status ncua_fy_end_financial_match_status | exact_charter_and_date when the NCUA September 30 Call Report for this fiscal year contains the exact charter; otherwise no_matching_report, including charters first issued after that quarter.
|
NCUA FY End Report Date ncua_fy_end_report_date | Explicit September 30 cycle date of the joined NCUA Call Report.
|
NCUA FY End Reported Name ncua_fy_end_reported_name | Credit union name in the NCUA September 30 Call Report for this fiscal year.
|
NCUA FY End Assets USD ncua_fy_end_assets_usd | NCUA account 010, total assets, at September 30; NCUA reports whole US dollars, so no unit conversion is applied.
|
NCUA FY End Shares And Deposits USD ncua_fy_end_shares_and_deposits_usd | NCUA account 018, total member and nonmember shares and deposits, at September 30, in whole US dollars.
|
NCUA FY End Members ncua_fy_end_members | NCUA account 083, number of current members (not accounts), at September 30.
|
lender_industries.csv6 fields
| Field | Definition & format |
|---|---|
Fiscal Year fiscal_year | Approval fiscal year, October 1 through September 30
|
Lender Key lender_key | FDIC certificate, otherwise NCUA charter, otherwise SBA lender ID; no name-based merges
|
NAICS Code naics_code | Published industry code; multiple NAICS vintages may exist in source
|
Source NAICS Descriptions source_naics_descriptions | Distinct descriptions attached to this lender/NAICS segment in the source, separated by semicolons; NAICS vintages may differ.
|
Approval Record Count approval_record_count | Published loan rows attributed to this lender at SBA snapshot date; all statuses
|
Gross Approval USD All Statuses gross_approval_usd_all_statuses | Sum of published gross approvals including cancelled and undisbursed records; source precision preserved
|
lender_borrower_states.csv5 fields
| Field | Definition & format |
|---|---|
Fiscal Year fiscal_year | Approval fiscal year, October 1 through September 30
|
Lender Key lender_key | FDIC certificate, otherwise NCUA charter, otherwise SBA lender ID; no name-based merges
|
Borrower State borrower_state | borrower state
|
Approval Record Count approval_record_count | Published loan rows attributed to this lender at SBA snapshot date; all statuses
|
Gross Approval USD All Statuses gross_approval_usd_all_statuses | Sum of published gross approvals including cancelled and undisbursed records; source precision preserved
|
Field coverage
Data notes
Coverage counts describe the full tables. Blank cells and empty JSON collections are excluded; zero and false are populated values. Blank cells do not mean zero or no. A populated contact field does not establish that the contact is current or verified.
- Fiscal years run October 1 through September 30; statuses and lender attributions reflect the later SBA publication, not the approval date.
- Borrower groups are exact normalized name/address groups, not EINs or verified legal companies; a business can appear under more than one address.
- 504 gross approval is the SBA-backed debenture; the third-party first-lien loan is reported separately and is blank where SBA publishes none. 504 CDCs and third-party lenders are published names, not linked to FDIC or NCUA identifiers.
- Place contacts, FDIC websites and institution details are current reference values, not contacts at the time of each loan.
- Matched does not mean manually verified; review flags and unmatched borrowers remain visible.
- Emails are limited to published shared business mailboxes such as info@; other published addresses are withheld, and no address is guessed or verified.
- Credit-union lenders are joined to NCUA Call Report data by exact charter; NCUA names are its short form, contacts are current and financials are dated September 30. An LEI checksum pass does not establish registration.
- Form 5500 and OSHA links require the same name (or core name) and address; they are not verified identity. Linked values describe the sponsor or establishment in its own filing year, not the borrower at loan approval.