SBA Loan Data Scraper — 7(a) & 504 FOIA Records

Extract SBA 7(a) and SBA 504 loan approval records from the U.S. Small Business Administration's public FOIA data portal (data.sba.gov). Each record is a real business that received an SBA-guaranteed loan, complete with borrower name, address, loan amount, lender, NAICS industry code, approval date, and loan status.

This dataset is a B2B lead-generation goldmine: every record is a verified small business that successfully secured financing. Perfect for business lenders, equipment financiers, insurance providers, and any B2B sales team targeting recently-funded companies.

Features

• Both loan programs: Extract SBA 7(a) general business loans or SBA 504 fixed-asset loans
• Filter by state: Target borrowers in a specific state (e.g., only California or Texas businesses)
• Filter by NAICS industry code: Narrow to construction (23), food service (72), healthcare (62), or any specific industry sector
• Filter by minimum loan amount: Find larger deals — e.g., only loans above $500,000
• Filter by fiscal year: Focus on recently approved loans (SBA fiscal years run Oct 1 – Sep 30)
• Stream-parsed for large files: Handles SBA's multi-hundred-thousand-row CSV files without memory issues
• Respects result caps: Stops streaming once maxResults is reached — no wasted compute

Extracted Data Fields

Field	Description
borrowerName	Legal business name of the borrower
borrowerStreet	Street address of the borrower
borrowerCity	City of the borrower
borrowerState	2-letter state abbreviation
borrowerZip	ZIP code
lenderName	Name of the approving bank/lender
lenderState	State of the lender
grossApproval	Total approved loan amount in dollars
sbaGuaranteedApproval	SBA-guaranteed portion of the loan
approvalDate	Date the loan was approved
approvalFiscalYear	SBA fiscal year of approval
naicsCode	6-digit NAICS industry code
naicsDescription	Industry description (e.g., "Restaurants and Other Eating Places")
businessType	Business entity type (LLC, Corporation, Sole Proprietorship, etc.)
businessAge	Age of business at time of application
loanStatus	Current status (Paid In Full, Charged Off, Exempt, etc.)
termMonths	Loan term in months
jobsSupported	Number of jobs supported by the loan
projectState	State where the project is located
sbaDistrictOffice	SBA district office that processed the loan
program	Loan program (7AGENERAL, 7ASMALL, 504, etc.)
firstDisbursementDate	Date of first disbursement
paidInFullDate	Date loan was paid in full (if applicable)

How to Scrape SBA Loan Data

Step 1: Open the Actor Input

In the Apify Console, navigate to the Actor's Input tab. You'll see a form with the following options:

• Loan Program: Choose 7a (general business loans) or 504 (fixed-asset loans for major equipment and real estate)
• Borrower State: Enter a 2-letter state code to filter geographically (e.g., TX for Texas)
• NAICS Code Prefix: Enter industry digits, e.g., 72 for Food Service, 23 for Construction, 62 for Healthcare
• Minimum Loan Amount: Set a dollar floor, e.g., 250000 for loans over $250K
• Approval Fiscal Year (on or after): Default is 2023 — recent loans only
• Max Results: Default 500 — increase for bulk exports up to 1,000,000

Step 2: Run the Actor

Click Start. The Actor will:

1. Query the SBA CKAN API to discover the current CSV file URL (filenames change quarterly as SBA updates the "as-of" date)
2. Stream-download the CSV directly to disk
3. Filter rows in real time according to your inputs
4. Push matched records to the Apify dataset

Step 3: Download Your Data

When the run completes, click Export to download results as JSON, CSV, or Excel. You can also integrate via the Apify API to pull data into your CRM, data warehouse, or marketing automation platform.

Input Example

{
    "program": "7a",
    "state": "TX",
    "naicsPrefix": "72",
    "minLoanAmount": 100000,
    "approvalFyAfter": 2024,
    "maxResults": 1000
}

Output Example

{
    "borrowerName": "SUNSHINE HOSPITALITY LLC",
    "borrowerStreet": "1234 MAIN ST",
    "borrowerCity": "HOUSTON",
    "borrowerState": "TX",
    "borrowerZip": "77001",
    "lenderName": "JPMORGAN CHASE BANK, NATIONAL ASSOCIATION",
    "lenderState": "OH",
    "grossApproval": 350000,
    "sbaGuaranteedApproval": 297500,
    "approvalDate": "2024-02-15",
    "approvalFiscalYear": 2024,
    "naicsCode": "722511",
    "naicsDescription": "Full-Service Restaurants",
    "businessType": "Limited Liability Company(LLC)",
    "businessAge": "Existing or more than 2 years old",
    "loanStatus": "Disbursed Current",
    "termMonths": 120,
    "jobsSupported": 12,
    "program": "7AGENERAL",
    "projectState": "TX",
    "sbaDistrictOffice": "Houston",
    "asofDate": "2026-03-31"
}

Pricing

This Actor uses per-result pricing at $0.003 per record extracted. You also pay standard Apify compute costs (approximately $0.004–0.008 per run for typical 500-record extracts).

Estimated cost examples:

• 500 records (default): ~$0.0015 in actor fees + ~$0.005 compute = ~$0.007 total
• 5,000 records: ~$0.015 in actor fees + ~$0.01 compute = ~$0.025 total
• 50,000 records: ~$0.15 in actor fees + ~$0.02 compute = ~$0.17 total

FAQ

How often is the data updated? SBA updates the FOIA CSVs quarterly (the "as-of" date in the filename changes). This Actor automatically discovers the current file URL at runtime — no need to update the Actor between quarterly releases.

What is the SBA 7(a) vs. 504 program? 7(a) is the SBA's flagship general-purpose loan program for working capital, equipment, and real estate. 504 loans are for major fixed assets like commercial real estate and large equipment purchases. Both programs report detailed borrower and lender data.

Can I get historical data going back to the 1990s? Yes — the SBA publishes CSVs for each decade. Set approvalFyAfter to 0 (or a low year) and the Actor will process earlier records. Note that historical files are large; increase maxResults and expect longer runtimes.

Why default to FY2023? The default fiscal year filter keeps empty-input test runs fast (a few hundred thousand rows vs. millions). For bulk historical pulls, lower the threshold.

Is this data public? Yes. This dataset is released by the SBA under FOIA (Freedom of Information Act) as government open data. It contains business-loan records for verified commercial borrowers, not personal consumer data.

Legal Disclaimer

This Actor extracts publicly available data from the U.S. Small Business Administration's FOIA data portal (data.sba.gov), a U.S. federal government open data resource. The data is released under the federal government's open data policy and contains business-loan records (not personal consumer information).

Users are responsible for ensuring their use of the extracted data complies with applicable laws, including but not limited to anti-spam regulations (CAN-SPAM, CASL, GDPR) when using data for outreach. Contact support@apify.com with questions about compliance.

This tool is provided for research, business intelligence, and lead-generation purposes. It does not circumvent any authentication, CAPTCHA, or security measures — the SBA FOIA portal is fully public and provides direct CSV downloads.