California PUC Rate Cases Scraper

Overview

Scrape California Public Utilities Commission (CPUC) proceeding data including rate cases, applications, and regulatory filings. Extract docket numbers, utility names, filing dates, status, and case descriptions. Supports filters (Case Type, Date From, Date To).

Features

• Search by keywords to find specific results
• Filter results by category or type
• Export data in JSON, CSV, or Excel formats
• Control output volume with configurable result limits
• Built-in proxy support for reliable data collection

Use Cases

• Track - Track federal government data releases and updates
• Build - Build datasets for policy research and analysis
• Monitor - Monitor regulatory changes and compliance requirements
• Aggregate - Aggregate public government data for transparency projects

Input Parameters

Parameter	Type	Description	Default
proceedingNumber	string	Filter by proceeding/docket number (partial match supported, e.g., 'A24' for ...
utilityName	string	Filter by utility company name (e.g., 'Pacific Gas', 'Edison', 'San Diego Gas')
caseType	string	Filter by case type prefix: A (Application), C (Complaint), R (Rulemaking), I...	``
description	string	Search keywords in case description (e.g., 'rate case', 'general rate', 'reve...
dateFrom	string	Start date filter (MM/DD/YYYY format)
dateTo	string	End date filter (MM/DD/YYYY format)
maxItems	integer	Maximum number of proceedings to scrape	100
includeDetails	boolean	Fetch additional details from individual proceeding pages (slower but more co...	false
proxyConfiguration	object	Proxy configuration for bypassing rate limits	{...}

Output Example

Each result contains structured data like this:

{
  "proceedingNumber": "LIC-2025-001",
  "caseType": "Standard",
  "utilityName": "California PUC Rate Cases Sample Item",
  "filingDate": "2025-01-15",
  "description": "Detailed description of the item...",
  "assignment": "Sample assignment",
  "status": "Active",
  "industry": "Technology",
  "category": "Standard",
  "decisionDate": "2025-01-15",
  "detailUrl": "https://example.com/item/12345",
  "source": "Sample source"
}

Pricing

This actor uses pay-per-result pricing:

• $0.001 per result
• $1.00 per 1,000 results

No monthly fees. You only pay for what you scrape. Apify Free plan includes $5/month in platform credits.

How to Run

Apify Console

1. Go to the California PUC Rate Cases Scraper actor page
2. Configure your input parameters
3. Click Start and wait for the results
4. Download data in JSON, CSV, or Excel format

API

curl -X POST "https://api.apify.com/v2/acts/fortuitous_pirate~california-puc-rate-cases/runs?token=YOUR_API_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"maxItems": 10}'

Python SDK

from apify_client import ApifyClient

client = ApifyClient("YOUR_API_TOKEN")
run = client.actor("fortuitous_pirate/california-puc-rate-cases").call(
    run_input={"maxItems": 10}
)

for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

Integration

Connect California PUC Rate Cases Scraper with your existing tools and workflows:

• API access - Programmatic access via Apify API
• Webhooks - Get notified when scraping completes
• Scheduling - Set up recurring runs on any schedule
• Zapier / Make - Connect with 5,000+ apps via Apify integrations
• Python / Node.js SDKs - Native client libraries for easy integration