BPA Transmission Outages

Every outage in BPA's calendar-year outage reports (1999 onward) and Daily Interruptions Reports: customer service points, transmission lines and transformers.

Native record
report x section x outage
every 3 hours publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

Every outage in BPA's calendar-year outage reports (1999 onward) and Daily Interruptions Reports: customer service points, transmission lines and transformers.

Query contract

Preserve one canonical row per (report, section, outage_id, out_time, name) before aggregating.

Analysis rules

  • An outage appears in several reports; count distinct outage_id within one report or deduplicate across reports.

Interpretation

  • A report lists outages still open when compiled, so it holds outages that began years earlier.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

HTTP endpoint
POST /api/v1/datasets/bpa_transmission_outages/query

Schema27

Column
Type
event_timeDateTime64(6, 'UTC')
reportLowCardinality(String)
sectionLowCardinality(String)
section_titleNullable(String)
outage_idString
out_timeDateTime64(6, 'UTC')
in_timeNullable(DateTime64(6, 'UTC'))
still_outBool
nameString
line_typeNullable(String)
gen_flagNullable(String)
outage_typeNullable(String)
causeNullable(String)
field_causeNullable(String)
responsible_systemNullable(String)
responsible_system_fieldNullable(String)
districtNullable(String)
transmission_ownerNullable(String)
oms_outage_idNullable(String)
kvNullable(Float64)
kv_lowNullable(Float64)
length_milesNullable(Float64)
duration_minutesNullable(Float64)
megawatt_lossNullable(Float64)
published_atNullable(DateTime64(6, 'UTC'))
source_fileString
ingested_atDateTime64(6, 'UTC')

Sample data

No preview available.

Coverage

No time-indexed data — coverage isn’t applicable to this dataset.