BPA Line and Load Interconnection Queue

BPA's public line and load interconnection queue: requests to connect new load, or a new line, to BPA's transmission system, with the requesting utility or customer, county, requested MW, 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 MW is neither approved nor connected load. Generator requests are a separate queue, held in interconnection_queue.bpat.

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_load_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.