Data

Data Sources

Below is a compilation of national (state-level) and local data that are publicly available and produced on a regular basis.

Name

Link

Notes

Format

National (state-level)

EIA Form 923 – Annual Electric Utility Data

https://www.eia.gov/electricity/data/eia923/

Electricity generation, fuel consumption, fossil fuel stocks, and receipts at the power plant and prime mover level

excel/csv

EIA Form 860 – Annual Electric Generator Data

https://www.eia.gov/electricity/data/eia860/

Existing and planned generator info

excel/csv

EIA Form 861 – Annual Electric Power Industry Report

https://www.eia.gov/electricity/data/eia861/

Peak load, generation, electric purchases, sales, revenues, customer counts and demand-side management programs, green pricing and net metering programs, and distributed generation capacity

excel/csv

EIA Electricity Data Browser

https://www.eia.gov/electricity/data/browser/

Electricity generation and consumption data (from EIA Form 923), Electricity sales data (from EIA Form 861), fuel quality and receipts (from EIA Form 923)

excel/csv

EIA Coal Data Browser

https://www.eia.gov/coal/data/browser/

 

excel/csv

EIA State Energy Database System (SEDS)

https://www.eia.gov/state/seds/

Energy production, consumption, prices, and expenditures by state

excel/csv

EIA Annual Generation

http://www.eia.gov/electricity/data/state/annual_generation_state.xls

Historical generation from 1990

excel/csv

EIA Company Level Imports

https://www.eia.gov/petroleum/imports/companylevel/

Only international

excel/csv

EIA Refinery Data

https://www.eia.gov/dnav/pet/pet_pnp_cap1_dcu_SHI_a.htm

Number and capacity of petroleum refineries

excel/csv

Emissions & Generation Resource Integrated Database (eGrid)

https://www.epa.gov/energy/emissions-generation-resource-integrated-database-egrid

Air emissions for nitrogen oxides, sulfur dioxide, carbon dioxide, methane, and nitrous oxide; emissions rates; net generation; resource mix; and many other attributes

excel/csv

FERC Form 714 – Annual Electric Balancing Authority Area
and Planning Area Report

https://www.ferc.gov/docs-filing/forms/form-714/data.asp

Electric transmitting utilities operating balancing authority areas and planning areas (with annual peak demand over 200MW) are required to electronically file Form 714, reporting among other things, balancing authority area generation, actual and scheduled inter-balancing authority area power transfers, and net energy for load, summer-winter generation peaks and system lambda.

excel/csv

Name Link Notes Format
Local
DBEDT Data Warehouse http://dbedt.hawaii.gov/economic/datawarehouse/ See Energy section. County-level, can select frequency. Petroleum/crude oil price, foreign petroleum imports, liquid fuel tax base, registered vehicles, electricity consumption (by no. of consumers, total meters, and total kWh sold), net revenue of utility companies, electricity retail prices, electricity production, fuel oil, diesel oil, and biodiesel oil used by utility companies excel/csv
DBEDT Monthly Energy Trends http://dbedt.hawaii.gov/economic/energy-trends-2/ Same data as DBEDT’s Data Warehouse, but only available as a monthly time series excel
DBEDT State of Hawaii Databook http://dbedt.hawaii.gov/economic/databook/ pdf
HSEO Hawaii Energy Statistics http://energy.hawaii.gov/resources/dashboard-statistics Energy costs as a percentage of GDP, electricity price, gasoline price, electricity production by source, petroleum use by sector, solar-related construction expenditures csv/excel
Hawaii County Data Portal https://data.uhero.hawaii.edu/coh/#/category?id=4435&geo=HI&freq=A%23id_4486 Same as DBEDT Data Warehouse csv
Aloha+ Challenge https://dashboard.hawaii.gov/aloha-challenge Clean energy; local food production and consumption solid waste reduction; smart sustainable communities; green workforce education csv/excel
Hawaiian Electric Key Performance Metrics https://www.hawaiianelectric.com/about-us/key-performance-metrics Service reliability; power supply and generation (IPP, weighted equivalent availability factor, weighted equivalent forced outage rate, weighted equivalent forced outage factor, losses and unaccounted for energy); renewable energy (RPS compliance, system RE, total RE, curtailment, NEM participants, capacity, and kWh exported); customer service; financial (ROE); safety; rates and revenues (cost of final delivered energy, contributing cost components to rates, fuel and purchased energy costs, time-of-use rate customers); emerging technologies (load and no. of events of DR programs, duration of events, energy storage amount of power) excel
Hawaiian Electric Monthly Effective rate summaries, Energy Cost Adjustment Filings (ECAF) and Avoided Energy Cost and Schedule Q Rates https://www.hawaiianelectric.com/my-account/rates-and-regulations pdf
Hawaiian Electric Quarterly Installed Solar PV https://www.hawaiianelectric.com/clean-energy-hawaii/clean-energy-facts/quarterly-installed-solar-data pdf
City & County of Honolulu Building Permits https://data.honolulu.gov/Business/Building-Permits-January-1-2005-thru-September-30-/4vab-c87q Since January 1, 2005. Includes PV, EV charger, battery storage. excel/csv
Maui County Electrical Building Permits http://www.co.maui.hi.us/1032/Download-Public-Information excel/csv
Hawaii County Electrical Building Permits http://records.co.hawaii.hi.us/weblink/Browse.aspx?dbid=1&startid=24977&cr=1 excel/csv
Renewable Energy Projects Directory https://energy.ehawaii.gov/epd/public/energy-projects-map.html excel
Hawaii Energy Facts and Figures http://energy.hawaii.gov/resources/hawaii-state-energy-office-publications pdf
PUC Annual Reports http://puc.hawaii.gov/reports/annual-reports/ pdf
NEM Annual Reports http://puc.hawaii.gov/reports/energy-reports/net-energy-metering-nem-annual-reports-electric-docket-2006-0084/ pdf
RPS Annual Reports http://puc.hawaii.gov/reports/energy-reports/renewable-portfolio-standards-rps-annual-reports/ Also includes KIUC’s annual fuel mix disclosure pdf
Renewable Energy Annual Report (Gas Company) http://puc.hawaii.gov/reports/energy-reports/ pdf
Adequacy of Supply Annual Reports http://puc.hawaii.gov/reports/energy-reports/adequacy-of-supply/ pdf
Annual Financial Reports for Electric Utilities http://puc.hawaii.gov/reports/energy-reports/annual-financial-reports-electric-utilities/ pdf
Service Quality Reliability Annual Reports http://puc.hawaii.gov/reports/energy-reports/service-quality-reliability-annual-reports/ pdf
RSWG Monthly reports https://dms.puc.hawaii.gov/dms/ Docket No. 2011-0206. Includes data on curtailment events. pdf
Weekly Interconnection reports, Interim TOU quarterly report, DER quarterly report https://dms.puc.hawaii.gov/dms/ Docket No. 2014-0192 pdf
EV Pilot Rates Report https://dms.puc.hawaii.gov/dms/ Docket No. 2016-0168 pdf
Hourly Unit Dispatch https://dms.puc.hawaii.gov/dms/ Docket No. 2017-0213, Oahu only pdf
Energy Efficiency Data https://hawaiienergy.com/about/information-reports Energy efficiency investment broken down by residential vs commercial, savings (benefits), measure savings estimates. See also Docket No. 2007-0323. pdf