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.

BPAInfrastructure data BPA market

Open in Data Ask the agent

One row per: queue project x effective snapshot x fetch snapshot; Daily snapshot 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

Download: Query it in SQL, download it, or read it with an API key. Download data
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.BPA MCP API reference
HTTP endpoint: POST /api/v1/datasets/bpat_load_interconnection_queue/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

20 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`snapshot_time`	`DateTime64(6, 'UTC')`
`queue_id`	`LowCardinality(String)`
`project_name`	`Nullable(String)`
`interconnecting_entity`	`Nullable(String)`
`county`	`Nullable(String)`
`state`	`Nullable(String)`
`interconnection_location`	`Nullable(String)`
`transmission_owner`	`Nullable(String)`
`generation_type`	`Nullable(String)`
`capacity_mw`	`Nullable(Float64)`
`summer_capacity_mw`	`Nullable(Float64)`
`winter_capacity_mw`	`Nullable(Float64)`
`queue_date`	`Nullable(DateTime64(6, 'UTC'))`
`status`	`Nullable(String)`
`proposed_completion_date`	`Nullable(DateTime64(6, 'UTC'))`
`withdrawn_date`	`Nullable(DateTime64(6, 'UTC'))`
`withdrawal_comment`	`Nullable(String)`
`actual_completion_date`	`Nullable(DateTime64(6, 'UTC'))`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	snapshot_time	queue_id	project_name	interconnecting_entity	county	state	interconnection_location	transmission_owner	generation_type	capacity_mw	summer_capacity_mw	winter_capacity_mw	queue_date	status	proposed_completion_date	withdrawn_date	withdrawal_comment	actual_completion_date	ingested_at
2026-10-21 00:00:00.000000	2026-11-03 21:01:01.780886	L0714	Sappho Additional 7 MW	Public Utility District No. 1 of Clallam County	Clallam	∅	Sappho Substation	Bonneville Power Administration	∅	7	7	7	2026-10-21 00:00:00.000000	RECEIVED	2028-06-30 00:00:00.000000	∅	∅	∅	2026-11-03 21:01:07.802139
2026-10-21 00:00:00.000000	2026-11-02 21:01:07.432463	L0714	Sappho Additional 7 MW	Public Utility District No. 1 of Clallam County	Clallam	∅	Sappho Substation	Bonneville Power Administration	∅	7	7	7	2026-10-21 00:00:00.000000	RECEIVED	2028-06-30 00:00:00.000000	∅	∅	∅	2026-11-02 21:01:12.111955
2026-10-21 00:00:00.000000	2026-11-01 21:00:58.700439	L0714	Sappho Additional 7 MW	Public Utility District No. 1 of Clallam County	Clallam	∅	Sappho Substation	Bonneville Power Administration	∅	7	7	7	2026-10-21 00:00:00.000000	RECEIVED	2028-06-30 00:00:00.000000	∅	∅	∅	2026-11-01 21:01:03.984433
2026-10-21 00:00:00.000000	2026-10-31 21:01:05.952628	L0714	Sappho Additional 7 MW	Public Utility District No. 1 of Clallam County	Clallam	∅	Sappho Substation	Bonneville Power Administration	∅	7	7	7	2026-10-21 00:00:00.000000	RECEIVED	2028-06-30 00:00:00.000000	∅	∅	∅	2026-10-31 21:01:09.180471
2026-10-21 00:00:00.000000	2026-10-30 21:01:06.047397	L0714	Sappho Additional 7 MW	Public Utility District No. 1 of Clallam County	Clallam	∅	Sappho Substation	Bonneville Power Administration	∅	7	7	7	2026-10-21 00:00:00.000000	RECEIVED	2028-06-30 00:00:00.000000	∅	∅	∅	2026-10-30 21:01:10.081775
2026-10-21 00:00:00.000000	2026-10-29 21:00:59.341788	L0714	Sappho Additional 7 MW	Public Utility District No. 1 of Clallam County	Clallam	∅	Sappho Substation	Bonneville Power Administration	∅	7	7	7	2026-10-21 00:00:00.000000	RECEIVED	2028-06-30 00:00:00.000000	∅	∅	∅	2026-10-29 21:01:04.427555
2026-10-21 00:00:00.000000	2026-10-28 21:01:22.014657	L0714	Sappho Additional 7 MW	Public Utility District No. 1 of Clallam County	Clallam	∅	Sappho Substation	Bonneville Power Administration	∅	7	7	7	2026-10-21 00:00:00.000000	RECEIVED	2028-06-30 00:00:00.000000	∅	∅	∅	2026-10-28 21:01:27.838060
2026-10-09 00:00:00.000000	2026-11-03 21:01:01.780886	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-11-03 21:01:07.802139
2026-10-09 00:00:00.000000	2026-11-02 21:01:07.432463	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-11-02 21:01:12.111955
2026-10-09 00:00:00.000000	2026-11-01 21:00:58.700439	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-11-01 21:01:03.984433
2026-10-09 00:00:00.000000	2026-10-31 21:01:05.952628	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-31 21:01:09.180471
2026-10-09 00:00:00.000000	2026-10-30 21:01:06.047397	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-30 21:01:10.081775
2026-10-09 00:00:00.000000	2026-10-29 21:00:59.341788	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-29 21:01:04.427555
2026-10-09 00:00:00.000000	2026-10-28 21:01:22.014657	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-28 21:01:27.838060
2026-10-09 00:00:00.000000	2026-10-27 21:01:11.618081	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-27 21:01:15.593367
2026-10-09 00:00:00.000000	2026-10-26 21:00:57.483794	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-26 21:01:00.567026
2026-10-09 00:00:00.000000	2026-10-25 21:01:05.546959	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-25 21:01:08.330559
2026-10-09 00:00:00.000000	2026-10-24 21:01:12.382319	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-24 21:01:18.599169
2026-10-09 00:00:00.000000	2026-10-23 21:01:06.791964	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-23 21:01:09.568853
2026-10-09 00:00:00.000000	2026-10-22 21:01:08.191778	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-22 21:01:11.704826
2026-10-09 00:00:00.000000	2026-10-21 21:01:11.094862	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-21 21:01:14.585494
2026-10-09 00:00:00.000000	2026-10-20 21:01:03.348395	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-20 21:01:07.115314
2026-10-09 00:00:00.000000	2026-10-19 21:00:58.956946	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-19 21:01:02.479902
2026-10-09 00:00:00.000000	2026-10-18 21:00:56.862495	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-18 21:01:00.297283
2026-10-09 00:00:00.000000	2026-10-17 21:01:09.428091	L0713	WPUD Sub 4	Public Utility District No. 1 of Whatcom County	Whatcom	∅	Bellingham-Refinery 115 kV line	Bonneville Power Administration	∅	1	1	1	2026-10-09 00:00:00.000000	RECEIVED	2028-10-14 00:00:00.000000	∅	∅	∅	2026-10-17 21:01:12.635028

Coverage

Complete: 4.9%
Gap days: 7,795
Days with data: 398

Show coverage history

Coverage: 4.9%Days with data: 398Gaps: 7,795

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

gaplessmore

Related data

Related infrastructure data
Dataset	Description
BPA Anemometer TowersBPA · daily	BPA's anemometer towers with coordinates, elevation and sensor heights, active and retired.
BPA Interconnection QueueBPA · daily snapshot	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. 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.
Advanced MetersEIA · annual (report year)	EIA-861 advanced metering: AMR, AMI and other meter counts, AMI energy served and customer access, by utility and customer class. Advanced_Meters, one row per utility, state, balancing authority and customer class. customer_class is residential, commercial, industrial, transportation (direct_connected in the distributed generation tables) or EIA's own total, so summing classes without excluding total counts everything twice. event_time is 1 January of the report year. release is final or early_release: EIA posts an early release of a year in August and replaces it with the final file in the autumn, and the mirror keeps the newest row per key. A key cell EIA leaves blank is '' or 0, and duplicate_index numbers rows that still share a key, in workbook order.
AESO Asset ListAESO · daily snapshot	AESO's registry of market assets: asset code, name, pool participant, operating status and asset type (source, sink and others), including retired assets.