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.

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

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_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-07-14 00:00:00.000000	2026-11-03 21:01:01.780886	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-11-03 21:01:04.548182
2026-07-14 00:00:00.000000	2026-11-02 21:01:07.432463	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-11-02 21:01:10.330003
2026-07-14 00:00:00.000000	2026-11-01 21:00:58.700439	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-11-01 21:01:01.054368
2026-07-14 00:00:00.000000	2026-10-31 21:01:05.952628	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-31 21:01:07.725845
2026-07-14 00:00:00.000000	2026-10-30 21:01:06.047397	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-30 21:01:07.833077
2026-07-14 00:00:00.000000	2026-10-29 21:00:59.341788	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-29 21:01:01.549588
2026-07-14 00:00:00.000000	2026-10-28 21:01:22.014657	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-28 21:01:24.862977
2026-07-14 00:00:00.000000	2026-10-27 21:01:11.618081	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-27 21:01:13.978967
2026-07-14 00:00:00.000000	2026-10-26 21:00:57.483794	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-26 21:00:59.091870
2026-07-14 00:00:00.000000	2026-10-25 21:01:05.546959	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-25 21:01:07.340541
2026-07-14 00:00:00.000000	2026-10-24 21:01:12.382319	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-24 21:01:14.648667
2026-07-14 00:00:00.000000	2026-10-23 21:01:06.791964	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-23 21:01:08.458961
2026-07-14 00:00:00.000000	2026-10-22 21:01:08.191778	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-22 21:01:10.554955
2026-07-14 00:00:00.000000	2026-10-21 21:01:11.094862	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-21 21:01:12.956099
2026-07-14 00:00:00.000000	2026-10-20 21:01:03.348395	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-20 21:01:05.800839
2026-07-14 00:00:00.000000	2026-10-19 21:00:58.956946	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-19 21:01:00.947737
2026-07-14 00:00:00.000000	2026-10-18 21:00:56.862495	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-18 21:00:58.821812
2026-07-14 00:00:00.000000	2026-10-17 21:01:09.428091	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-17 21:01:11.239206
2026-07-14 00:00:00.000000	2026-10-16 21:01:03.263403	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-16 21:01:05.512099
2026-07-14 00:00:00.000000	2026-10-15 21:01:05.086734	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-15 21:01:06.919371
2026-07-14 00:00:00.000000	2026-10-14 21:00:57.895473	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-14 21:01:00.326059
2026-07-14 00:00:00.000000	2026-10-13 21:01:05.694461	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-13 21:01:07.461537
2026-07-14 00:00:00.000000	2026-10-12 21:01:02.851217	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-12 21:01:04.409948
2026-07-14 00:00:00.000000	2026-10-11 21:00:55.954743	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-11 21:00:57.745160
2026-07-14 00:00:00.000000	2026-10-10 21:00:55.781897	G1099	∅	∅	Franklin	WA	Railroad Avenue Substation	Bonneville Power Administration	Energy Storage (Battery)	24.5	24.5	24.5	2026-07-14 00:00:00.000000	RECEIVED	2028-10-02 00:00:00.000000	∅	∅	∅	2026-10-10 21:00:57.815311

Coverage

Complete: 6.3%
Gap days: 8,927
Days with data: 605

Show coverage history

Coverage: 6.3%Days with data: 605Gaps: 8,927

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

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 Line and Load Interconnection QueueBPA · daily snapshot	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. 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.
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.