The portfolio dashboard, record downloads, the document library, the data dictionary and the validation rules. No account needed.
Who it is for: Everyone. Revised for CEDARS release 0.2.0; this site runs release 0.2.0 (release notes).
Everything published is open to everyone, with no account needed. Only confirmed filings are published.
First steps
- Open the portfolio dashboard, choose the years, metric and view at the top, then Apply. The page's address keeps your choices, so a copied link shows the same numbers.
- Select a row to drill down (PA, sector, program, measure). What is left out is always stated on the page.
- Download the rows you see, or the records behind them, as CSV, Excel or Parquet.
Learn more
- Record downloads: the published measure-level records, with the columns you choose.
- Saved views: save, share or ask to publish a dashboard or records view (signed in).
- Document library: PA documents, CPUC guidance, DEER resources and EM&V studies.
- Data dictionary and its change log: every field and the name CET used for it.
- Validation rules: what each filing is checked against.
- CPUC-mandated changes: decisions that change CEDARS' data or calculations.
- Metric catalog (CSV) and the open data API at
/api/v1/data/(API description).
Questions about this
- Do I need an account to read or download published data?
- Can a program read the published data without an account?
- Why is my download made in the background?
- Why do the dashboard's totals differ from a PA's own report?
Other guides
- Getting started
- Glossary
- Programs
- Budget filings and fund shifts
- Claims
- Correcting filed records
- Monthly reports
- Cost-effectiveness runs
- Keyboard and screen reader use
Still stuck? Getting support.