ECCC Real-Time Hydrometric (Columbia)

Real-time water level and discharge at Canadian Columbia basin gauges, including the Columbia River Treaty reservoirs.

ECCCHydrology data BPA market

Open in Data Ask the agent

One row per: station x time; 5-minute 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_number, event_time) before aggregating.
Analysis rules: Level (m) and discharge (m3/s) are separate columns; lake gauges report level only.
Interpretation: Attribution to ECCC and the contributing agency is required.

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

Schema

8 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`station_number`	`LowCardinality(String)`
`lst_utc_offset`	`Nullable(String)`
`level`	`Nullable(Float64)`
`level_symbol`	`Nullable(String)`
`discharge`	`Nullable(Float64)`
`discharge_symbol`	`Nullable(String)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	station_number	lst_utc_offset	level	level_symbol	discharge	discharge_symbol	ingested_at
2026-11-03 14:45:00.000000	08NH127	-08:00	571.345	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:45:00.000000	08NH064	-08:00	531.292	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:45:00.000000	08NJ013	-08:00	0.678	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:45:00.000000	08NH118	-08:00	1.953	∅	108	∅	2026-11-03 15:20:53.614906
2026-11-03 14:45:00.000000	08NE074	-08:00	0.488	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:45:00.000000	08NE049	-08:00	3.775	∅	1380	∅	2026-11-03 15:20:53.614906
2026-11-03 14:40:00.000000	08NH064	-08:00	531.292	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:40:00.000000	08NK002	-07:00	1.606	∅	18	∅	2026-11-03 15:20:53.614906
2026-11-03 14:40:00.000000	08NH127	-08:00	571.337	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:40:00.000000	08NG065	-07:00	0.536	∅	50.2	∅	2026-11-03 15:20:53.614906
2026-11-03 14:40:00.000000	08NB005	-07:00	0.774	∅	48.2	∅	2026-11-03 15:20:53.614906
2026-11-03 14:40:00.000000	08NH118	-08:00	1.953	∅	108	∅	2026-11-03 15:20:53.614906
2026-11-03 14:40:00.000000	08NJ013	-08:00	0.678	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:40:00.000000	08ND026	-08:00	27.021	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:40:00.000000	08NE074	-08:00	0.488	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:40:00.000000	08NE049	-08:00	3.779	∅	1380	∅	2026-11-03 15:20:53.614906
2026-11-03 14:35:00.000000	08NG065	-07:00	0.535	∅	50.1	∅	2026-11-03 15:20:53.614906
2026-11-03 14:35:00.000000	08NE104	-08:00	436.501	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:35:00.000000	08NE074	-08:00	0.488	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:35:00.000000	08NH118	-08:00	1.954	∅	109	∅	2026-11-03 15:20:53.614906
2026-11-03 14:35:00.000000	08NH127	-08:00	571.338	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:35:00.000000	08NK002	-07:00	1.608	∅	18.1	∅	2026-11-03 15:20:53.614906
2026-11-03 14:35:00.000000	08NE049	-08:00	3.779	∅	1380	∅	2026-11-03 15:20:53.614906
2026-11-03 14:35:00.000000	08NB017	-07:00	747.9	∅	∅	∅	2026-11-03 15:20:53.614906
2026-11-03 14:35:00.000000	08NB005	-07:00	0.773	∅	48.2	∅	2026-11-03 15:20:53.614906

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 75

Show coverage history

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

2026

gaplessmore

Related data

Related hydrology data
Dataset	Description
ECCC Daily Mean Hydrometric (Columbia)ECCC · daily	HYDAT daily mean level and discharge for Canadian Columbia basin gauges and reservoirs, back to 1903.
Columbia Fish Passage Plans and Spill-Cap ReportsUSACE · daily revision check	Columbia fish-passage plans, change forms and spill-cap reports with plan years, content revisions, URLs and PDF page/chunk references. Evidence for published requirements and stated validity.
CONAGUA Daily Reservoir, River and Climate MeasurementsCONAGUA · daily observations, refreshed four times a day in rotation	CONAGUA's daily station measurements: reservoir level, stored volume, outflow and spill; river discharge; rainfall, evaporation, temperatures, pressure and humidity. Some stations reach back to the 1920s.
CONAGUA Hydrometric and Climate StationsCONAGUA · catalog snapshot	CONAGUA's catalogs of reservoirs, river gauges and weather stations across Mexico, with name, coordinates, altitude, state and municipality.