Modeled Line Rating Forecasts

Hourly, vintage-stamped screening estimates for mapped transmission lines across every supported US grid.

Ask the GridInfrastructure data

Download data Open on map

Native record

ISO line x valid hour x forecast vintage x method x model version

hourly forecast, refreshed daily publication cadence

Evidence

Forecast data

Forward-looking values with an explicit issue time

In Ask the Grid

Transmission on the ERCOT map

Values for the live grid surface

Overview

Each row joins a public line-map snapshot to route-sampled forecast weather, a published owner or regional assumption profile, the validation margin, model version, and materialization run. The result is a temperature-adjusted IEEE 738 conductor estimate capped at an equipment floor fitted to ERCOT's submitted temperature/rating tables; it is not an operator facility rating or transfer limit because the public map does not provide the actual conductor, clearance, relay, transformer, or terminal-equipment limits of any facility.

Query contract

For each ISO line and valid_time, select the latest forecast_as_of available before the analysis cutoff for the requested method and model_version.

Analysis rules

Resolve one forecast vintage per ISO, line_id, valid_time, method, and model_version before aggregating.
rating_change_pct compares two modeled currents: one at the applied air temperature and one at the profile reference temperature, both subject to the fitted cap. The denominator is not a published rating of this individual facility. Reference conditions differ by profile; never sum the percentages or relabel them as transfer capacity.

Related analysis

line identity and route geometry and voltage and owner · Match line_id to the line_snapshot_time used by the model run.
primary forecast weather and route sample conditions · Match valid_time and forecast_as_of, then spatially sample the mapped route.

Interpretation

These are public-data screening estimates, not ISO or transmission-owner facility ratings, emergency ratings, dynamic line ratings, or transfer limits.
The public line map does not identify the actual conductor, clearance, relay, transformer, or terminal-equipment limit, any of which can bind below the modeled conductor estimate.

Access

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema41

Column

Type

valid_timeDateTime64(6, 'UTC')

forecast_as_ofDateTime64(6, 'UTC')

line_snapshot_timeDateTime64(6, 'UTC')

isoLowCardinality(String)

line_idLowCardinality(String)

line_nameNullable(String)

voltage_kvNullable(Float64)

methodLowCardinality(String)

model_versionLowCardinality(String)

rating_ratioFloat64

rating_change_pctFloat64

ambient_temp_cNullable(Float64)

temperature_guardband_cNullable(Float64)

applied_wind_msNullable(Float64)

applied_wind_angle_degNullable(Float64)

applied_solar_wm2Nullable(Float64)

applied_pressure_paNullable(Float64)

observed_wind_msNullable(Float64)

observed_wind_angle_degNullable(Float64)

observed_solar_wm2Nullable(Float64)

observed_pressure_paNullable(Float64)

bearing_degNullable(Float64)

limiting_lonNullable(Float64)

limiting_latNullable(Float64)

sample_countNullable(Int32)

weather_fallback_sample_countNullable(Int32)

assumption_profileLowCardinality(String)

assumption_providerLowCardinality(String)

assumption_sourceString

reference_ambient_temp_cFloat64

reference_wind_msFloat64

reference_wind_angle_degFloat64

reference_solar_wm2Float64

max_conductor_temp_cFloat64

ambient_floor_cNullable(Float64)

floor_appliedNullable(Bool)

representative_voltage_kvInt32

conductor_diameter_mFloat64

weather_sourceLowCardinality(String)

run_idString

ingested_atDateTime64(6, 'UTC')

Sample data

valid_time	forecast_as_of	line_snapshot_time	iso	line_id	line_name	voltage_kv	method	model_version	rating_ratio	ambient_temp_c	applied_wind_ms	applied_wind_angle_deg	applied_solar_wm2	applied_pressure_pa	observed_wind_ms	observed_wind_angle_deg	observed_pressure_pa	bearing_deg	limiting_lon	limiting_lat	sample_count	assumption_profile	assumption_provider	assumption_source	reference_ambient_temp_c	reference_wind_ms	reference_wind_angle_deg	reference_solar_wm2	max_conductor_temp_c	ambient_floor_c	floor_applied	representative_voltage_kv	conductor_diameter_m	weather_source	run_id	ingested_at
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-15ec49bba1193369	Moffat Substation → Lake Belton Substation	138	ambient_adjusted	ieee738-hrrr-v3	1	12.2487	0.8931	60	1000	101325	2.2627	129.6613	101325	14.3436	-97.43391	31.141412	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-15d6d39d4160a82b	Sand Lake Switching Station transmission line	138	ambient_adjusted	ieee738-hrrr-v3	1	14.3349	0.6096	90	1023.91	101325	4.3211	108.6491	101325	131.4325	-103.463804	31.509235	2	ercot-txued-public	TXUED	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.6096	90	1023.91	90	21.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-156b9a5fc3afad2e	Ballinger Substation transmission line	69	ambient_adjusted	ieee738-hrrr-v3	1	11.681	0.8931	60	1000	101325	3.2916	144.1925	101325	-121.7185	-99.944411	31.74294	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	69	0.0183	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-15692d9f4b8f16ac	Calvert Substation transmission line	69	ambient_adjusted	ieee738-hrrr-v3	1	12.1212	0.8931	60	1000	101325	2.1154	124.3428	101325	-83.6277	-96.916298	31.022178	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	69	0.0183	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-151643aba35fcb30	Salem Substation → Colorado City Substation	138	ambient_adjusted	ieee738-hrrr-v3	1	12.2494	0.8931	60	1000	101325	3.8639	161.6067	101325	-104.2513	-101.086402	32.390294	4	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-14f2d5140b154e57	Westbrook Substation transmission line	69	ambient_adjusted	ieee738-hrrr-v3	1	12.3167	0.8931	60	1000	101325	3.8515	159.508	101325	-102.8474	-101.014324	32.360148	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	69	0.0183	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-14d6bb22ce0638e2	Worsham Field Substation transmission line	138	ambient_adjusted	ieee738-hrrr-v3	1	14.7842	0.6096	90	913.67	101325	3.731	124.7242	101325	15.957	-103.334106	31.356312	2	ercot-tnp-public	TNP	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.6096	90	913.67	67.5	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-14460f91f203f300	69 kV transmission line	69	ambient_adjusted	ieee738-hrrr-v3	1	11.5805	0.8931	60	1000	101325	2.866	119.7735	101325	-122.7479	-96.398972	33.292106	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	69	0.0183	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-143e253005ff87d7	Midessa Substation → Midland West Substation	138	ambient_adjusted	ieee738-hrrr-v3	1	11.7615	0.8931	60	1000	101325	3.8897	154.831	101325	-130.1437	-102.175633	31.967124	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-1432bc903dda94f3	Midkiff Switching Station transmission line	69	ambient_adjusted	ieee738-hrrr-v3	1	12.0214	0.8931	60	1000	101325	4.5924	151.1367	101325	39.3435	-101.807018	31.521343	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	69	0.0183	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-1405c568ff1b5b97	Victoria Switching Station → Dupont Switching Station	138	ambient_adjusted	ieee738-hrrr-v3	1	15.7335	0.8931	60	1000	101325	3.0351	56.5549	101325	163.3971	-96.945905	28.693523	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-13e9de761a238d48	South Midland Substation transmission line	138	ambient_adjusted	ieee738-hrrr-v3	1	11.6787	0.8931	60	1000	101325	3.8714	156.4848	101325	-12.6954	-102.010851	31.939921	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-13cd1a89ad5debc5	Big Foot Substation → Pleasanton Substation	138	ambient_adjusted	ieee738-hrrr-v3	1	16.1236	0.8931	60	1000	101325	2.7969	90.0708	101325	-88.2705	-98.484927	28.948294	5	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-1355142806c9b5c5	Stratton Substation → Bunsen Substation	138	ambient_adjusted	ieee738-hrrr-v3	1	20.369	0.8931	60	1000	101325	2.9128	19.9417	101325	-164.9707	-97.879364	27.621935	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-134e507bd857c76f	69 kV transmission line	69	ambient_adjusted	ieee738-hrrr-v3	1	11.2108	0.8931	60	1000	101325	3.8222	161.9685	101325	90.353	-98.361086	33.496425	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	69	0.0183	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-0e2fc9e543736247	69 kV transmission line	69	ambient_adjusted	ieee738-hrrr-v3	1	11.4309	0.8931	60	1000	101325	3.7307	153.452	101325	132.0394	-97.824115	33.606875	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	69	0.0183	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-12e4037f31536539	Greens Bayou 69kV Substation → Channelview Substation	69	ambient_adjusted	ieee738-hrrr-v3	1	18.9552	0.6096	90	794.93	101325	2.9953	58.5059	101325	-118.8386	-95.152424	29.775387	2	ercot-centerpoint-public	CenterPoint	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.6096	90	794.93	75	32.5	true	69	0.0183	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-1257dfe6ef4f54d5	Smith Substation → Stevens Substation	69	ambient_adjusted	ieee738-hrrr-v3	1	20.1089	0.8931	60	1000	101325	3.4385	35.5981	101325	-11.0318	-97.619507	27.86021	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	69	0.0183	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-124e37a9f250bef6	Temple South Substation → Scott and White Substation	138	ambient_adjusted	ieee738-hrrr-v3	1	12.3046	0.8931	60	1000	101325	2.0746	127.6345	101325	18.2933	-97.361236	31.074655	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-11a0a15b95136d4a	138 kV transmission line	138	ambient_adjusted	ieee738-hrrr-v3	1	10.4106	0.8931	60	1000	101325	2.5544	122.5997	101325	28.9062	-95.694122	32.962301	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-130c311b569f4a79	138 kV transmission line	138	ambient_adjusted	ieee738-hrrr-v3	1	17.4591	0.8931	60	1000	101325	2.7076	54.4585	101325	-100.938	-94.923705	29.845583	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-0ff7f0c89a413ab4	Red Bluff Substation → Danevang Substation	138	ambient_adjusted	ieee738-hrrr-v3	1	15.4437	0.8931	60	1000	101325	2.8662	58.6308	101325	179.0804	-96.524826	28.886072	4	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-10b902e0341f77eb	Sulphur Springs Switching Station transmission line	138	ambient_adjusted	ieee738-hrrr-v3	1	10.3008	0.8931	60	1000	101325	2.4986	125.2799	101325	-159.233	-95.615649	33.085302	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	115	0.0277	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-109c3d1c0067a7ff	Andrews County South Switching Station transmission line	345	ambient_adjusted	ieee738-hrrr-v3	1	11.9037	0.8931	60	1000	101325	4.3111	149.7607	101325	156.5556	-102.840469	32.287486	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	345	0.0304	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025
2026-10-19 09:00:00.000000	2026-10-16 08:45:03.967953	2026-10-15 01:57:21.000000	ERCOT	grid-line-1031f57baa9340ad	Central Bluff Substation transmission line	345	ambient_adjusted	ieee738-hrrr-v3	1	10.6689	0.8931	60	1000	101325	3.1873	163.597	101325	158.3465	-100.167048	32.10138	2	ercot-regional-public	ERCOT regional default (AEP Texas table)	https://github.com/NREL/DynamicLineRatings/blob/d8e443eb09e428fb0fc8452370fd72fe8819f927/data/regional_assumptions.csv	20	0.8931	60	1000	85	24.5	true	345	0.0304	public_forecast_fallback	d13f24d6-758a-46fe-9692-8004e05b7181	2026-10-16 10:41:47.391025

Coverage

100.0% complete0 gap days17 days with data

Show coverage history

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

2026

gaplessmore

Related infrastructure data

Related infrastructure data
Dataset	Description
Modeled Line Rating RunsAsk the Grid · daily model run	The execution ledger for modeled line-rating materialization. One row identifies a model run and records its forecast window, model version, mapped-line and weather coverage, output row count, failures, and duration. It provides operational provenance for reproducing and monitoring a published forecast without containing operator or restricted line ratings.
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.