NEFDB Grid Electricity Extraction Validation Report
=====================================================
Extraction date: 2026-06-18

Output files
------------
nigeria_generation_by_fuel_latest.csv
  Rows: 2
  Data year: 2020
  Sanity – fuel total vs plant total: 0.0000% (threshold 0.1%)
  Negative/zero fuel totals: 0

disco_billed_energy_latest.csv
  Rows: 11
  Sheet used: series
  Section: ENERGY BILLED/ELECTRICITY SUPPLY (GWh), Q2 2024
  Sanity – missing expected DisCos: none
  Sanity – unrecognized DisCos: ['DISCOS']
  Sanity – duplicate normalized DisCos: 0
  Sanity – negative/zero values: 0
  Unit: GWh (read directly; no conversion applied)

plant_fuel_mapping.csv
  Rows: 30
  Unique plants: 14

Flagged values
--------------
- Generation CSV: Jebba, Kainji and Shiroro 2020 generation records have units MW or Bill.Cubic Meter and were excluded from the MWh-based fuel totals.
- Generation CSV: NESCO hydro 2020 generation (75,593.010 GWh) dominates the hydro total and looks anomalous; hydro confidence lowered to medium.
- Plant mapping: capacity_mw is not available in the source.

Confidence flags
----------------
nigeria_generation_by_fuel_latest:
  gas   high
hydro medium
disco_billed_energy_latest: high
plant_fuel_mapping: medium