Back to packs

EIA-923 Power Plant Operations

EIA_923free

10 data-quality rules for the EIA-923 Power Plant Operations Report (generation, fuel consumption, and stocks) filed by plant operators to the US Energy Information Administration. Covers required plant/prime-mover/fuel identifiers, value-set conformance, non-negative generation and fuel, heat-content plausibility, reporting period, and duplicate suppression. Use it to validate the EIA-923 before submission.

10 rules 0 downloadsNo ratings yet
eiaeia-923energypower-plantregulatory-reporting
0.0(0 ratings)

Sign in to rate this pack

Test this pack with your data

Download the template, fill in your data, and see quality results instantly.

Test This Pack

Download & Install

Choose your tool — get a ready-to-run file

Run this on your data? Upload your CSV — we'll auto-map the columns, validate, and report the bad rows.Test my dataWant this certified on your data? Book a 30-min demo.Book a demo
Or use the CLI
$ npx dqhub install eia-923-power-plant --format soda --table YOUR_TABLE

About this pack

10 data-quality rules for the EIA-923 Power Plant Operations Report (generation, fuel consumption, and stocks) filed by plant operators to the US Energy Information Administration. Covers required plant/prime-mover/fuel identifiers, value-set conformance, non-negative generation and fuel, heat-content plausibility, reporting period, and duplicate suppression. Use it to validate the EIA-923 before submission.

What's included

3range rules
2completeness rules
2referential integrity rules
1format rules
1uniqueness rules
1consistency rules

Checks included (10)

Net Generation Is Non-Negative(net_generation_mwh)

Net generation (MWh) should not be negative except where a storage/pumped facility legitimately reports it; flag negatives for review.

Fuel Consumed Is Non-Negative(fuel_consumed)

Quantity of fuel consumed cannot be negative.

Fuel Heat Content Is Plausible(heat_content_mmbtu)

Reported fuel heat content (MMBtu per unit) must fall within a plausible band (0 to 30) to catch unit errors.

Required Identifiers Present

Each record must carry the plant id, prime mover, fuel type, and reporting period.

Reporting Period Present(report_period)

The reporting period (year-month) must be present.

Plant ID Is in the EIA Plant Registry

The plant id must exist in the EIA plant registry (EIA-860).

Fuel Type Code Is Valid

The energy source / fuel type code must be a valid EIA fuel code.

Prime Mover Code Is Valid(prime_mover)

Prime mover must be a valid EIA code (e.g. ST steam turbine, GT gas turbine, CA combined-cycle, HY hydro, WT wind, PV solar).

One Record per Plant / Prime Mover / Fuel / Period(record_key)

Generation/fuel should be reported once per plant, prime mover, fuel, and period.

Electric Fuel Does Not Exceed Total Fuel

Fuel consumed for electricity generation cannot exceed total fuel consumed.