BPA Anemometer Archive

BPA's archived anemometer-network readings (wind, temperature, pressure, humidity) at 28 tower levels, 1976 to April 2018.

BPAWeather data BPA market

Open in Data Ask the agent

One row per: station level x printed time; 5-minute to hourly cadence
Evidence: Observed market data; Published observations from the named source
Time basis: Point-in-time records; UTC · event_time

Overview

Query contract: Preserve one canonical row per (station_id, event_time) before aggregating.
Analysis rules: Check time_basis: 'unstated' rows are labels, not known instants.
Interpretation: A frozen archive ending April 2018.

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/bpa_met_readings/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

18 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`station_id`	`LowCardinality(String)`
`barometric_pressure_inhg`	`Nullable(Float64)`
`relative_humidity_pct`	`Nullable(Float64)`
`temperature_f`	`Nullable(Float64)`
`wind_direction_deg`	`Nullable(Float64)`
`wind_speed_mph`	`Nullable(Float64)`
`resultant_wind_speed_mph`	`Nullable(Float64)`
`wind_direction_sd_deg`	`Nullable(Float64)`
`wind_speed_sd_mph`	`Nullable(Float64)`
`peak_speed_mph`	`Nullable(Float64)`
`peak_direction_deg`	`Nullable(Float64)`
`peak_time`	`Nullable(DateTime64(6, 'UTC'))`
`time_basis`	`LowCardinality(String)`
`timestamp_reference`	`Nullable(String)`
`data_source`	`Nullable(String)`
`source_file`	`String`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	station_id	barometric_pressure_inhg	relative_humidity_pct	temperature_f	wind_direction_deg	wind_speed_mph	resultant_wind_speed_mph	wind_direction_sd_deg	wind_speed_sd_mph	peak_speed_mph	peak_direction_deg	peak_time	time_basis	timestamp_reference	data_source	source_file	ingested_at
2018-05-01 06:55:00.000000	ButlerGradeLvl2	∅	∅	∅	215.7	26.6	∅	∅	∅	29.6	218	2018-05-01 06:59:54.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/ButlerGradeLvl2/ButlerGradeLvl2_2018_04.csv	2026-09-19 06:30:00.085314
2018-05-01 06:55:00.000000	Augspurger	27.043	1.2	-37.3	243.7	22.2	∅	∅	∅	35.3	241.6	2018-05-01 06:57:30.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/Augspurger/Augspurger_2018_04.csv	2026-09-19 06:15:49.485755
2018-05-01 06:55:00.000000	BiddleButte	28.564	94.8	45.8	253.2	7	∅	∅	∅	9.9	244.5	2018-05-01 06:57:34.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/BiddleButte/BiddleButte_2018_04.csv	2026-09-19 06:19:01.806999
2018-05-01 06:55:00.000000	ButlerGradeLvl1	28.107	74.5	44.2	211.4	25	∅	∅	∅	28.3	211.4	2018-05-01 06:56:37.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/ButlerGradeLvl1/ButlerGradeLvl1_2018_04.csv	2026-09-19 06:25:36.613706
2018-05-01 06:55:00.000000	ButlerGradeLvl3	∅	∅	∅	219.1	27.8	∅	∅	∅	30	219.3	2018-05-01 06:58:15.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/ButlerGradeLvl3/ButlerGradeLvl3_2018_04.csv	2026-09-19 06:34:07.063783
2018-05-01 06:55:00.000000	GoodnoeHillsLvl2	∅	∅	∅	264.8	28.4	∅	∅	∅	31.8	268.5	2018-05-01 06:55:10.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/GoodnoeHillsLvl2/GoodnoeHillsLvl2_2018_04.csv	2026-09-19 08:21:03.150082
2018-05-01 06:55:00.000000	KennewickLvl1	27.689	79.8	43.5	204	13.7	∅	∅	∅	16	215	2018-05-01 06:56:04.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/KennewickLvl1/KennewickLvl1_2018_04.csv	2026-09-19 08:31:17.363317
2018-05-01 06:55:00.000000	GoodnoeHillsLvl1	27.328	87.5	40.5	266.7	18.7	∅	∅	∅	25.2	267.8	2018-05-01 06:59:19.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/GoodnoeHillsLvl1/GoodnoeHillsLvl1_2018_04.csv	2026-09-19 06:48:12.282036
2018-05-01 06:55:00.000000	HoodRiver	29.491	69.6	50	252.7	7.1	∅	∅	∅	12.7	255.5	2018-05-01 06:59:14.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/HoodRiver/HoodRiver_2018_04.csv	2026-09-19 08:23:16.904741
2018-05-01 06:55:00.000000	HorseHeaven	29.472	68.1	48.6	237.3	9	∅	∅	∅	11.6	244.4	2018-05-01 06:57:32.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/HorseHeaven/HorseHeaven_2018_04.csv	2026-09-19 08:25:31.982847
2018-05-01 06:55:00.000000	ForestGrove	29.973	87.9	49.2	222.9	1.6	∅	∅	∅	2.6	207.2	2018-05-01 06:56:26.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/ForestGrove/ForestGrove_2018_04.csv	2026-09-19 06:42:10.561713
2018-05-01 06:55:00.000000	Megler	28.986	100	44.7	345.1	14.8	∅	∅	∅	19.1	345.8	2018-05-01 06:57:44.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/Megler/Megler_2018_04.csv	2026-09-19 08:40:11.709931
2018-05-01 06:55:00.000000	Roosevelt	28.123	70	45.4	293.9	25.9	∅	∅	∅	28	295.5	2018-05-01 06:59:04.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/Roosevelt/Roosevelt_2018_04.csv	2026-09-19 08:49:22.918092
2018-05-01 06:55:00.000000	MarysPeak	25.903	100.1	33.4	333.7	0	∅	∅	∅	0	331.6	2018-05-01 06:55:00.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/MarysPeak/MarysPeak_2018_04.csv	2026-09-19 08:37:06.093409
2018-05-01 06:55:00.000000	MtHebo	26.828	100	36.1	0.6	9.7	∅	∅	∅	14	4.9	2018-05-01 06:58:44.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/MtHebo/MtHebo_2018_04.csv	2026-09-19 08:43:15.987843
2018-05-01 06:55:00.000000	NaselleRidge	28.105	100.1	41.6	339	14	∅	∅	∅	17.4	348.1	2018-05-01 07:00:00.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/NaselleRidge/NaselleRidge_2018_04.csv	2026-09-19 08:46:20.411764
2018-05-01 06:55:00.000000	KennewickLvl2	∅	∅	∅	208.9	10.3	∅	∅	∅	12.2	215.5	2018-05-01 06:55:00.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/KennewickLvl2/KennewickLvl2_2018_04.csv	2026-09-19 08:34:01.766637
2018-05-01 06:55:00.000000	Troutdale	30.108	78.6	52.1	276.2	5.5	∅	∅	∅	7.2	276.5	2018-05-01 06:58:30.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/Troutdale/Troutdale_2018_04.csv	2026-09-19 09:19:57.261111
2018-05-01 06:55:00.000000	Wasco	27.531	75.8	43	280.3	16.9	∅	∅	∅	25.2	277.9	2018-05-01 06:57:46.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/Wasco/Wasco_2018_04.csv	2026-09-19 09:24:22.664551
2018-05-01 06:55:00.000000	SevenMileHillLvl1	28.063	76.7	44	296.6	22.4	∅	∅	∅	25.6	293.9	2018-05-01 06:59:54.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/SevenMileHillLvl1/SevenMileHillLvl1_2018_04.csv	2026-09-19 09:01:35.229062
2018-05-01 06:55:00.000000	Tillamook	30.12	18.9	45	105.8	2.3	∅	∅	∅	3.3	140.9	2018-05-01 07:00:00.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/Tillamook/Tillamook_2018_04.csv	2026-09-19 09:16:44.891679
2018-05-01 06:55:00.000000	Shaniko	26.271	77.8	36.6	225.2	1.4	∅	∅	∅	4.8	210.3	2018-05-01 06:59:40.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/Shaniko/Shaniko_2018_04.csv	2026-09-19 09:10:15.969668
2018-05-01 06:55:00.000000	Sunnyside	26.79	62.4	43.3	309.9	23	∅	∅	∅	26.3	310.5	2018-05-01 06:58:16.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/Sunnyside/Sunnyside_2018_04.csv	2026-09-19 09:13:28.426879
2018-05-01 06:55:00.000000	SevenMileHillLvl2	∅	∅	∅	291.6	24.5	∅	∅	∅	29.1	286.1	2018-05-01 06:57:54.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/SevenMileHillLvl2/SevenMileHillLvl2_2018_04.csv	2026-09-19 09:07:01.020387
2018-05-01 06:50:00.000000	BiddleButte	28.564	94.4	45.8	250.9	7.1	∅	∅	∅	9.4	257.8	2018-05-01 06:51:04.000000	UTC	beginning	5-minute averages and peaks from BPA PI Historian	Monthly/BiddleButte/BiddleButte_2018_04.csv	2026-09-19 06:19:01.806999

Coverage

Complete: 99.8%
Gap days: 26
Days with data: 15,436

Show coverage history

Coverage: 99.8%Days with data: 15,436Gaps: 26

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

1996

1995

1994

1993

1992

1991

1990

1989

1988

1987

1986

1985

1984

1983

1982

1981

1980

1979

1978

1977

1976

gaplessmore

Related data

Related weather data
Dataset	Description
High-Resolution Weather Forecast GridNOAA · 15-minute forecast grid	A sub-hourly, vintage-stamped surface weather forecast over the continental United States. Each grid cell and valid time carries air temperature, wind vectors, radiation, precipitation, pressure, and related fields from NOAA's High-Resolution Rapid Refresh model. Modeled line ratings sample this grid along each mapped route, keep the forecast issue time, and apply only lead times that pass the public validation gate; this is forecast evidence, not a measurement at the conductor.
Line Rating Weather ValidationAsk the Grid · daily validation run	Daily, leakage-safe validation of the forecast weather used by the modeled line-rating experiment. Each run scores fixed forecast lead times against realized public station temperatures, records temperature and rating-error metrics, and declares whether a lead band passes the release gate. The table contains aggregate validation results only: it does not retain station rows, operator facility ratings, restricted records, or line-level benchmark data.
Northwest 6–10 and 8–14 Day Weather OutlooksNOAA CPC · daily, retained source revisions	Official CPC 6–10/8–14 day temperature and precipitation outlooks on a 0.25-degree Northwest grid. Retains issue dates, valid windows, retrieval vintages and category probabilities; weather context, not a power-price forecast.
TVA Gauge Daily PrecipitationTVA · daily observations, collected every 6 hours	Daily incremental precipitation in inches with the source accumulation hours and raw Microsoft JSON date. Each collection rereads seven days for revisions; select the latest snapshot per gauge/date/hours for history. Explicit backfill windows are supported.