BPA Interconnection Queue

BPA's public large-generator interconnection queue, with requested capacity, technology, county and state, proposed point of interconnection, BPA's status, and agreed in-service dates.

Native record
queue project x effective snapshot x fetch snapshot
daily snapshot publication cadence
Evidence
Reference data
Stable context used to interpret other datasets
Time basis
Point-in-time records
UTC · event_time

Overview

Each posting is a snapshot: current totals must use one latest snapshot, and requested queue MW is not operating capacity, available transmission headroom, completed study work, or evidence that a project will be built. BPA runs line and load requests as a separate queue, held in interconnection_queue.bpat_load.

Query contract

For current project state, select the maximum snapshot_time first, then preserve one row per queue_id. Keep older snapshots only for explicit history-of-status analysis.

Analysis rules

  • Never sum capacity across snapshots; aggregate only the canonical project rows from one snapshot.
  • Separate active, completed/in-service, and withdrawn statuses before totaling requested capacity.

Interpretation

  • Queue MW is requested interconnection capacity, not installed, operating, accredited, or likely-to-complete capacity.
  • Queue status and proposed completion dates do not establish available headroom, study outcome, approval, or construction probability.

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/bpat_interconnection_queue/query

Schema20

Column
Type
event_timeDateTime64(6, 'UTC')
snapshot_timeDateTime64(6, 'UTC')
queue_idLowCardinality(String)
project_nameNullable(String)
interconnecting_entityNullable(String)
countyNullable(String)
stateNullable(String)
interconnection_locationNullable(String)
transmission_ownerNullable(String)
generation_typeNullable(String)
capacity_mwNullable(Float64)
summer_capacity_mwNullable(Float64)
winter_capacity_mwNullable(Float64)
queue_dateNullable(DateTime64(6, 'UTC'))
statusNullable(String)
proposed_completion_dateNullable(DateTime64(6, 'UTC'))
withdrawn_dateNullable(DateTime64(6, 'UTC'))
withdrawal_commentNullable(String)
actual_completion_dateNullable(DateTime64(6, 'UTC'))
ingested_atDateTime64(6, 'UTC')

Sample data

No preview available.

Coverage

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