Columbia River Dam Series Registry

The CWMS series collected into usace_nwd.project_timeseries, with project name, coordinates, unit and period of record.

USACEInfrastructure data BPA market

Query with the agent

Native record

series x registry read

daily publication cadence

Evidence

Reference data

Stable context used to interpret other datasets

Time basis

Point-in-time records

UTC · event_time

Overview

The CWMS series collected into usace_nwd.project_timeseries, with project name, coordinates, unit and period of record.

Query contract

Preserve one canonical row per (ts_id) before aggregating.

Analysis rules

Group only after preserving the declared grain: ts_id.

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.

BPA MCP API reference

HTTP endpoint

POST /api/v1/datasets/usace_nwd_timeseries_registry/query

Schema18

Column

Type

event_timeDateTime64(6, 'UTC')

ts_idString

location_idLowCardinality(String)

location_nameNullable(String)

officeLowCardinality(Nullable(String))

latitudeNullable(Float64)

longitudeNullable(Float64)

horizontal_datumLowCardinality(Nullable(String))

elevation_ftNullable(Float64)

vertical_datumLowCardinality(Nullable(String))

parameterLowCardinality(String)

parameter_typeLowCardinality(String)

ts_intervalLowCardinality(String)

ts_durationLowCardinality(String)

versionLowCardinality(String)

unitLowCardinality(Nullable(String))

period_of_recordNullable(String)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	ts_id	location_id	location_name	office	latitude	longitude	horizontal_datum	elevation_ft	vertical_datum	parameter	parameter_type	ts_interval	ts_duration	version	unit	period_of_record	ingested_at
2026-09-19 04:26:33.605512	LOS.Flow-Spill.Ave.1Hour.1Hour.Best	LOS	Lost Creek Dam	NWP	42.67096	-122.674762	NAD83	1800	NGVD29	Flow-Spill	Ave	1Hour	1Hour	Best	cfs	(1977-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LMN.Flow-Out.Ave.~1Day.1Day.CBT-REV	LMN	Lower Monumental Lock and Dam	NWW	46.562693	-118.538371	WGS84	553	NGVD29	Flow-Out	Ave	~1Day	1Day	CBT-REV	kcfs	(1969-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOS.Flow-Out.Ave.1Hour.1Hour.Best	LOS	Lost Creek Dam	NWP	42.67096	-122.674762	NAD83	1800	NGVD29	Flow-Out	Ave	1Hour	1Hour	Best	cfs	(1977-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOS.Flow-In.Ave.~1Day.1Day.Best	LOS	Lost Creek Dam	NWP	42.67096	-122.674762	NAD83	1800	NGVD29	Flow-In	Ave	~1Day	1Day	Best	cfs	(1990-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOS.Flow-Gen.Ave.~1Day.1Day.CBT-REV	LOS	Lost Creek Dam	NWP	42.67096	-122.674762	NAD83	1800	NGVD29	Flow-Gen	Ave	~1Day	1Day	CBT-REV	cfs	(1977-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOS.Flow-Gen.Ave.1Hour.1Hour.CBT-REV	LOS	Lost Creek Dam	NWP	42.67096	-122.674762	NAD83	1800	NGVD29	Flow-Gen	Ave	1Hour	1Hour	CBT-REV	cfs	(1977-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOS.Elev-Tailwater.Ave.~1Day.1Day.Best	LOS	Lost Creek Dam	NWP	42.67096	-122.674762	NAD83	1800	NGVD29	Elev-Tailwater	Ave	~1Day	1Day	Best	FT	(1977-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOS.Elev-Forebay.Ave.~1Day.1Day.Best	LOS	Lost Creek Dam	NWP	42.67096	-122.674762	NAD83	1800	NGVD29	Elev-Forebay	Ave	~1Day	1Day	Best	FT	(1977-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Power.Total.~1Day.1Day.CBT-REV	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Power	Total	~1Day	1Day	CBT-REV	MW	(2002-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Power.Total.1Hour.1Hour.CBT-REV	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Power	Total	1Hour	1Hour	CBT-REV	MW	(2002-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Flow-Spill.Ave.~1Day.1Day.Best	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Flow-Spill	Ave	~1Day	1Day	Best	cfs	(1960-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Flow-Spill.Ave.1Hour.1Hour.Best	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Flow-Spill	Ave	1Hour	1Hour	Best	cfs	(1969-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Flow-Out.Ave.~1Day.1Day.Best	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Flow-Out	Ave	~1Day	1Day	Best	cfs	(1960-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOS.Flow-Out.Ave.~1Day.1Day.Best	LOS	Lost Creek Dam	NWP	42.67096	-122.674762	NAD83	1800	NGVD29	Flow-Out	Ave	~1Day	1Day	Best	cfs	(1977-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Flow-In.Ave.~1Day.1Day.Best	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Flow-In	Ave	~1Day	1Day	Best	cfs	(1969-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Flow-In.Ave.1Hour.6Hours.Best	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Flow-In	Ave	1Hour	6Hours	Best	cfs	(1969-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LMN.Flow-Spill.Ave.~1Day.1Day.CBT-REV	LMN	Lower Monumental Lock and Dam	NWW	46.562693	-118.538371	WGS84	553	NGVD29	Flow-Spill	Ave	~1Day	1Day	CBT-REV	kcfs	(1968-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LMN.Power.Total.1Hour.1Hour.CBT-RAW	LMN	Lower Monumental Lock and Dam	NWW	46.562693	-118.538371	WGS84	553	NGVD29	Power	Total	1Hour	1Hour	CBT-RAW	MW	(1969-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LMN.Power.Total.~1Day.1Day.CBT-RAW	LMN	Lower Monumental Lock and Dam	NWW	46.562693	-118.538371	WGS84	553	NGVD29	Power	Total	~1Day	1Day	CBT-RAW	MW	(1968-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LMN.Stor.Inst.1Hour.0.CBT-COMPUTED-REV	LMN	Lower Monumental Lock and Dam	NWW	46.562693	-118.538371	WGS84	553	NGVD29	Stor	Inst	1Hour	0	CBT-COMPUTED-REV	kaf	(1969-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LMN.Flow-Spill.Ave.1Hour.1Hour.CBT-REV	LMN	Lower Monumental Lock and Dam	NWW	46.562693	-118.538371	WGS84	553	NGVD29	Flow-Spill	Ave	1Hour	1Hour	CBT-REV	kcfs	(1969-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Elev-Forebay.Ave.~1Day.1Day.Best	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Elev-Forebay	Ave	~1Day	1Day	Best	FT	(1960-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Elev-Tailwater.Ave.~1Day.1Day.Best	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Elev-Tailwater	Ave	~1Day	1Day	Best	FT	(1960-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Flow-Gen.Ave.~1Day.1Day.CBT-REV	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Flow-Gen	Ave	~1Day	1Day	CBT-REV	cfs	(1960-2026)	2026-09-19 04:27:30.548038
2026-09-19 04:26:33.605512	LOP.Flow-In.Ave.1Hour.3Hours.Best	LOP	Lookout Point Dam	NWP	43.9151111	-122.7523611	NAD83	∅	NGVD29	Flow-In	Ave	1Hour	3Hours	Best	cfs	(1969-2026)	2026-09-19 04:27:30.548038

Coverage

100.0% complete0 gap days1 days with data

Show coverage history

Coverage: 100.0%Days with data: 1Gaps: 0

2026

gaplessmore

Related infrastructure data

Related infrastructure data
Dataset	Description
BPA Anemometer TowersBPA · daily	BPA's anemometer towers with coordinates, elevation and sensor heights, active and retired.
CAISO Interconnection QueueCAISO · monthly snapshot	CAISO's public generation interconnection queue, combining active, completed, and withdrawn projects with the proposed point of interconnection, technology, requested capacity, status, and completion dates. Each posting is a snapshot: current totals must use one latest snapshot, and requested queue MW is not operating capacity, available transmission headroom, or evidence that a project will be built.
CAISO Price LocationsCAISO · slow-moving dimension, refreshed every 6 hours	Every CAISO location that carries a price, as three columns: location_id, name, and kind. 26,632 rows — node (26,048), interface (578), zone (6). This is the dimension the CAISO price, and where applicable constraint, tables join to, and it is the one place a location's type is decided: resolve "which hubs exist", "is this a zone or a node", or "give me the readable name for this id" here rather than inferring a type from a name prefix. For CAISO, name equals location_id (the pnode name). The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.
DER Hosting Capacity by CountyNYSERDA IEDR · daily snapshot	NYSERDA Integrated Energy Data Resource (IEDR) per-county DER hosting-capacity rollup for New York State's 62 counties. Each snapshot row carries DER counts by status, feeder count, and min/max/total hosting capacity for generic DER, ESS charging, ESS discharging, and EV load, plus county population and centroid. `county_id` is an IEDR-internal identifier, NOT a FIPS code — join to county geometry by normalized county name. Bitemporal snapshot: use ROW_NUMBER() OVER (PARTITION BY county_id ORDER BY event_time DESC) = 1 (or an equivalent argMax(..., event_time) per county_id) to get the current snapshot. ESS charging and discharging hosting capacity are asymmetric: a battery can only charge into a wire's spare import capacity, but can discharge more than the wire's rating when serving co-located load.