CA Grants Portal - open California state & local grants

California publishes its whole state/local grant catalog plus who-won-what as open data (data.ca.gov, under AB 132, run by the CA State Library). This actor turns it into a queryable, charged-per-record API - great for grant writers, nonprofits, and government-relations teams hunting money that is open right now.

What it covers

• Grant opportunities - every program the portal lists, tagged with its current lifecycle status:
  • active (~169): open to apply right now. 128 of these accept applications on a rolling "Ongoing" basis; the rest have a hard application deadline.
  • forecasted (2): announced, not yet open.
  • closed (1,823): past programs - useful historical reference (agency, typical amounts, who it targeted).
  • Each row: agency, title, type (grant / loan), categories, purpose, applicant type, geography, funding source, estimated funds, open date, application deadline, grant URL, contact, and the portal's change trail (ChangeNotes + last-updated).
• Grant awards - post-award disclosures per fiscal year (2022-23 / 2023-24 / 2024-25): recipient name + type, agency, award amount, counties served, project status, and dollars used so far. Search by recipient or filter by agency / recipient type / county.
• Aggregate mode - one summary row per group (agency / status / type, or recipient type / county) with record counts per group.

Typical questions

• "Which state grants are open right now that I can apply to?"
• "Grants in water / food & nutrition / housing / tribal with a deadline in the next 60 days?"
• "Who won Housing grants last fiscal year and for how much?"
• "Which agencies run the most open grants - where's the money concentrated?"

Low cost

From $0.001 per record - a tenth of a cent, billed only for the rows you actually use, with a per-run charge cap so a broad pull can't surprise-bill.

This joins the portal's live opportunity list (open / forecasted / archived) to its post-award disclosures across three fiscal years - awards that the state files in separate tables per FY, which we union into one queryable corpus. The catalog is messier than it looks: award amounts are published as text ($360,000), deadlines as text that can literally read "Ongoing", and the underlying datastore rejects the usual SQL coercions - so filters, recency sorts and counts are built around those quirks rather than against them. You query one grants corpus - from what is open right now to who won what across three fiscal years; the FY-table unions and text-typed dates stay on our side.

Inputs (all optional except when noted)

Input	What it does
corpus	opportunities (default) or awards
status	opportunities: active (default) / forecasted / closed / all
keywords	match title/purpose/description/categories/agency
agency	agency name, substring
category	opportunities category, substring
deadlineBefore	only grants whose deadline is on/before YYYY-MM-DD
fiscalYear	awards: 2022-2023 / 2023-2024 / 2024-2025 (default newest)
recipientName / recipientType	awards filter
aggregate	return one row per group with a count instead of records
groupBy	aggregate dimension (opportunities: agency/status/type; awards: agency/recipientType/projectStatus/county)
maxResults	cap records pushed (default 200)

Default run = the active-now list (~169 grants sorted by nearest deadline) - the single most useful pull, and fast enough for Apify's daily auto-test.

Source & license

California Grants Portal open data on data.ca.gov (CA State Library, AB 132). Official public data - no login, no scraping.