Datadory notebook

How Competitive Intel Product Teams Use Electric Utilities Data

1,744 datasets. Pick your catch. Every guide here is built on what the catalog can actually prove.

1,744 datasets. Pick your catch.

Which dataset anchors a competitor-watch stack here?

EIA Consumption & Efficiency - Electricity Surveys (RECS/CBECS/MECS) is the anchor and the slice's only primary dataset, carrying quality score 9. One bundle delivers three national surveys at three granularities: RECS samples households (18,496 in the 2020 cycle, described by 799 variables in roughly 56 MB), CBECS profiles the estimated 5.9 million US commercial buildings in its 2018 wave, and MECS covers manufacturing establishments in its 2022 cycle. Each release pairs raw microdata with aggregated estimate tables and codebooks, shipped as CSV, XLSX, SAS, PDF and ZIP.

How do you benchmark a rival's efficiency claims against CBECS?

Commercial-building benchmarks are where CI teams get the most mileage from this slice. CBECS 2018 estimates the US commercial stock at 5.9 million buildings consuming 6.8 quadrillion Btu and spending $141 billion in the reference year, published nationally and by region with building-level microdata. When a competitor pitches an HVAC, controls or lighting product with an efficiency percentage attached, you can place that percentage against the actual distribution of building characteristics and consumption the stock exhibits, then ask which segment of the 5.9 million buildings their math assumes.

Can RECS microdata power market sizing and share estimates?

Geography is the constraint to design around. RECS publishes state-level estimates only for select states and rolls everything else up to census division; CBECS and MECS stop at national and regional tables entirely. Pair the surveys with EIA State Energy Data System (SEDS), the pooled companion covering all 50 states, DC and territories back to 1960 for consumption and emissions, when a stakeholder insists on a state-by-state split.

Which records expose a rival utility's capacity moves?

When your competitive set includes utilities and IPPs rather than gadget makers, shift from the demand-side surveys to the supply-side trio pooled into this slice. EIA Form EIA-860 - Annual Electric Generator Inventory is a generator-level census of every US plant at or above 1 MW nameplate - operable, proposed and retired units with owner and utility attribution, geocoded with county, latitude/longitude, NERC region and balancing authority. It carries quality score 10, the highest in the pool, with annual files from 2001 to the 2025 early release and monthly 860M supplements since July 2015 carrying interim changes.

Because ownership percentages sit on the generator rows, a rival's development pipeline is detectable as new proposed-unit records rather than press releases, and retirements show up the same way. Between annual vintages, EIA Electric Power Monthly publishes roughly 150 XLSX tables per issue about two months behind, including generation by fuel, sector and state plus additions and retirements, while EIA Electric Power Annual bundles about 130 tables per edition with an archive back to 1994.

Where does the India coal record fit a competitor workflow?

One pooled record sits outside the United States: Ministry of Coal - India Coal Statistics, pooled in from the coal-consumable-fuels slice. It is monthly PDF reporting - a 21-page Monthly Statistics at a Glance plus ten-year statistical compilations - covering production and supplies, imports and exports, coal grades, the National Coal Index, and company-level detail for Coal India subsidiaries, NLCIL, Singareni Collieries and captive blocks.

Which competitor-signal sources rank strongest here?

Ranked by how much rival behavior each record exposes per hour of integration effort:

  1. EIA Form EIA-860 - Annual Electric Generator Inventory - quality score 10; generator-level ownership and proposed units make capacity moves documentary rather than anecdotal.
  1. EIA State Energy Data System (SEDS) - state-level coverage back to 1960 fills the geographic gap the surveys leave.
  1. EIA Electric Power Annual - roughly 130 tables per edition archived back to 1994 for structural trend context.
  1. Ministry of Coal - India Coal Statistics - monthly PDFs for India fuel-supply exposure; manual extraction required.

What does a five-step competitor-tracking loop look like?

Sequenced by how fast each step pays off, using only the six pooled records:

  1. Load the microdata once per cycle. Pull recs2020_public_v7.csv (~56 MB, 799 columns) plus the CBECS and MECS table workbooks, and archive them read-only as your reproducible baseline.
  1. Compute the benchmark library. Derive KWH-per-household and DOLLAREL distributions by housing type and census division from RECS, and building-segment baselines from CBECS 2018's 5.9-million-building universe; these become the yardsticks rivals' claims are scored against.
  1. Watch capacity, not news. Diff each Form EIA-860 vintage for new proposed generators and ownership changes at watched owners and balancing authorities; add monthly 860M supplements for interim moves.
  1. Bridge the gaps with monthly aggregates. Use Electric Power Monthly's ~150 tables for state-level generation and retail sales between waves, so a rival's growth story gets tested against the same months it claims.
  1. Re-baseline on every release. Alert when EIA publishes a new vintage, re-run steps 2 through 4, and publish revision notes - the multi-year wave structure makes stale benchmarks the single biggest failure mode in this vertical.

Pick up where this leaves off

Every one of these ships with sample rows before you commit to anything.

Electric Utilities United States national estimates

EIA Consumption & Efficiency - Electricity Surveys (RECS/CBECS/MECS)

equipment and weight machinery …+8 more

Coal & Consumable Fuels United States (all 50 states

EIA State Energy Data System (SEDS)

Independent Power Producers & Energy Traders United States - all states and territories, every plant at or…

EIA Form EIA-860 — Annual Electric Generator Inventory

Independent Power Producers & Energy Traders United States national, all fifty states and census divisions…

EIA Electric Power Monthly

Independent Power Producers & Energy Traders United States national, all states and census divisions, plus…

EIA Electric Power Annual

Coal & Consumable Fuels India - all states and coal companies: Coal India Ltd…

Ministry of Coal - India Coal Statistics

Subsidiary

Want rows instead of a pitch? Name the datasets.

API, files, or your warehouse. Daily, weekly, or hourly.

Get a sample

Questions worth asking

Can I benchmark a competitor's energy-saving claims against public data?

Yes. RECS 2020 microdata describes 18,496 households across 799 variables including kWh use and electricity expenditure, and CBECS 2018 profiles the 5.9-million-building commercial stock that consumed 6.8 quadrillion Btu and spent $141 billion. Both are commercial delivery terms, so your benchmark can ship inside a product.

How quickly do these sources reveal a rival's capacity move?

On an annual clock with monthly bridges. Form EIA-860 publishes generator-level proposed, operable and retired units yearly from 2001 to the 2025 early release, with monthly 860M supplements since July 2015, and Electric Power Monthly lands about two months behind. Survey waves themselves arrive years apart.