Dataframe: CAISO:caiso_outages_aggregated_hourly - CAISO Outages Aggregated Hourly (Derived)#
Description#
System-wide CAISO generation outage totals at hourly resolution, split into forced (unscheduled) and planned (scheduled maintenance) curtailment. One row per hour, aggregated across the entire CAISO footprint - there is no location or generator dimension in this table.
In the project this series is the outage conditioning variable for the quanto workstream. The forced/planned split is what matters: forced outages are the channel through which weather extremes (especially cold snaps) remove supply from the grid, while planned outages reflect routine maintenance scheduling.
Data Dictionary#
interval_start_utc:
datetime64[ns]Interval start, UTC (naive).interval_end_utc:
datetime64[ns]Interval end = start + 1 hour, UTC (naive).forced_curtailment_mw:
float64System-wide forced (unscheduled) outage MW - the weather/cold-driven leg.planned_curtailment_mw:
float64System-wide planned (maintenance) outage MW.
Notes#
Granularity: one row per hour, system-wide aggregates. Only UTC timestamps are stored (naive, no timezone offset); local-time columns are not kept.
This is a derived dataset: the hourly totals are built by aggregating the generator-level CAISO Curtailed Non-Operational Generator Report, summing curtailed MW across generators and splitting by outage nature (forced vs. planned). It is rebuilt whenever the underlying generator report is updated.
Generator-level outage reasons (needed to identify specifically weather-driven outages) are not in this table - see the
caiso_curtailed_non_operational_generator_reportdataset.
Data Preview#
Rows: 45,479 Â |Â Columns: 4 Â |Â Cache: data/opensource/caiso_outages_aggregated_hourly_derived.parquet
Sample rows#
First and latest 5 rows by interval_start_utc.
interval_start_utc |
interval_end_utc |
forced_curtailment_mw |
planned_curtailment_mw |
|---|---|---|---|
2021-06-17 07:00 |
2021-06-17 08:00 |
10207.77 |
3293.86 |
2021-06-17 08:00 |
2021-06-17 09:00 |
11301.09 |
3657.56 |
2021-06-17 09:00 |
2021-06-17 10:00 |
13456.89 |
3622.32 |
2021-06-17 10:00 |
2021-06-17 11:00 |
12960.05 |
3638.32 |
2021-06-17 11:00 |
2021-06-17 12:00 |
11380.77 |
3593.56 |
… |
… |
… |
… |
2026-08-26 02:00 |
2026-08-26 03:00 |
17531.84 |
1980.37 |
2026-08-26 03:00 |
2026-08-26 04:00 |
17635.0 |
1980.37 |
2026-08-26 04:00 |
2026-08-26 05:00 |
17120.31 |
2430.37 |
2026-08-26 05:00 |
2026-08-26 06:00 |
16905.45 |
2430.37 |
2026-08-26 06:00 |
2026-08-26 07:00 |
16226.01 |
2430.37 |
Column summary#
Column |
Dtype |
Nulls |
Min |
Max |
|---|---|---|---|---|
|
|
0 |
2021-06-17 07:00 |
2026-08-26 06:00 |
|
|
0 |
2021-06-17 08:00 |
2026-08-26 07:00 |
|
|
0 |
4816.37 |
34001.45 |
|
|
0 |
817.34 |
16411.39 |
DataFrame Glimpse#
Rows: 45479
Columns: 4
$ interval_start_utc <datetime[μs]> 2026-08-26 06:00:00
$ interval_end_utc <datetime[μs]> 2026-08-26 07:00:00
$ forced_curtailment_mw <f64> 16226.01
$ planned_curtailment_mw <f64> 2430.37
Dataframe Manifest#
Dataframe Name |
CAISO Outages Aggregated Hourly (Derived) |
|---|---|
Dataframe ID |
|
Data Sources |
Derived from caiso_curtailed_non_operational_generator_report |
Data Providers |
This Project |
Links to Providers |
|
Topic Tags |
Outages, Derived, Quanto |
Type of Data Access |
|
How is data pulled? |
Computed by src/pulls/derive_caiso_outages_aggregated_hourly.py |
Data available up to (min) |
N/A |
Data available up to (max) |
N/A |
Dataframe Path |
data\opensource\caiso_outages_aggregated_hourly_derived.parquet |
Linked Charts:
None
Pipeline Manifest#
Pipeline Name |
Project-Lab-Energy-Weather-Natgas-Quanto-CAISO |
|---|---|
Pipeline ID |
|
Lead Pipeline Developer |
Brian Nguyen |
Contributors |
Brian Nguyen, Claire Kim |
Git Repo URL |
|
Pipeline Web Page |
|
Date of Last Code Update |
2026-08-27 10:08:05 |
OS Compatibility |
Windows, Linux, macOS |
Linked Dataframes |
CAISO:caiso_lmp_day_ahead_hourly |
Build Commands:
doit