Customer Data Access Programs
Energy Data Access Committee (EDAC)
Current and Prior Data Requests
| Request ID | Complete Request Received | Requestor Name | Requestor Type | Request Description | Comment | Status* | Date Closed |
|---|---|---|---|---|---|---|---|
| rn3144655839 | 01/26/2018 | San Francisco Dept. of Public Health | Local Government |
2014 - 2017 residential gas and electric usage |
Delivered via secure email on 4/12. | Completed | 03/02/2018 |
| rn1590558202 | 12/14/2017 | City of Hayward | Local Government |
Customer Class, Number of Customers, City, Zip Code, Commodity (Gas or Electricity), Month Start Day, Month End Day, Monthly Billed Usage, Heat Type. Data is aggregated to Zip Code level. |
Data delivery is complete; was re-posted at Hayward's request. Reported on 1Q18 Quarterly Notification Advice Letter. | Completed | 03/09/2018 |
| rn8700082351 | 11/29/2017 | City of Cupertino, Sustainability Div. | Local Government |
Disaggregated, randomized, and anonymized meter level gas and electric energy usage data in monthly intervals, and data flags, grouped by census block group for specified block groups. |
Data delivery is complete. Reported on 1Q18 Quarterly Notification Advice Letter. | Completed | 01/25/2018 |
| rn6806076159 | 10/17/2017 | Duke University | Academic Researcher |
2011 - 2017 annual household usage for residential customers by ZIP codes as provided by the requester, with flags for customers on Net Energy Metering rate. |
Data in work but transmission is pending completion of the Third Party Security Review. | Approved - In Progress | |
| rn1853459519 | 10/06/2017 | Energy Institute at Haas | Academic Researcher |
DR Aggregator study: 2014 - 2017 residential billing and and interval usage; participation in Community Choice Aggregation, EE and DR SmartRate programs for random sample of residential customers, and total count of customers per ZIP code |
Was available for download 11/20 and was reported 4Q17 notification letter, but system doesn't show download till Jan 2018. | Completed | 11/20/2017 |
| rn1535558943 | 08/23/2017 | Energy Institute at Haas | Academic Researcher |
Reliability study combining customer specific outage data with other customer characteristics for selected zip codes and a random, control sample. |
In progress; needs verification that existing TSR applies. | Approved - In Progress | |
| rn3011011577 | 08/10/2017 | UCD Center for Water-Energy Efficiency | Academic Researcher |
7 years historical gas billing and interval data or monthly usage if interval data not available, including premise addresses, for ZIP codes in Modesto: 95350, 95351, 95354, 95355, 95356, 95357, 95358, 95380, 95363, and 95368 |
Data posted for download on 3/16 but it is not clear that UCD downloaded. Verification is waiting till UCD POC returns in the first week of April. Reported on 1Q18 Quarterly Notification Advice Letter. | Completed | 04/04/2018 |
| rn1584608103 | 08/03/2017 | University of California Los Angeles | Academic Researcher |
Price of electricity (residential) for each zip code. Description of different rate plans if they vary Net-metering rate by zip code Usage, location, net-metering application ID and amount of credited energy for each net-metering household |
Request cancelled/withdrawn by UCLA in 2/13/2018 email. | Canceled | 02/15/2018 |
| rn3036595061 | 07/07/2017 | City of Oakland | Local Government |
2015 community gas and electric energy use, under EDRP approved aggregation |
Request was withdrawn by the requester. Industrial data did not meet 5/25 aggregation test. | Canceled | 08/03/2017 |
| rn1190652421 | 04/18/2017 | City of Berkeley | Local Government |
2013-2015 Monthly aggregated residential and non-residential electric and gas consumption by census block group or aggregated block group |
Due to privacy safeguards pursuant to CPUC D.14-05-016, some requested data was omitted. | Completed | 04/18/2017 |