Supplementary data on California power providers' rates and costs

Data on sales, costs, rates, area, rates of return and equity, and illustrative bills for power providers in California. Source data documents and cleaned tables are included.

Datasets included:
1. CCA JRC PDFs: Joint Rate Comparisons for Community Choice Aggregators, scraped from IOU website via the Wayback Machine
2. EIA 861 Tables: collected EIA Form 861 datasets and associated datacleaning code
3. POU Financial Statements: annual audited financials of LADWP and SMUD
4. Residential and Commercial Rate Source PDFs: for IOUs and POUs, source files for rate time series
5. Appendix Data Part 1 - Rates, Usage, Area, Costs:
5a: Core CPI rates
5b: Residential and Commercial Rate time series
5c: IOU rate base
5d: IOU O&M
5e: POU utility plant
5f: POU O&M
5g: CCA rate comparisons
5h: detailed IOU O&M data
5i: consolidated EIA sales data (all CA LSEs)
5j: consolidated EIA sales data with average prices (selected CA and non-CA LSEs)
5k: CCA service area calculation
5l: interstate baseline residential rate comparison
5m: extended sample of CA POUs O&M and utility plant
6. Appendix Data Part 2 - Illustrative Monthly Bills: comparisons between CCA and IOUs, with customer load shape and intermediate calculations
7. Appendix Data Part 3 - ROE and ROR: time series of rates of return and return on equity for selected IOUs
8. PUDL FERC1 Processing Code: Python code to pull latest stable PUDL dataset and extract IOU O&M data as required