Dataset Puerto Rico Observed Hydropower Generation v1.0

Puerto Rico Observed Hydropower Generation

This dataset contains observed hydropower generation for hydropower facilities in the Commonwealth of Puerto Rico assembled from Energy Information Administration (EIA) data and quality-controlled.

Raw data and the processing code for producing these data are found in the pr_observed_generation repository.

Sources

Energy Information Administration (EIA)

The Energy Information Administration (EIA) collects generation and facility nameplate capacity data every year. Utilities report generation data either monthly or annually. Generation data prior to 2008 were reported on Form EIA-759 and [Forms EIA-906/920](https://www.eia.gov/electricity/data/eia923/eia906u.php). From 2008 through the present, generation data are reported on [Form EIA-923](https://www.eia.gov/electricity/data/eia923/). Nameplate capacity until 1989 were reported on Form EIA-759. Nameplate capacity from 1989 through the present are reported on Form EIA-860.

Reporting Frequency

In the EIA monthly generation data (in the `data/processed` directory), a 'freq' column is used to indicate data reporting frequency. This flag is consistent with reporting frequency on EIA forms, but modified in some instance for consistency.

Flag — Description

M — data reported monthly

A — data reported annually

AM — data reported monthly and annually

AM/A — data reported monthly and annually

NR — reporting frequency not indicated (a)

(a) even though not all EIA forms report frequency prior to 1996, they are given a 'M' reporting flag as EIA states that reporting was done monthly

Monthly data are aggregated to annual data and used if annual data are not available for that year and plant for that data source.

Data Files

The final generation datasets containing the highest-ranked data source passing QA/QC checks are found in -

File — Description

generation_pr_annual_final.csv — compiled and qa/qc'd annual generation data

generation_pr_monthly_final.csv — compiled and qa/qc'd monthly generation data

Data Structure

The annual generation file has the following structure -

Column — Description

EIA_ID — Energy Information Administration plant ID
PtName — Existing Hydropower Assets plant name
year — year
generation_mwh — generation in MWh
source — data source (reported as source dataset and it's data source if not reported directly e.g. AES compiles data from EIA, )
type — net or gross generation
quality_flag — QA/QC flags (see below)

The monthly generation file has the same structure, with the addition of a 'month' column.

Data QA/QC Flags

Flag — Description

A — acceptable
N — generation is < 0 MWh
R — generation falls outside 2 standard deviations of the long-term mean
 

Attributions

Data processing code for EIA forms were modified from code developed for RectifHyd dataset and for the RectifHydPlus dataset.