CA Business Registry - SF & LA Registered Businesses

San Francisco and Los Angeles both publish their registered-business corpus as open data (city Socrata portals, free public data). This actor turns those into a queryable, charged-per-record API - for B2B sales leads, new-business intelligence, and reference checks on who is actually doing business in SF / LA.

What it covers

San Francisco (city: sf) - every registered business location, refreshed daily (~366k rows):

• Active (~126k): currently operating (location not ended + not administratively closed).
• New openings: every business has a dba_start_date - filter newSince to pull "who opened in the last N days" (SF sees ~15-30 new DBAs/day).
• Closed / administratively closed: dba_end_date + the administratively-closed flag track when businesses stopped.
• Each row: DBA + legal (ownership) name, street address, ZIP, NAICS code, license type, open date.

Los Angeles (city: la) - the current active-business set, refreshed monthly (~634k rows): business name / DBA, NAICS + description, council district, location start date.

Typical questions

• "Which businesses just opened in San Francisco?"
• "Who is doing business in ZIP 94110 / council district 10?"
• "What NAICS industries dominate this city - where should I sell?"
• "Is this company an active registered business in SF or LA?"

Low cost

From $0.001 per record - billed only for the rows you use, and each record is metered individually.

This is a live, million-row dual-city registry, not a static dump. SF republishes its full ~366k-location business register every day; LA's ~634k active set refreshes monthly. Neither city hands you "who is currently operating" - that has to be reconstructed: a business is active only when its location record carries no end date (SF also stamps ~47k closed records as administratively closed - a city closure type that, like any closure, carries an end date), so we derive active / opened-recently / closed from the raw end-date + closure-flag logic on every pull. Counts and cohorts (by NAICS, ZIP, council district) roll up on demand. You query which businesses are actually operating; the open / closed reconstruction stays on our side.

Inputs

Input	What it does
city	sf (default, daily) or la (monthly)
activeOnly	SF: on = active only (~126k); off = incl. closed records (a whole-registry pull is bounded by the $5 run cap). Default on. LA is already the active set.
newSince	SF: only DBAs started on/after YYYY-MM-DD - the new-openings feed
businessName	substring, matches DBA / business name
naics	full or prefix code (541, 531100)
zip	exact ZIP
councilDistrict	LA council district
licenseType	SF license type, substring
aggregate / groupBy	one row per group (NAICS / ZIP / council district) with a count
maxResults	cap records (default 50)

Default run = the ~50 most recently opened active SF businesses - the freshest lead-gen pull, and fast enough for Apify's daily auto-test.

Note: a run is capped at $5 of usage - a request large enough to reach it (roughly 5,000 records at the entry price) is cut off part-way, and the truncated run still reports success. For whole-corpus counts, use aggregate.

Example inputs

Who just opened in San Francisco - newSince is the daily new-registration feed.

{ "city": "sf", "newSince": "2026-09-01", "maxResults": 10 }

Everything registered at one ZIP - zip is an exact ZIP.

{ "city": "sf", "zip": "94110", "maxResults": 10 }

One industry across the city - naics takes a full code or a 2/3-digit prefix.

{ "city": "sf", "naics": "541", "maxResults": 10 }

Los Angeles council district 10 - councilDistrict is LA-only.

{ "city": "la", "councilDistrict": "10", "maxResults": 10 }

Example output

One business - businessName=Soulfloria returns the matching SF registered business:

{
 "platform": "ca-business-registry",
 "source": "ca-business-sf",
 "city": "San Francisco",
 "mode": "rows",
 "businessName": "Soulfloria Psychiatry, A Professional Nursing Corporation",
 "legalName": "Soulfloria Psychiatry, A Professional Nursing Corporation",
 "streetAddress": "220 Montgomery St Ste 600",
 "cityName": "San Francisco",
 "state": "CA",
 "zip": "94104",
 "naics": "621330",
 "naicsDescription": "",
 "licenseType": "",
 "licenseTypes": "",
 "startDate": "2026-09-14",
 "endDate": "",
 "administrativelyClosed": "",
 "active": "yes",
 "councilDistrict": "",
 "dataAsOf": "2026-09-15",
 "groupKey": "",
 "groupCount": ""
}

Source

• SF Registered Business Locations - official, daily refresh.
• LA Listing of Active Businesses - official, monthly refresh.