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

Open in Data Ask the agent

One row per: series x registry read; Daily cadence
Evidence: Reference data; Stable context used to interpret other datasets
Time basis: Point-in-time records; UTC · event_time

Overview

Query contract: Preserve one canonical row per (ts_id) before aggregating.
Analysis rules: Group only after preserving the declared grain: ts_id.

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/usace_nwd_timeseries_registry/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')`
`ts_id`	`String`
`location_id`	`LowCardinality(String)`
`location_name`	`Nullable(String)`
`office`	`LowCardinality(Nullable(String))`
`latitude`	`Nullable(Float64)`
`longitude`	`Nullable(Float64)`
`horizontal_datum`	`LowCardinality(Nullable(String))`
`elevation_ft`	`Nullable(Float64)`
`vertical_datum`	`LowCardinality(Nullable(String))`
`parameter`	`LowCardinality(String)`
`parameter_type`	`LowCardinality(String)`
`ts_interval`	`LowCardinality(String)`
`ts_duration`	`LowCardinality(String)`
`version`	`LowCardinality(String)`
`unit`	`LowCardinality(Nullable(String))`
`period_of_record`	`Nullable(String)`
`ingested_at`	`DateTime64(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-11-03 00:26:27.343501	LOS.Power.Total.1Hour.1Hour.CBT-REV	LOS	Lost Creek Dam	NWP	42.67096	-122.674762	NAD83	1800	NGVD29	Power	Total	1Hour	1Hour	CBT-REV	MW	(2002-2026)	2026-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	LOS.Flow-Spill.Ave.~1Day.1Day.Best	LOS	Lost Creek Dam	NWP	42.67096	-122.674762	NAD83	1800	NGVD29	Flow-Spill	Ave	~1Day	1Day	Best	cfs	(1977-2026)	2026-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	LMN.Flow-Spill-Cap-Fish.Inst.~1Day.0.CENWDP-COMPUTED-TargetTDG120-PUB	LMN	Lower Monumental Lock and Dam	NWW	46.562693	-118.538371	WGS84	553	NGVD29	Flow-Spill-Cap-Fish	Inst	~1Day	0	CENWDP-COMPUTED-TargetTDG120-PUB	∅	(2019-2019)	2026-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	LMN.Flow-Spill-Cap-Fish.Inst.~1Day.0.CENWDP-COMPUTED-TargetTDG125-PUB	LMN	Lower Monumental Lock and Dam	NWW	46.562693	-118.538371	WGS84	553	NGVD29	Flow-Spill-Cap-Fish	Inst	~1Day	0	CENWDP-COMPUTED-TargetTDG125-PUB	∅	(2020-2026)	2026-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097
2026-11-03 00:26:27.343501	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-11-03 00:27:24.891097

Coverage

Complete: 33.3%
Gap days: 6
Days with data: 3

Show coverage history

Coverage: 33.3%Days with data: 3Gaps: 6

2026

gaplessmore

Related data

Related infrastructure data
Dataset	Description
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.
Alberta (AESO) Price LocationsAESO · slow-moving dimension, refreshed every 6 hours	Every Alberta (AESO) location that carries a price, as three columns: location_id, name, and kind. 1 rows — system (1). This is the dimension the Alberta (AESO) 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 Alberta, the one location_id is SYSTEM: the pool price (aeso.pool_price) and system marginal price (aeso.system_marginal_price) are system-wide and carry no location column. Alberta has no nodal, zonal or hub prices; do not look for one. Generating assets are identified by AESO asset code in aeso.unit_status and aeso.asset_list, not here. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.
Baja California (CENACE) Price LocationsBCA · slow-moving dimension, refreshed every 6 hours	Every Baja California (CENACE) location that carries a price, as three columns: location_id, name, and kind. 4 rows — zone (4). This is the dimension the Baja California (CENACE) 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 Baja California, location_id is CENACE's load zone (TIJUANA, MEXICALI, ENSENADA, SANLUIS) and joins cenace.zonal_prices.load_zone; name is the city it is named for. CENACE prices Baja California by load zone only; there are no nodes or hubs in this dimension. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.