Supplementary data on California power providers' rates and costs
Description
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